yes. Please install SP2.

use dbcc shrinkfile with notruncate and then truncateonly. It will do what you are expecting if there is no open transaction.

Redgate tool will be helpful.

use

DBCC shrinkfile (filename, expected size in MB , notruncate)

once this is completed then

DBCC shrinkfile(filename, expected size in MB , truncateonly)

This will do trick.

Which version of SQL Server? If it is 2005 then do you have SP2 installed?

Please check this http://msdn2.microsoft.com/en-us/library/ms187864.aspx

Although there is hotfix available for this issue that brings 9.00.3186.00. But My experience says it does not resolve issue completely. Hence, to resolve this issue you have to clear...

Please check this http://www.sqlservercentral.com/Forums/Topic13928-8-1.aspx

If you are storing your file on same machine then there is definetely a process running that locks that file (as stated in earlier post) which leads file not being...

Follow http://msdn2.microsoft.com/en-us/library/ms190775.aspx

You can use import wizard to do this that is available under TASKS property of Database.

I have it running on 64 bit box and it is doing job without any problem.

Alter is good if you want to ensure existing security setting on SP otherwise it does not matter.

Do you have any file backup process running for drive where you store your trace file? something like TSM. Such error is expected in that case.

Query that performs slow:

select * from Table1

where column4 IS NULL

Sample Data in Table:

1124100065.16

1156101101.11

11781015NULL

118991015NULL

11989102834NULL