mssql_query and create/drop procedure

[BB101]

I'm not having much luck running perfectly fine and tested piece of SQL with PHP to create or drop a stored procedure.

Has anyone else encountered this? Are there any work arounds?

Thanks --BB

 

[sleipnir214]

If I may ask, why would you be programmatically dropping a stored procedure in the first place? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BB101]

It's for a client so he can update his system, it'll be a once run program, that is all. --BB

 

[sleipnir214]

Are you getting any error messages? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BB101]

No error's, but it's returning false and not actually doing as its told! --BB

 

[BB101]

With help from mssql_get_last_message() i found the word GO cocks things up for PHP.

Thanks for the help anyway. --BB