Post reply

Can not get system stored procedures text in SQL Server 2005

  • January 4, 2005 at 3:30 pm

    #108920

    Hi,

    I wanted to get a text of a stored procedure in SQL Server 2005 and I could not find it. Nowhere to right-click and select properties. I also could not use sp_helptext. It would say

    Msg 15197, Level 16, State 1, Procedure sp_helptext, Line 95

    There is no text for object 'sp_adduser'.

    I am perfectly able to run sp_helptext 'sp_adduser' in SQL Server 2000. This is important because I have to modify system procedures for some applications. I will put the same topic under Development section too.

    Yelena

    Regards,Yelena Varsha

  • January 6, 2005 at 5:29 pm

    #536314

    BOL for SQL Server 2000 says:  "This procedure is included for backward compatibility. Use sp_grantdbaccess."  So maybe they finally took it out in Yukon?

    There is no "i" in team, but idiot has two.

  • January 7, 2005 at 8:45 am

    #536453

    Dave,

    I can not see text of ANY stored procedure. sp_adduser was just an example.

    Yelena

    Regards,Yelena Varsha

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply