And the technology is getting better and better. Some of these new SSDs have great specs.

Love those Jack Reacher novels. A welcome break from the real world.

Working under pressure and stress is something you have to be able to do in IT, but managers have...

A lot more, but that's changing. We might get SSDs sooner than we think.

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...