Multiserver administration means that the services running SQLAgent must actually connect to other instances. LocalSystem isn't an account that can connect to other servers. You will need to change the...

you could call a VBScript/Powershell file to do this, calculate the date and delete the file. That might be easier.

Or use an SSIS package to do this. Maintenance plans have...

Can you translate the error?

Does the Add linked server section work? Does this appear in SQL Server?

If these need to always happen, why not add Profile to the first table, give it a default value of a space?

You could use a trigger to ensure a...

Please watch the forum title and post in the appropriate forum. Moved to T-SQL forum.

I'm not sure what you're calculating there, but it's not a percentage.

Percentage is (valuea/valueb) * 100.

What about a fast triangular join? Maybe it will flatten out to a linear algorithm :hehe:

If you get something to work, I'd be interested to see what happened here.

And good luck

You should probably read the security sections in Books Online to understand this. Not to beat on you, and I know you just want to get something working, but not...

You can also see the code in the master database. I thought that 'domain\user' would work, but perhaps it's user in the database and not login.

You can always call Microsoft PSS and perhaps they can help you with getting some data, but we can't do anything with had header files.

And please make an attempt to do the work. This almost sounds like a homework or exam question.

Hint: Use UPDATE for the SQL side.

I haven't seen this before. My guess is that you didn't complete something on the first instance that was installed. Did you install any hotfixes or patches on that first...

The paths from EM are paths that the SQL Server service account sees, not what your account sees. Don't forget this is a server service, it is not running under...

It sounds like a tool corruption issue or perhaps memory on the workstation. Are you opening SSMS from the console or your workstation?

I have used MOM briefly and What's Up Gold, but not Idera. You can download an eval and give it a try. See what you think. Most of these package...