Ahmad,

Try this:

CREATE TABLE #db_file_information(

fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300) )

-- Get the size of the datafiles

insert into #db_file_information

( fileid

,...

You just need to make sure that database has 1.5 times the largest table size free space available in it. Reindex operation needs that as it will recreate the table...

Are you specifying TCP/IP port with server name or IP? Is browser service running?

MJ

Those trace flags are undocumented and a google search reveal that they are used for capturing "sql dump info". Basically help you in troubleshooting memory related issues etc.

MJ

It seems it is popping up this message due to weak 'sa' password. Please change it to a stronger one(complying with windows based policies) even though you are not gonna...

Is the third sql 2005 instance configured with TCP/IP protocol enabled? Please check the protocols enabled for third instance under SQL Server configuration Manager.

MJ

Do you have any index on Created field in audit table? If not then try creating a non-clustered index on it to make the rows retrieval faster. Would be better...

You said that database edition has been upgraded then where and when exactly are you getting this message.

Is there any specific login for which its popping up this message?

MJ

You said that file was in use. Its better if you check whether any antivirus scan is running in background that is keeping it locked which is preventing you from...

There is one specified at http://www.databasejournal.com/features/mssql/article.php/3672926

MJ

Please specify a windows policy compliant 'sa' password, I think its popping up this message just because of password not meeting policy requirements.

MJ

Just check for the database connections using sysprocesses view and kill them.

MJ

Are you trying to connect using IP or Servername while you are on server Query analyzer?

Have you gone thru this link:http://support.microsoft.com/kb/306865

MJ

Try the stpes mentioned in the below mentioned link:-

http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html

Also, do googling for DBCC REBUILD_LOG command. This command can be handy to rebuild the SQL log file.

Do let me...

Try this:-

select * from information_schema.table_constraints

where constraint_type='PRIMARY KEY'

HTH

Manu