Your problem sounds a lot like the problem that I have had for years.

Every time that the server is rebooted, email notifications from scheduled jobs stop.

I have to stop...

I get the following sql error message when running the script in SQL Server 2000 Query Analyzer or 2005 SQL Server Management Studio Express.

Server: Msg 197, Level 15, State 1,...

Thank you.

This was very helpful.

Howard

TCP/IP

NO, on those rows where the nt_username and loginame are both populated, they are NOT the same?

Each row that returns the nt_username reflects the different users.

The loginname IS the same...

The program uses the following to connect to SQL Server:

Server Name

User Name (Not the Windows user name but the SQL Server user name)

Password

This is what is used to connect to...

The connection is through the application and not through ODBC.

I guess my questions comes down to this.

If all users use the same program to connect to SQL Server then why...

All users run the same program which authenticates with the same MSSQL 2000 user and not the Windows user.

Howard

I am getting the nt_username on all logins except for the two new computers.

Howard

You asked, "what is populated in the loginame field?"

The loginame contains the SQL Server login name. Every row returned from the query shows the same SQL Server login name (In...

I have determined that the missing nt_username has to do with the PC workstation and not the user.

Background on the problem.

All users run the same program which authenticates with the...

Damon:

Thanks for help. I tried your enhanced script but still no luck.

I am running MSSQL 2000sp4 on Windows NT4.0sp6a.

Also, the missing nt_username only ocurrs from the two new PC's just...

I have tried both of the above scripts and the majority of the result lines display the nt_username but in some instances where the nt_username should be displayed it is...

Thanks to everyone for the answers and advice.

Howard

I have tried the following but the result ignores the carriage return line feed:

TSQL:

DECLARE @print_line VARCHAR (30)

SET @print_line = 'Line 1'+ CHAR(13) + CHAR(10) + 'Line 2'

SELECT @print_line

Result:

Line 1  Line...