Browse by Tags

All Tags » error log » 2005 (RSS)
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues
Published 9 April 8 2:22 AM | SSQA.net
Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime...
Filed under: , , , , , , , , , ,
SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?
Published 16 January 8 1:40 AM | SSQA.net
Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual...
Filed under: , , , , , , , , , ,
Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"
Published 12 November 7 3:23 AM | SSQA.net
Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...
Filed under: , , , , , , , , ,
FIX: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log
Published 12 October 7 11:10 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , ,