How to change read_only to read_write in vb.net sql database connection?

328 views Asked by At

How to change read_only to read_write in vb.net SQL Server database connection? Error message:

Failed to update databse because the database is read_only

2

There are 2 answers

0
abatishchev On
exec sp_addrolemember db_datawriter, MYUSER
0
DaveRead On

This change will need to be made at the database server - see the article below for details:

http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/7925902b-9d6f-445a-8432-e58e7580d65d/