As with all of the others, congrats guys.

You contributions to the community have been and are very well appreciated.

-Luke.

I gotta agree with the whole I don't really care what you call me bit, but by the same token don't treat me like some kid fresh out of school...

Once upon a time I used to use DTS to connect an RMS database to a postgreSQL db. I think that was pgSQL 7.1 or perhaps earlier.

The biggest problem...

Yeah, so I'm a bone head. There's a description option that can be set in the report properties for those who might like to know.

Thanks.

-Luke.

I'm guessing you already installed SP2? Did you do the database upgrade after the Service Pack? That threw me a bit the first time I saw it, but...

I believe you could do what you are looking for with a matrix.

http://msdn.microsoft.com/en-us/library/ms157334.aspx

I would imagine that the mdf's would be locked and in use as long as the SQL Server service is running.

Here's a snippet from DisKeeper's FAQ page which isn't exactly...

I whole heartedly agree with Jack. I think I'm a decent writer, or have been told so, my biggest problem is finding a topic to write about. Whenever...

Gotta throw one more on the pile. Greta Article Jeff. I've been using Numbers tables for a while now, but this is the best explanation I've ever seen...

I vaguely remember some reference to 5 mil rows or something...

So Just outta curiosity, would the lowest MID value be the "first" record. I know this has already been...

See my replies to this thread...

http://www.sqlservercentral.com/Forums/Topic494133-65-1.aspx

additionally most of the items you are looking for can be gotten from querying the system tables and/or Management views in 2k5.

You could write...

Specifically the health type ones can be foudn here

http://www.microsoft.com/downloads/details.aspx?FamilyID=a4b837c7-a1fa-4f25-840b-fef15e917f18&DisplayLang=en

Other report packs can be found here

http://www.microsoft.com/sql/prodinfo/previousversions/rs/downloads.mspx

-Luke.

It seems that you answered your own question in one of your previous posts.

You're creating a Temp table (or adding a column to your...

Glad it worked out for you.

-Luke.

When you are setting your 'Excel 8.0;Database=@ExportLocation', You are having the problem where it is attempting to evaluate your variable as plain text, not the text stored within the variable....