hi
I'm having a problem while attaching the database to the server through server management studio. The database is getting attached as read only database.
But when i'm attaching it through command prompt or using a batch file it is getting attached properly
Can any one suggest the rason and a reamedy for avoiding this problem
Where does this database come from?|||The database is from another system/ computer. It is behaving the same on that computer also|||Databases can be marked as read-only. You should check the other system to see if the database was marked that way. Check the database proprties, Options page under State (in 2005, not sure where this is in 2000). The read-only flag travels with the database, you'll need to un-set it at the source before moving the database.
Mike
sql
No comments:
Post a Comment