Browse by Tags

• error
• Hardware
• high availability
• kba
• Maintenance
• not found
• performance
• plan
• replication
• security
• services
• ssas
• ssis
• surface
• transactional
• tuning

• 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

• [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