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 |
|
daidaluus
Yak Posting Veteran
73 Posts |
 Posted - 2007-08-21 : 07:27:54
|
| In SQLServer 2000 I could easily debug a stored procedure from QA. But I dont know how to debug a sp in SQLServer 2005. I could find nothing to deal with it in SQL Server Management Studio. Can anybody tell me how to do it? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-21 : 07:35:27
|
I think you still connect QA against a SQL Server 2005 database, can't you?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2007-08-21 : 07:41:29
|
| Amazing. I thought there is no QA available in 2K5. Can you tell me where can I find it? Or is it with a new name? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-21 : 08:40:19
|
You have to use old SQL Server 2000 QA. Install this tool only from CD.I have both QA and SSMS installed.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-08-21 : 08:40:52
|
| When u opens management studio in SQL 2k5 u can see an option named new query click on that....open the respective databse in gui there is an option called programmability expand that there u can see stored procedures...RKNAIR |
|
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2007-08-21 : 09:38:38
|
| Thanks Peso. I have both SQL2K and SQL2K5 installed on my machine but i dont see anyway to connect to my 2K5 server from QA(2K). can you tell me how can I do this task? and I wonder why I cannot debug a SP directly from 2005 environment. |
|
|
|
daidaluus
Yak Posting Veteran
73 Posts |
Posted - 2007-08-21 : 09:48:02
|
| Yes I can connect to SQL2K5 by QA with windows authentication mode but when I want to debug a SP it gives me an error that says "You must use SQL Server 2005 management tools to connect to this server" |
|
|
|
|
|
|
Debugging