Category Archives: SQL

By May 09, 2009

You can view the current connections by executing the system proc sp_who2 , if you wish to kill the connection type: kill and the pid number or use ALTER DATABASE ‘DATABASE_NAME’ SET SINGLE_USER WITH ROLLBACK_IMMEDIATE.

Read More
By March 21, 2009

OMG : Error : The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a

Read More
By January 16, 2009

Microsoft SQL Server, Error: 916 Error: the server principal “” is not able to access the database “” under the current security context For those of you that connect to databases that are hosted by 3rd party providers, some of which are accustomed to leaving as many databases in auto-close mode as possible, you are

Read More
By November 25, 2008

sp_changeobjectowner (T-SQL) Changes the owner of an object in the current database. Syntax sp_changeobjectowner

Read More
By November 22, 2008

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager. Invalid Namespace. ================= solution ============== mofcomp “C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof

Read More
1 2 3 4 5 6