You don't quite have enough information. Is there not a key in the positions table? Is it allowed that there are multiple positions with a department? There's not enough sample...

Right now there's a legal challenge as to the rights of MERS to sign foreclosure documents, but there have been mistakes made, and someone is challenging the accuracy of data...

Indeed, that's a tough one. I've dealt with those migrations. that is a case where you wish you had GUIDs

The copy will no degragment the file. It might move the various segments on disk around, but it will not move the internal allocations.

You need to rebuild clustered indexes to...

I think that we'll get back globally at some point. Maybe not the same point for all countries, but the economies will rebound for most places.

I've seen and heard doom...

If you want to delete the old backup first because of space constraints, make sure you have it on another server. Because your server will choose to fail right between...

I watched the last 4 innings Sat night of the Giants/Phillies game. Fantastic ending. Can't believe that Howard didn't swing. He'll be thinking about that for a long, long time.

The agent can't log into other servers: no rights.

However, you can proxy a job with another account. http://msdn.microsoft.com/en-us/library/ms189064.aspx

I figure I can just fix the hunter's computer and let him get me a cow 🙂

I think it's more like "do it for...

Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.

I agree with Gail, no additional licensing cost. It's possible that the person is thinking of Oracle, or some other platform. Or thinking that a separate instance is needed for...

Strange, I've seen something similar, but usually gotten some type of SSPI error in the event logs. It almost sounds like some strange corruption issue, but it seems that the...

There's no other way. If permissions will allow people to add/remove columns and you cannot handle this administratively (manager talking to them), then you're stuck.

Ultimately this is a reason to...

That is strange. A couple questions

1. What's in the Event logs? (System and security)

2. Have you tried more than one account, or just the one. Could there be some computer...