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
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