Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!
From: Erland Sommarskog on 2 Aug 2010 15:16
Pedro Juan (PedroJuan(a)discussions.microsoft.com) writes:
> but when you try to launch the ALTER AUTHORIZATION ON DATABASE:: dbo TO
> database tells me that I have no permissions.

Exactly what command did you run?

The syntax I gave was incorrect. (I took it from memory.) The correct syntax
is

ALTER AUTHORIZATION ON DATABASE::yourdb TO newowner

And while it is unfortunate that I gave you the wrong syntax, nothing
prevents you from looking up the syntax in Books Online yourself.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

First  |  Prev  | 
Pages: 1 2 3
Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!