read-only error

Asked By sakshi gupta
29-Jan-10 02:32 PM
Earn up to 0 extra points for answering this tough question.

hello,

I have made software for client,in setup i added sql server express as pre requisite. after installation wen m trying to access the data ,its showing me datbase is in read only mode...

can anyone help me in solving this problem. how can i give write permission also so dat i can access my data and software strat running properly.

thanks in advance

  re: read-only error

Pranay Singh replied to sakshi gupta
29-Jan-10 02:46 PM

I am not sure about this but you can give it a try.

in the microsoft sql server studio interface,  right click on database name  select properties  and in properties window click on permissions.  You can set permissions there like alter any database or create database for particular users

I hope this works but again not sure if  this is what you are looking for...try it.

Thanks

  re: read-only error

Jonathan VH replied to sakshi gupta
29-Jan-10 02:49 PM
ALTER DATABASE YourDatabaseName
SET READ_ONLY;

  re: re: read-only error

Jonathan VH replied to Jonathan VH
29-Jan-10 02:50 PM

Oops, make that:

ALTER DATABASE YourDatabaseName
SET READ_WRITE;

Create New Account