Browse by Tags

SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Published 13 February 8 5:2 AM | SSQA.net

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...

Filed under: sql server, tools, upgrade, replication, error, error log, timeout, servers

How to find subscriber is not getting upto date data?

Published 14 December 7 7:18 PM | SSQA.net

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more...

Filed under: sql server, data, replication, error, subscriptions

Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"

Published 21 November 7 4:25 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when you try to replicate...

Filed under: sql server, replication, error, kba, hresult, mobile edition