Monday, November 8, 2010

How to trust Database sql server 2005

How to trust Database sql server 2005,Express
Okay,I must to used the SQL script when you have to restore the database from the database backup from aother Machine so You must to run the script for change some thing to your machine .

1. Log in to the SQL Server .
2. Open the new Query and then copy below .

alter database [your database name]
set trustworthy ON;


Plase waiting for the Compleated message .

Thanks.

No comments:

Post a Comment

How to fixe database in restoring mode

  RESTORE DATABASE YourDatabaseName WITH RECOVERY;