You'd need to build a dynamic SQL statement for each database and use that.

But don't do it!

Automatically truncating and shriking log files is a really, really bad idea. It...

Why use Case for that? Why not IsNull or Coalesce?

More like "writeless". 😀

It sounds like you've got a good start on it.

To keep going, just keep one thing in mind: You'll get out of it what you put into it.

If you want...

If you have DDL logging (from triggers), you can use that.

If you have a DDL trace running, you can use that.

If you have a log parser, you can use that.

That's...

Nothing to say on this one except, "I agree".

Quickly Confused (8/3/2009)

---

That's a good summary, Gus. We had some developers create scalar-valued UDFs (which contained queries) to simplify/standardize their final queries. That way, instead...

RBarryYoung (7/31/2009)

---

I've always had the impression that Triggers had more overhead and would be slower than stored procedures. Of course, depending on how long this Excel File work takes,...

Luke L (8/4/2009)

---

I really think my asking this is more for me than her, know that there are others thinking and praying for her helps me cope easier. Sounds...

Where I've found the XML data type useful has been in situations where you can't control schema changes to a relation (table) and want to record all data from it...

You're welcome.

Well done on solving it. And thanks for posting the solution.

shiv (8/3/2009)

---

Hi Every body,

In my transaction two locks occured IE(Inetent Lock, Exclusive)

How can we slove this prob...

I think the whole thing is based on a set of common misconceptions on what a craftsman is vs what an engineer is, and on an overly broad set of...

Adam Gojdas (8/3/2009)

---

I know this takes the topic a bit off course but I couldn't resist since it is in regards to "professionals".

Craftsman is a highly respected brand of tool,...