Browse by Tags

• dump
• error
• exception
• file
• Hardware
• high availability
• kba
• Maintenance
• monitor
• not found
• performance
• plan
• process
• Project Server 2007
• replication
• security
• services
• SQL Server
• ssas
• ssis
• SSMS
• surface
• transactional
• troubleshoot
• tuning

• How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

  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 How to enable the SQL Server 2005 Integration Read More... Posted Friday, August 31, 2007 5:56 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Integration, services, process, ssis, kba, exception, file, dump

• On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More... Posted Friday, August 24, 2007 6:15 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Maintenance, Integration, SSMS, services, ssis, kba, plan

• Simple steps to monitor Replication activities

  There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance Read More... Posted Friday, August 24, 2007 1:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, replication, transactional, troubleshoot, monitor

• [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

  --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' Read More... Posted Wednesday, August 22, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, SSMS, error, high availability, surface, not found

• Dust out few tasks to gain transactional replication performance in SQL 2005

  Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at Read More... Posted Thursday, August 16, 2007 7:20 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, Integration, SSMS, ssas, replication, transactional, tuning

• Integrating EPM 2007 with Line of Business Solutions such as ERP Systems

  As Project Server is gaining visibility as an enterprise application and a key application within companies, it needs to integrate with existing system starting typically with Enterprise Resource Planning (ERP) systems such as SAP, Oracle, PeopleSoft. Read More... Posted Saturday, April 21, 2007 6:10 AM from MSDN Blogs | (Comments Off) Filed under: Integration, Project Server 2007