Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
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.
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.
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.
Sometimes, you may need to change the owner of an object.
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'
ALTER DATABASE MyDatabase COLLATE <desired collation>
