I will give that a try thanks.

I am new to SQL... How do i do that?

Now it all makes sense!

1. tempdb is recreated at it’s initial size when SQL starts.

2. Objects in tempdb disappear when the connections are dropped. Unless they are global...

I am new to SQL Server so I don’t think I am doing anything out of the ordinary. I am creating and deleting a lot of tables and #...

Thanks. Just wanted to make sure my logic was ok.

Can some one clarify this For me. If the tempdb database is re-created every time SQL Server starts and the server is never turned off. When does SQL refresh the...

Very good article and site. Thank you.

I am running SQL 2005. But youdid give me the hint that solved the problem. My external drive was formated FAT32. I needed to change it to...

On the database properties page Files tab the the Data, PRIMARY IS SET TO BY 10 PERCENT UNRESTRICTED.

The log file is set to Log, Not Applicable, unrestricted growth set...

This is a new external 500G drive and is empty.

I am looking at the General tab. Every thing is disabled and I don't see anything that looks like restricted...

Thanks for catching that typo. I also found another fat finger mistake that was causing my result set ont to be correct.

Thanks for catching that typo. I also found another fat finger mistake that was causing my result set ont to be correct.

I have looked at dynamic SQL before so I think I have a handle on that. Your explanations of the details is very helpful. I will be able...

I will have to spend some time with this one. I am not sure how it gets teh column names or placeses MAX on every column name. But if...

Yes I see where that will work. I'll give that a shot. thanks