debugging stored procedure with SSM studio?

Hi,
I know that it 's possible to debugg stored procedure with VS 2005 and is
there a way to do it with SQL Server Management Studio?
Thanks in adavance,
Laurent
Laurent,
check this link
http://msdn2.microsoft.com/en-us/library/ms241871
Markus
|||Sure, but I would like to work just within SQL server Management Studio.
<m.bohse@.quest-consultants.com> a crit dans le message de news:
1132055397.773192.152280@.z14g2000cwz.googlegroups. com...
> Laurent,
> check this link
> http://msdn2.microsoft.com/en-us/library/ms241871
> Markus
>

Debugg prev.

Hi ALL,
What is the minimal prev. required to debugg a stored procedure in SQL 2K.
Thanks
HariThere isn't anything specific that is required. In case of SQL Server
Service pack 3 this feature was disabled by default. Hence you need to
enable the same. Apart from that I dont see a pre-req you need to stare on.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ubAlNyB1DHA.2972@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hi ALL,
> What is the minimal prev. required to debugg a stored procedure in SQL 2K.
> Thanks
> Hari
>

---

|||Thanks Vinod.
The information I got regarding Debug prev. is,
1. The user should be in Master database
2. The same user should have Execute permission on system procedure
"sp_sdidebug" in master database.
Regards
Hari
MCDBA
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:uUaTF9E1DHA.1188@.TK2MSFTNGP11.phx.gbl...

quote:

---

> There isn't anything specific that is required. In case of SQL Server
> Service pack 3 this feature was disabled by default. Hence you need to
> enable the same. Apart from that I dont see a pre-req you need to stare

---

on.

quote:

---

> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:ubAlNyB1DHA.2972@.TK2MSFTNGP09.phx.gbl...
2K.[QUOTE]
>

---

Debugg a large Stored Procedure

Hi,
Is there any way I can debug a large SP? Right now I am using print and
select statements to output the value, but can I do it like normal
programming language, set up break points, watch varaible values......
TIAQuery Analyzer, hit F8, find a stored procedure, right-click, Debug...
Visual Studio might have some facility for this as well.
"Ed Chiu" <EdChiu@.discussions.microsoft.com> wrote in message
news:DBC274B3-9FCD-47D1-8284-B190B1ACB5B9@.microsoft.com...
> Hi,
> Is there any way I can debug a large SP? Right now I am using print and
> select statements to output the value, but can I do it like normal
> programming language, set up break points, watch varaible values......
> TIA
>
>|||http://msdn.microsoft.com/library/d...asp?frame=true
David Portas
SQL Server MVP
--
"Ed Chiu" <EdChiu@.discussions.microsoft.com> wrote in message
news:DBC274B3-9FCD-47D1-8284-B190B1ACB5B9@.microsoft.com...
> Hi,
> Is there any way I can debug a large SP? Right now I am using print and
> select statements to output the value, but can I do it like normal
> programming language, set up break points, watch varaible values......
> TIA
>
>