I have created a new job wich runs sp_help_revlogin script.   Every output
line of this script, and from what I understood any other script which
produces output, is appended with [SQLCODE 100000] string.

How can I prevent it from appearing?

Thanks in advance

Hi RG,

I understood your job will be interrupted while running sp_help_revlogin.
If we put it in a stored procedure, will it report the same error message?
If we are using other stored procedure instead of sp_help_revlogin, will it
also produce this behavior?

What's the detailed error message? Would you please clarify it more
clearly? More detailed information, I believe will make us closer to the
resolution.

BTW, please understand sp_help_revlogin is not a documented stored
procedure, which we do not guarantee the usage.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Can you reproduce an example of one of the "other" scripts that shows this
behavior?  I've ran sp_help_revlogin numerous times and have never come
across what you are discribing.

As I do not want to comprimise your system's security, any other script that
returns values as you are discribing should be sufficient.

Just show us the script and then the output.

Sincerely,


Anthony Thomas



I have created a new job wich runs sp_help_revlogin script.   Every output
line of this script, and from what I understood any other script which
produces output, is appended with [SQLCODE 100000] string.

How can I prevent it from appearing?

Thanks in advance

MS PSS-What the heck is this?!
Basic question.... on Index....
Problem with osql.exe -L
full drives full trans log version 7
alter table drop column and dbcc cleantable
Simple Question: What's the best way to duplicate a DB under another name?
stored procedure with different criteria
Server: Msg 7391, Level 16, State 1, Procedure <OBJECT>, Line
SQL7 2 DB files down to one???
varchar vs nvarchar