Got it. thanks for the help!

nevermind, i got it.

I am running into the same exact situation.

I have a ASP.NET web app that calls to a SP to execute an Agent Job which involves 3 steps. Each step execute...

stop your sqlserver

delete the tempdb.mdf under your program files\Microsoft SQL Server\MSSQL.x\MSSQL\data folder

restart your sqlserver

this will recreate the tempdb back to the initial size by default (8MB) if you didn't change...

Thanks! It works like a charm.

Thank you very much for teaching me. Got it working, thanks again!

Thanks, it worked out good. I am running into another problem however if anyone can point me to the right direction. That would be much appreciated.

Now I have a table...