Chris,

Its there in 2005 too.

http://msdn.microsoft.com/en-us/library/ms174396(SQL.90).aspx

MJ

select * from sys.database_files

where file_id=1

MJ

http://www.mssqltips.com/tip.asp?tip=1397

MJ

Anything under about 1000 pages, you don't need to worry about fragmentation .

http://www.sqlservercentral.com/Forums/Topic639788-146-1.aspx

MJ

Anything under about 1000 pages, you don't need to worry about fragmentation .

http://www.sqlservercentral.com/Forums/Topic639788-146-1.aspx

MJ

Anything under about 1000 pages, you don't need to worry about fragmentation .

http://www.sqlservercentral.com/Forums/Topic639788-146-1.aspx

MJ

Please mail me at manujaidka@gmail.com. I might be able to assist you here.

MJ

Ghanta,

Please try the solution suggested by Sergiy at http://www.sqlservercentral.com/Forums/Topic18289-8-2.aspx

It works for me.

Manu

Is it patched with SP2 for sql server 2005?

Manu

Kill the spid that comes in the output of below query:

select * from sys.sysprocesses

where dbid=db_id('DatabaseName')

MJ

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\In my it was first instance(MSSQL.1)\MSSQLServer\Parameters\ SQLArg3

MJ

Try to run a profiler with filter on tempdb database and see what is consuming space there in ie.

Don't forget to include the events like:

Under Database Evnt Class

Data File Auto...

If your script is not generating the file name dynamically then you will get the below mentioned error:

Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070050(The file exists.).

Msg 19062, Level...

Execute command dbcc useroptions under that database.

MJ

Those might be statistics. Please post their names.

MJ