GilaMonster (2/18/2010)

---

No, no, no. You obviously didn't notice the side mention...

You should be able to use Data Collector. Developer Edition has all the functionality of Enterprise Edition, just that it can't be used in a production environment.

Help!!!! My halo is blowing away!!!!!!!

Deleted.... Wrong thread....

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL services, should fix...

I just wish the OP would check/post what is in the error logs. That could help answer many questions and provide him with some valuable responses in return.

At a lose right now. I had a glimer of an idea but it fled away into the desert (inside joke).

If I can think of anything I'll pop back...

Should we be working on the SSIS packages now to extract the data from the databases? 😛

[ apologies ]

I'm sorry for the sarcastic comments in the last two posts,...

Next post: How do I prepare for an interview... 😛

I've heard it could be political as well.

Matt Miller (#4) (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

First, make sure you have at least two ways to login with sys admin rights. One way is to have a group created and...

Jack Corbett (2/18/2010)

---

Alvin Ramard (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

Grant Fritchey (2/18/2010)

---

Roy Ernest (2/18/2010)

---

There are couple of guys/ladies here in this forum who have done quite a bit for the community and have...

CirquedeSQLeil (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

Plus, from everything I have seen here on SSC, you don't even know you have been nominated until you have been awarded MVP. So, with that...

First, make sure you have at least two ways to login with sys admin rights. One way is to have a group created and have the DBA's assigned to...

tke402-837787 (2/18/2010)

---

thanks for the replies.

I tried the orphaned users resolutions and this account did show as orphaned but after running EXEC sp_change_users_login 'Auto_Fix', 'user' the account still does not...