Browse by Tags

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, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL...

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

SQLServer2005 Profiler (profiler90.exe) fails to launch with Application Error (0x0000005)

Published 19 June 7 3:16 PM | SSQA.net

Further details and resolution for this problem can be found from this FAQ entry....( read more ) Read More...

Filed under: application, sql server, profiler, error log