Have you compared the execution plans between the different queries?

CirquedeSQLeil (2/19/2010)

---

jcrawf02 (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

Grant Fritchey (2/19/2010)

---

If you haven't submitted anything to Tony Davis at Simple-Talk, head on over there. His editing process can feel a bit like a prison rape,...

Good blog. I think I'll focus on the articles for a bit more.

tke402-837787 (2/19/2010)

---

Thanks SSC-Enthusiastic

I ran the script on the secondary server master db and received a bunch of errors:

Terminating this procedure. The User name 'db_accessadmin' is absent or invalid.

Msg 15291, Level...

Alvin Ramard (2/19/2010)

---

Lynn Pettis (2/19/2010)

---

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. ...

What recovery model is the database using?

Actually, that's the best time to build them. You know the sea won't wipe them out later. It's building them...

CirquedeSQLeil (2/19/2010)

---

Lynn Pettis (2/19/2010)

---

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. BTW...

I need you to do two things. On Server B, go to the Program Files directory and drill down into the Microsoft SQL Server directory. As Maintenance Plans...

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. BTW - very funny...

My Windows Server knowledge is old, but it is possible you may need to wait until the login info as replicated with the domain. Beyond that, as I said,...

Can I ask why you can't get SSIS installed on Server B? You indicate that you are the admin on this server.

Get the admin with you as you attempt to add the user in question. The problem you are encountering is not specific to SQL Server but its interaction with...

You need to check with your network or server admins, or who ever is responsible for creating the Windows accounts.

A little more information would be helpful. When you say you can't login, are you saying you can't access a database on the second server that was restored from...