Barry,

Of course it wouldn't be reliable, I mentioned it.:D Actually that is interesting, I may have to find a way to test that out. I know I...

Chris Morris (1/5/2009)

---

RBarryYoung (1/5/2009)

---

Actually, no. I really do not know much about it, particularly how to fix it. I just have seen this one posted so many times...

Michael Ross (1/5/2009)

---

How many of us have built something and left only to come back to see it completely bastardised? Before we start blaming all the morons for ruining...

Timothy (1/5/2009)

---

The rest of the time I rely on properly named classes, methods, and variables. In a sense the code is self-documenting. I often use names that are longer than...

There are several articles on this site that you may find helpful, here are a few:

http://www.sqlservercentral.com/articles/Administration/61319/

http://www.sqlservercentral.com/Authors/Articles/BuckWoody/61051/

http://www.sqlservercentral.com/articles/Career/61535/

http://www.sqlservercentral.com/articles/Administration/64732/

C'mon Barry, sounds like a topic you could handle as well.

You definitely do not want to try to start an SSIS package from a trigger. If that fails the entire transaction will be rolled back. Since DB Mail...

Does the report server service account have rights to the printer?

Just to pile on, normally in these cases it is Parameter Sniffing.

David's suggestions are valid as well, particularly about comparing execution plans.

I have tried several free and not free schema comparison tools and I believe RedGate's SQLCompare is the best and worth the money. ApexSQL's SQLDiff is not bad and...

You can list several queries in the @Query parameter. I'd separate with either a GO or a ";", but white space works as well.

You never answered Gail's question. In my experience, it has usually been a reindex operation that has...

You can use Query Analyzer to query msdb.dbo.sysjobhistory and sysjobs and set the output to a text file.

I don't believe this is possible, but it has been awhile since I tried it.

I guess I disagree with Steve a little on this one as I believe that documentation/comments should be written so someone below your level can understand the code. I...