Something like this?

-- Temp table to store result

CREATE TABLE #DF_Result

(

Drive_Letter CHAR(1),

MBFree INT

...

Is there a question here? Not a lot of info - and, this is the sql 2005 forum group...

I found this article from our very own Brian Knight.

http://www.sqlservercentral.com/articles/Administering/readpurgelog/279/

Jeff Moden (3/31/2008)

---

Cory... I've not had to use the SQL Log File Viewer before... I've had to use the Error log before. Are they the same? If not,...

Usually, there needs to be an existing SP prior to running a SP:cool:. sp_track_db_growth is not a SP that exists. Perhaps you would be kind...

Well said - I am in that boat as well...I am nearly 33. Taking one class a quarter would take about 7 years...Do I want to be 40 and...

An option - you could make a view that has the columns defined in the order you want.

Also, I think it has been fairly well discussed that "Select * from...

Thanks everyone! This really helped! I will begin looking into all that today!

Hey Matt -

Thanks for the input - that is another reason that I didnt mention - I was not sure if that was a common practice or not, as I...

I have always felt that experience is better than paper. I am not looking for a job, at least not now. I am looking to make sure I...

Jeff Moden (3/30/2008)

---

Why do you feel like the "green guy"? Why do you feel like you need a degree to keep up with those that have one, especially in...

Jeff,

I am sorry, I re-read that this morning - I did not mean to sound offended, I am truely...

WOOHOO!! I got a "Mighty Close" by Mr Jeff M himself! Thanks!

As far as the post - When I first read the post, I admit, I did not...

I could VERY well be wrong on this, as I am just starting to work with CTE's, but something like this may work...

WITH TEST_CTE_Insert ( INSTRUMENT_ID, PARTY_ID,...

I am fairly sure the answer is no. the log files are located ..\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. I think there are ways to query these log files, but,...