xp_logininfo is missing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leon Shargorodsky - 28 Jul 2008 22:41 GMT

I'm using SQL Server 2000 (legacy system, not my choice), build 8.00.2039
When trying to execute SQL job, I get this error message:

Server: Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 53
The object 'xp_logininfo' does not exist in database 'master'.

I "borrowed" a text of xp_logininfo from another server and tried to create
it in master database:

Server: Msg 156, Level 15, State 17, Procedure xp_logininfo, Line 40
Incorrect syntax near the keyword 'OPENROWSET'.
Server: Msg 156, Level 15, State 1, Procedure xp_logininfo, Line 57
Incorrect syntax near the keyword 'OPENROWSET'.

Please help... thank you!

Leon

Reply to this Message

Denny Cherry - 29 Jul 2008 02:50 GMT

Why is your job trying to get the source code of xp_logininfo?

You can reinstall all the system procedures by running the
procsyst.sql from the INSTALL folder on the install CD.

Denny

>I'm using SQL Server 2000 (legacy system, not my choice), build 8.00.2039
>When trying to execute SQL job, I get this error message:
[quoted text clipped - 13 lines]
>
>Leon

Reply to this Message