Thanks for the test. I've seen this before and can usually insert a space or two to clean it up.

There's a [ code = "sql ] tag to the left when you post. Use that. (spaces added so you can read this)

Derek Dongray (7/15/2009)

---

It is embedded HTML. If you look at the source of this post (753126) You'll see that what appears as

should actually have the characters < /...

How are you loading the data? Or querying it, which is what I think you mean.

You can compare the default session settings in SSMS as well. Right click server, properties,...

I know there are people using these to enforce naming of objects.

There are also people that use this to ensure that new instances are configured according to some rules they...

My guess is your database is in the full recovery model and you are not making log backups.

The short answer is that you should:

1. Backup the transaction log with truncate_only

2....

First physical drives matter. If you have 20 logical drives on the SAN that all are built on the same physical drives, you aren't helping.

You have to clarify what you...

A logical drive is a partition of a physical drive. It can be a complete partition of a drive or a partial partition.

A physical drive is where you determine performance....

It's a way for your to consume system data from a view, instead of having to parse results from sp_configure.

I assume you mean created 3 years ago or earlier. Lee's code should do that.

There is no benefit. A logical drive is an administrative item in Windows.

I would not think it would continue to hold a lock from that statement, but as Luke mentioned, it depends on what else is happening in the procedure.

It doesn't mean anything. You need to enable logging in the maintenance plan and then examine the text file log. The SQL Agent log is useless.

You typically do not "open" system tables, especially in SSMS since that is an editing window.

Most of the information from system tables appears in SSMS. What exactly are you trying...

That happened to me as well, Grant. Had to email them to get it fixed. took about a day.