how can we debug an SP - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

how can we debug an SP

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-09-25 : 09:59:20

Is there a way like we do in programming or even bettre. Is there any better practice for this.
Thanks

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-09-25 : 10:01:10

There is a debug option in QA, where you can debug the proc.. its somthing similar like any front end dubing..

Though i never used it :-), i normally use series of print statement for debuggin an sp, which normally works for me..

Chirag

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-09-25 : 10:04:13

can u explain pls both options a bit more. how to do them
thansk man

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-09-25 : 10:11:14

for debugin using QA have a look at following site.

http://www.15seconds.com/issue/050106.htm

for checking the particular value in the variable put print variable and then in the message section of the QA you can view that and can debug your sp accordingly.

Chirag

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources