I'm not sure I understand the question...To get the name of a sql server, you can use the

SELECT @@SERVERNAME

Here are the fields it currently has:

Plan Name:

Server Name:

Activity:

Status:

End date:

Start date:

Duration:

Error Number:

Message:

The table on the Master server is msdb.dbo.sysdbmaintplan_history

You should be able to get the info from the Master.

I believe that within the maintenance plan you can designate the table you want to populate with your data,...

One thing you can do is set up a Multi-Server administration system, having one server designated as a Master (MSX), and the rest as Targets (TSX). Then, you create a...

This probably will not anwer your question directly, but its a solution I'm implementing for the same problem. My problem is the user id on Outlook 2000, vs the SQL server...

Its a share to a 4690. Don't know why, but the only way to get SQL to mount the share, and to be able to write files to it, is...

sp_revokelogin  worked. Thank you!

I'm afraid that did not do it. This user refuses to go away!

Thanks for all of your help.

The solution was to change the SQL service account, not the agent account, to run under the local service account. Previously it was running under...

I tried both. NT had admin rights, and also the SA SQL user login.

The shared folder is open to everything, and is an NFS share on a 4690 box.

Read the...

I recently deployed the Mutli Server (MSX/TSX) architecture, in an effort to manage/administer about 300 servers. It is working very well, and does track agent jobs pushed out to the...

That worked! Thanks!

Not sure if this will help, but make sure you log on to the server through the Console session. Do a Start, Run, and type MSTSC /CONSOLE enter.

Thanks, should have found that one myself.

I'm testing using a UNC. The share is a unix share on a 4690, and it seems like writing files to the share is significantly slower than writing files to...