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]
>

---