Cheap and reliable SQL Server hosting & MS SQL 2005 Hosting - SQL Server Mart

sales: sales$sqlservermart.com support: support$sqlservermart.com billing: billing$sqlservermart.com

SQL Server Administrator Resources, MSSQL 2005/2000

SQL Server 2005/2000 Troubleshooting

An existing connection was forcibly closed by the remote host. SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

• An existing connection was forcibly closed by the remote host. SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

Solution for "SQL Server does not exist or access denied" error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

• Description of TCP/IP settings that you may have to adjust when SQL Server connection pooling is disabled
• MaxUserPort
• TcpTimedWaitDelay
• INF: SQL Logs 17832 with Multiple TCP\IP Connection Requests
• Potential causes of the "SQL Server does not exist or access denied" error message

KB922658: SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer

If you run Microsoft SQL Server 2000 or Microsoft SQL Server 2005 on a Microsoft Windows Server 2003 Service Pack 1 (SP1)-based computer, SQL Server may temporarily stop responding (hang) in certain cases. Depending on the severity of the problem, this behavior may take from several milliseconds to several minutes.

• KB922658: SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer
• KB919341: A program that uses structured exception handling may stop responding for several seconds in Microsoft Windows Server 2003 with SP1

KB923628: FIX: The backup application stops responding when you perform a backup that uses a volume snapshot in Windows Server 2003 with SP1

When you perform a backup in Microsoft Windows Server 2003 with Service Pack 1 (SP1), the backup application stops responding. This behavior occurs if the backup uses a volume snapshot.
This problem occurs because of an issue in the Volsnap.sys file. This issue generates a deadlock condition. In the deadlock condition, the system I/O is suspended. A file deletion operation is waiting for the system I/O to resume.

• KB923628: FIX: The backup application stops responding when you perform a backup that uses a volume snapshot in Windows Server 2003 with SP1

KB891957: Update is available that fixes various Volume Shadow Copy Service issues in Windows Server 2003

On a Windows Server 2003-based computer that has many shadow copies that are being used, the paged pool memory on the computer may become exhausted. This problem may occur when the shadow copy snapshots are of large volumes and when each volume contains many files. After you install the update, Microsoft Windows dismounts unused shadow copies when paged pool memory is low.

• KB891957: Update is available that fixes various Volume Shadow Copy Service issues in Windows Server 2003

Microsoft SQL Server (MSSQL) Management Resources

SQL Server Performance Tuning

• Tips on Performance Tuning Windows 2003 When Running SQL Server

Change SQL Server 2000 Object Owner

Sometimes, you may need to change the owner of an object.

• Changes the owner of an object one by one in the current database using stored procedure sp_changeobjectowner.
• Change all MSSQL objects from one owner to another owner.
• Change the Owner of a User-Defined Data Type

Change SQL Server 2005 Object Schema

• Change schema name on Tables and Stored procedures in SQL Server 2005

  		SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name 
  		FROM sys.Procedures p 
  		INNER JOIN sys.Schemas s on p.schema_id = s.schema_id 
  		WHERE s.Name = 'CHANGE_ME_Username'
  				

Change database collation name

ALTER DATABASE MyDatabase COLLATE <desired collation>

• How can I change the collation name of a specific database?
• SQL Server and Collation

How To Delete Duplicate SQL Server Records?

• Microsoft Knowledge Base Article KB139444: How to remove duplicate rows from a table in SQL Server
• sqlteam.com: Deleting Duplicate Records

How to stop SQL Server Enterprise Manager user seeing all databases?

• Microsoft Knowledge Base Article KB889696: You may experience a slow response from SQL Server Enterprise Manager when many databases exist in an instance of SQL Server

SQL Server Data Transformation Services (Import/Export Wizard)

• Using DTS to Copy Database: Step-by-step guide to using DTS (Data Transformation Services) to create a local copy of a production SQL Server database.
• DTS Tutorial: How to transfer the database to the destination server using the DTS Import/Export Wizard.

SQL Server 2005 Encryption

• SQL Server 2005 Security - Part 3 Encryption