Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
THNQdigital
Starting Member
15 Posts |
 Posted - 2004-02-19 : 08:09:21
|
| Hi Team,i have a weird problem. i work on MS SQL server 7.0 and i have a database whose compatibility level is set to 65i have several stored procs , at times when i have to debug them i say Sp_helptext storedprocname , copy the proc , paste it on query analyzer and then start debugging..Problem is : i get lot of syntax errors when run in query analyzer, though the proc works just fine when called from an vbscript in a batch file. This is real painful as i cant get to the root cause, before that i will have to fix the syntax problems ( like putting sql statements in single quotes assigning the statement to a var and ten say Exec(sqlstring)just wanted to know if someone has experienced the same ..in case if my questions is not clear, please let me know, i can give an example like what syntax error i get and all that..ThanksTHNQdigital |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-19 : 11:35:48
|
| Script the sproc from enterprise manager then copy[CTRL+C] and paste[CTRL+V] to QAI think there are formatting issues with what you're trying to do.Brett8-) |
 |
|
|
|
|
|
MS SQL Server - DEBUGGING a stored proc