I went into the maintenance plan in EM and deselected one of the databases. I then started the job in EM and everything ran just fine.

I have no idea...

That did it (Make sure you're in the msdb database.)

Thanks,

Howard

When I try EXEC sp_help_job in Query Analyzer I get the following message:

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'sp_help_job'.

I am running MSSQL 2000...

Thank you. This will work just fine.

Howard

Mike:

I just found a problem with your query:

select (select  sum(Amount)

          from  AR_Transactions

         where  Customer_Number = @C) +

        (select sum(Amount)

          from  AR_Post_Dates

         where  Customer_Number = @C)

If...

Mike:

Superb...It works perfectly.

Thank you very much for the help.

Howard

Mike:

When I go to my local server and perform Start, Programs, Microsoft SQL Server, Server Network Utility, I get an error box with 126 in the Title and "The...

Mike:

svrnetcn.exe is on the remote server but not on the local server. Do you know how I can load the program onto my server?

Howard

Mike:

I believe that you are on to something. However, I believe that it has to do with the Server and...

Mike:

I understand what you are saying but I can still find no differences between the two servers with the following exception:

select * from sysprocesses on the remote server returns the nt_username...

Mike, listed below are your questions followed by my answers.

-Do you know how the application logs in?

Standard SQL Server login.

Mike:

You said,"That's the problem, Howard. Your application logs in using standard SQL Security, using the same username for all users.  In that case, nt_username column will be NOT be populated. The information...

Mike:

Thank you for your response. The reason I want the nt_username is this is the only way I can determine what individuals are logged into the database. The loginname is...

Thank you for the detailed response. The information you supplied is very useful. However, I still need to retrieve the nt_username and what I do not understand is why I...

Dosen't referential integrity come into play here? If the table you are going to modify has foreign key constraints related to it, won't referential integrity prevent the table from...