Archive for the 'sqlserver' Category
Documenting SQL Server 2008 RC0 databases
July 15th, 2008One of my customers asked me yesterday if dbdesc 3.0 supports SQL Server 2008 databases.
The answer is yes, dbdesc works just fine with SQL Server 2008 RC0 and even documents the new data types.
There is however a small issue… it won’t script tables. The current version of SMO does not support SQL Server […]
Diagnose SQL Server 2005 SP2 install problems
March 28th, 2008I was checking the pending updates in one of my test VISTA machines and the SQL Server 2005 Service Pack 2 was still in the list. I tried to install it using Windows Update but it returned an error: Error code 2B22.
The link Get Help didn’t bring any help as the error code was not […]
Problem dropping a user in SQL 2005
May 15th, 2007Today I’ve encountered a problem trying to drop a user from a database. I kept getting this error:
Msg. 15138 The database principal owns a database role and cannot be dropped
So it looked like the user owned a database schema. To find out the schemas that a user owns I’ve used this query:
SELECT * […]
