Please read this article and supply the information it advises: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told...

Yes, please tell us what you mean by "master" and "transaction" tables. Its not at all clear.

jpSQLDude (2/22/2010)

---

RBarryYoung (2/22/2010)

---

This is a SQL 2008 forum, NOT SQL 2000. Please clarify what version of SQL Server you have.

Also, DTS is pretty awful, the only reason to use...

There's nothing like custom Server roles in 2005+. I would suggest writing a tool or sproc to map a Login to a set of databases for you automatically.

T&HDBNEWADMIN (2/22/2010)

---

RBarryYoung (2/22/2010)

---

well, that should not have happened, unless by "indexes" you mean something other than SQL Server indexes.

Please tell us the exact steps that you followed to restore your...

The ILOVEYOU virus did not work by exploiting security...

jpSQLDude (2/22/2010)

---

AndrewSQLDBA (2/22/2010)

---

I use SSIS for everything. There is just about nothing that I cannot do. Especially with SQL 2005. I can move files around, create directories. You can also...

emblabac (2/22/2010)

---

Well C is the first group in the list (relative to date) ... hence number 1. Similarly for B and D, they are the second and third "distinct" groups...

well, that should not have happened, unless by "indexes" you mean something other than SQL Server indexes.

Please tell us the exact steps that you followed to restore your database.

There two possible general causes for this kind of behavior:

1) Physical Resource Contention: This would be if your big job is using up so much of a physical resource,...

Glad we could help.

Alexander-623609 (2/22/2010)

---

But how do I keep in in scope? With DMO, this was not an issue, it worked just like the SQL QA. There mus be a way to keep...

Oops, sorry, I missed your additional post, Paul...

GSquared (2/22/2010)

---

Paul White (2/21/2010)

---

A much more efficient query plan is produced...