Prev: live online training
Next: "Maksanhierontalaite" ; )
From: nambia05 on 10 Jun 2008 07:27
Is there a way to look at the internals of built-in stored procedures
and see what they are doing? sp_help provides little information.
From: Plamen Ratchev on 10 Jun 2008 08:18
Take a look at sp_helptext, it will show the definition of the stored
procedure if not encrypted.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

From: Philipp Post on 11 Jun 2008 09:17
> Is there a way to look at the internals of built-in stored procedures and see what they are doing?  <

If you are using SQL Server Management Studio 2005 you could simply
right click on these ones and select "edit" and see the source code
for a lot of them (if they are not locked)

brgds

Philipp Post
From: Kevin Zhong on 14 Jun 2008 23:57
On Jun 10, 7:27 pm, nambia05 <nambi...(a)yahooo.com> wrote:
> Is there a way to look at the internals of built-in stored procedures
> and see what they are doing?  sp_help provides little information.

you can used the sp_helptext to help your.
 | 
Pages: 1
Prev: live online training
Next: "Maksanhierontalaite" ; )