To get the file names for all 120 log files, you'll need to run some type of query to pull them out of sys.database_files. If you just wanted to truncate...

Just a bit of a gui glitch. You really can not edit those procedures.

Be very careful where you install it. In other words, don't do what I did. I'm going to have to reimage my laptop.

You can also go here to use virtual...

It did irk me to see backups as a myth because we regularly test our backups by restoring for development and as part of training. That's one point that is...

Oh yeah, code reviews... and beatings... I forgot about the reviews.

One other option that occurred to me (besides more beatings) was that you could set up the security in the...

Also please don't cross-post since I tried to answer this same question over here:

I think inflicting a severe beating prior to requiring him to rewrite his code is the correct response. But assuming you don't want to risk prison time, you could use...

You really shouldn't cross-post questions.

I gave a possible answer over here: http://www.sqlservercentral.com/Forums/Topic439862-360-1.aspx

By "respond in XML" do you mean that your output from the query should be in XML?

If so, look up FOR XML in BOL. That'll get you started.

You have nesting occuring in triggers on your database. You need to examine the code that is being called and examine the data structure to see what triggers you might...

Excellent.

But that doesn't explain why a couple of gb file fills up 20gb of tempdb... I still think something else must have been going on.

Good gosh no, I'm not upset. I just realized that simply saying over and over again "Service Account" wasn't being very clear. So I decided to be clear as crystal....

I had never heard of that before. Extremely useful information. Thanks for putting it up. Makes the decision to keep hyperthreading off production even better.

What's the context that the "index group" is mentioned? The only thing I can find referencing is in the dynamic management views for looking at missing indexes. According to Kalen...

Are those two seperate fields? If not, ORDER BY with a TOP will get what you want. If what you're trying to do is find all the records for a...