login error problem
Under this article it warns that you may get an error if you attached your database:
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?
Open the sql query analyser and do it, connect to this database and run the t sql statement
Is the "sql query analyzer" included as part of the SQL 2005 express?
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
By Maria Modeste in forum Java
Last Post: 10-26-2005, 05:37 PM
By mycwcgr in forum ASP.NET
Last Post: 09-02-2005, 09:22 PM
Last Post: 08-31-2005, 11:47 PM
Last Post: 10-03-2001, 10:42 AM
By podong28 in forum ASP.NET
Last Post: 08-13-2000, 07:14 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL