login error problem

[RaeK]

Under this article it warns that you may get an error if you attached your database:

http://msdn2.microsoft.com/en-us/library/ms189279.aspx
<start quote>
Important:
The installation of these support objects can fail on a database that has been attached or restored from another instance of SQL Server. This may occur when the database owner name (stored in the database) is not a valid login in the instance of SQL Server the database is being attached or restored to.
Use the following Transact-SQL expression to change the database owner to a valid login in the instance of SQL Server. Then retry the database diagram operation.

ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login

<end of quote>

Which program do I open to change this authorization on database.
Can someone clue me in how to do this? Or perhaps point me to another forum where they will help me with problems on this?

Thanks
Rae

[srinivas_s]

Open the sql query analyser and do it, connect to this database and run the t sql statement

[RaeK]

Thank you.
Is the "sql query analyzer" included as part of the SQL 2005 express?

[srinivas_s]

Sorry i didnt realise you are using SQL 2005 , You will have to run the queries on Visual Studio itself dont have it installed on my system , you see the help in VS.Net 2005