Doeseating Licorice Harm Yourbody

AttachDBFilename and SQL Server 2008

Se vi dovesse capitare la sventura di voler collegare un database SqlServer express prodotto dal vostro fido Visual studio 2010, nel deploy di un applicazione web.net su un server che ha installato SqlServer2005, passerete una lunga serie di 5 minuti a chiedervi per quale motivo non vada.

Questa stringa di connessione vi verrà in aiuto:

"Data Source=server\istanza;AttachDbFilename='
worry, I'm not lost, it's just a permissions problem.

The error message is: Database diagram support objects

can not 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.

Or in Italian


not install the diagram support objects

database because the database is not a valid owner to continue
first use the Files page of the Properties dialog box
the database or education Alther autorization
to set the owner of the database to a valid login and add objects
support for database diagrams.

Here is the solution from MSDN
http://msdn.microsoft.com/en-us/library/ms186345 (SQL.90). Aspx

ALTER AUTHORIZATION ON DATABASE:: database_name TO "YOU"
go USE [database_name]
go EXECUTE AS USER = N'dbo 'REVERT go

This will allow you to regain access to your diagrams or create new ones.