BTW, are you on a clustered environment?

I was also encountered with the same error. However, in my case, DBCC CHECKDB reported allocation errors. However, this might have been the result of broken linkage chain between objects.

Hi Nelson,

The default behavior of the SQL Server is to parse the query locally. If you want the dynamic queries to be made and there parsing at the remote server,...

manually update the statistics first.

Hi,

Regarding your queries:

1) The "Auto Create Statistics" and "Auto Update Statastics" for the databases is a common setting that you will find most of the cases as ON. You are...

I can not give you the technical support but XML format makes the data compatible in hetrogeneous environemt. This makes the secured flow of data over the web, much faster...

Its in registry. You can verify this information from regedit:

HKEY_LOCAL_COMPUTER\software\Microsoft\Microsoft SQL Server\<your instance>

Your database will remain in single-user modfe only.

to return to multi-user mode:

ALTER <database-name> SET MULTI_USER

Did you check blocking? Run sp_who to check it.

Thanks for providing all the information.

Please carry out a few checks:

1) Check whether there is any open transaction on the database or not. To check this, use the following commands:

use...

Also, please run the command:

DBCC SQLPERF(LOGSPACE)

and let me know the %used value for the database in question.

Can you tell me the recovery model set for the database, the initial size of the log file and its growth settings?

Simply backup the transaction log to truncate it.

In the autogrow option, what is the growth value that you have selected for the database?

Have you installed the latest secutrity patch?