Hi All,

Finally, the problem managed to solved by using

EXEC sp_configure 'locks', '500000'

RECONFIGURE WITH OVERRIDE

Thanks for all the helping hand 🙂

Thanks. I will let you know the status later

Hi Racosta,

May I know how and where to increase or descrease the MaxDeliveredTransactions?

Thanks in advance.

Yes.

Hi Andy,

Thank for your reply. After I increasing the timeout for log reader. I encouter another problem on the publisher.

The process is running and is waiting for a response...

Antares686, I ran DBCC CHECKTABLE (sysjobhistory, REPAIR_ALLOW_DATA_LOSS ) command, and the error was repaired and fix, Thank for your infor.

FVC, The bug occur when the Integrity option in attempt to...

Hi Andy, Thank for you reply.

The maintetance plan history display an error as below..

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error:

Object ID 2073058421, index ID 2.

The low key value...

I have recreated the job, the problem still happen..

I am using dell The PowerEdge 6450

Intel® Pentium® III XeonTM processors at 700MHz and 900MHz for scalable performance 700MHz available with 1MB or 2MB level 2 cache

Front...

Harddisk and swap disk space is available. Tempdb is auto growth and the size still remain 1 mb as default during SQL installation. FYI, The server is running for more...

Dual processor and running on the cluster environment with 1 GB Ram.

The DB showed suspend in the EM. The DB cannot be access. So, I have to detach DB and Attach it back.

From the server log.

Event Type: Error

Event Source: MSSQLSERVER

Event...

Hi, I have too many table's in the NDF file. Is there a faster way to move all the table from NDF to MDF file group?

Thank for you reply.

Thanks !