Tech-Today
I encountered the error below when creating a diagram in the Management Studio.
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Solution:
Execute the following line in SQL Server Management Studio Express Query
ALTER AUTHORIZATION ON DATABASE::DATABASE_NAME TO "Your_User"
- Could Not Find Stored Procedure 'dbo.aspnet_checkschemaversion'.
The error above is normally caused by a database that is not aspnet enabled. For example, currently I have a code-first database that is previously aspnet enabled then I execute update-database -targetmigration:"0", so it removes all the tables and values....
- Missing Microsoft Server Management Studio Express After Sql Server 2008 Express Installation
For some reason after I've installed the SQL Server 2008 and SP1 I'm still missing the Management Studio Express that we commonly have when we install the 2005 SQL Server Express. The solution is to download from this link: http://www.microsoft.com/express/Database/...
- Mssql Generate Script To Create A Database Schema Only
I want to duplicate my database schema, but I do not want to copy the data contents. There are 3rd party tools which I can use to achieve the same result. But I prefer to use the Microsoft SQL Server Management Studio. To do so: 1.) Open Microsoft SQL...
- Setting Mssql Server 2005 Table 2000 Compatible
Recently I was developing a c# application that uses sqlserver2005 database (express edition) setup on my laptop which has win7 os. The problem is the public server where I will deploy the application is only running a mssql server 2000 database. My application...
- Installing Sql Server Compact Edition 3.1 On Mobile Device (pocket Pc)
1.) Download the sqlce3.x installer, http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en or http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en...
Tech-Today
Database diagram support objects cannot be installed because this database does not have a valid owner
I encountered the error below when creating a diagram in the Management Studio.
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Solution:
Execute the following line in SQL Server Management Studio Express Query
ALTER AUTHORIZATION ON DATABASE::DATABASE_NAME TO "Your_User"
- Could Not Find Stored Procedure 'dbo.aspnet_checkschemaversion'.
The error above is normally caused by a database that is not aspnet enabled. For example, currently I have a code-first database that is previously aspnet enabled then I execute update-database -targetmigration:"0", so it removes all the tables and values....
- Missing Microsoft Server Management Studio Express After Sql Server 2008 Express Installation
For some reason after I've installed the SQL Server 2008 and SP1 I'm still missing the Management Studio Express that we commonly have when we install the 2005 SQL Server Express. The solution is to download from this link: http://www.microsoft.com/express/Database/...
- Mssql Generate Script To Create A Database Schema Only
I want to duplicate my database schema, but I do not want to copy the data contents. There are 3rd party tools which I can use to achieve the same result. But I prefer to use the Microsoft SQL Server Management Studio. To do so: 1.) Open Microsoft SQL...
- Setting Mssql Server 2005 Table 2000 Compatible
Recently I was developing a c# application that uses sqlserver2005 database (express edition) setup on my laptop which has win7 os. The problem is the public server where I will deploy the application is only running a mssql server 2000 database. My application...
- Installing Sql Server Compact Edition 3.1 On Mobile Device (pocket Pc)
1.) Download the sqlce3.x installer, http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en or http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en...