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 |
|
newnuts
Starting Member
4 Posts |
 Posted - 2007-01-30 : 01:36:47
|
| Hi AllIs there any Tool available To Test Stored procedure in SQL server?Thanks in AdvanceAbin |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-30 : 02:08:21
|
| What would you like the tool to test?The best tool is your brain, by the way.Peter LarssonHelsingborg, Sweden |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2007-01-30 : 04:10:01
|
DO you mean by debuging SP? Here it is1. Open Query Analyzer and connect to a database of interest. 2. Open the Object Browser by pressing [F8] or going to Tools | Object Browser on the Query Analyzer menu. 3. Select the stored procedure of interest. 4. Right-click on the stored procedure's name and select Debug from the pop-up menu. Njoy Life  |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-30 : 04:15:52
|
| If you want to unit test your SPs, you can give a try to TSQLUnit testing framework. It is available at the following link:[url]http://sourceforge.net/projects/tsqlunit[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-30 : 13:12:20
|
"The best tool is your brain, by the way"... unless you have to do the same test over-and-over-again, every day ...  Kristen |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-30 : 14:40:31
|
| What I meant was, is there really a tool that can measure all aspect of what a stored procedure can perform?Can it measure index use? DDL statements, validate dynamic sql statements?deletes and inserts on linked servers?adding users? dropping tables?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Tool To test Stored procedure in SQL2000?