Wasn't expecting it to be me.

We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???

Is this single user id a windows login or a SQL login? If a SQL Login, the problem you are encountering is that the SID of the user id...

PowerPivotPro (9/15/2011)

---

TRADES!

Let's do some trades this year. Makes it more fun.

I'll try to jumpstart things. Who needs an RB? I've got Reggie Bush for offer,...

PowerPivotPro (9/15/2011)

---

TRADES!

Let's do some trades this year. Makes it more fun.

I'll try to jumpstart things. Who needs an RB? I've got Reggie Bush for offer,...

Starting off slow this time. Looks like I may be needing a kicker.

Congratulations Jeff! Well deserved award!

I know I have learned much from you over the years.

SanDroid (8/25/2011)

---

Steve Jones - SSC Editor (8/25/2011)

---

It's not a big deal, and he has a bit of a point. None of the answers is well written, as noted by Hugo.

Leave...

You never know, you may find it fun to do both. ...

How was the migration completed, detach/attach or backup/restore? If the later, are you sure the restore was from a current (just before migration) backup?

Jeff Moden (8/23/2011)

---

IceDread (8/23/2011)

---

Hehe, getdate() however reads the clock from windows and if you change that one you are screwed.. that sql server relies on the os operated clock is...

I have seen a maintenance task not delete an old backup file that had been restored to a server after it had been deleted previously by the maintenance task.

How old...

Had a similar issue at a previous employer, turned out the port on one of the switches was set to half-duplex. Just an idea.

If Books Online is not installed locally (desktop or server), it is available on the internet on MSDN. If you can post here, you can get to the online...

Took a look at your other post. If you read between the lines it does appear that you had done some research already withoutspecifically stating so.