SQL

SQL: Can not create worker thread

Posted by on July 24, 2011 at 2:17 am

Error: Can not create worker thread Check the Server load and restart the SQL engine

SQL: Cannot drop the user dbo

Posted by on April 17, 2011 at 5:08 am

Error: Cannot drop the user ‘dbo’. (Microsoft SQL Server, Error: 15150) Problem: trying to unmapped a user to a database , you may receive the above error message. This is because the dbo user is assigned the login of the user you are trying to remove. You will need to run the following query to [...]

SQL 2008: clearing current connections

Posted by on March 27, 2011 at 5:46 am

You can clear the current SQL connections by issuing the following query USE master; GO ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE dbName SET MULTI_USER; GO

asp.net: Cannot find table 0

Posted by on December 21, 2010 at 5:44 pm

Error: Exception Details: System.IndexOutOfRangeException: Cannot find table 0. Possible Solution: I am sure there are a few solutions for this error, but the one we encountered was related to the web.config file being incorrect. The database information was invalid. Hopefully this will help someone who encounters the same isue

SQL upgrade from MSDE: UpgradeAdvisor returned -1 .

Posted by on May 12, 2010 at 1:47 am

Cause: The error occurs because of a problem with BPACMD.EXE attempting to load BPAClient.dll. While upgrading the instance of SQL Server the setup looks for the BPAClient.dll and it fails as it is not able to find it at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA. Solution : Copy the BPAClient.dll file from the following location C:\Program [...]

Next Page »