Change Database permission to Read/Write using Visual Studio 2010
If possible, please give me the step by step procedure.
Thanks!
You should have the corresponding rights and launch following query :
ALTER DATABASE mydatabase READ_WRITE
Good luck !
but if you wonder those kind of thing, I guess you don't have the rights to do it.
I right click on the database name under, Data Connections, and then say 'New Query', and it then shows me a list of tables. Here's where I'm not sure what to do.
Even if I select some random tables, and enter the query, I don't see any 'Execute' button or option.
When I try to execute "ALTER DATABASE ASPNETDB.MDF READ_WRITE", it says "Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'."
"ALTER DATABASE ASPNETDB READ_WRITE" does not woek as well.
I get the following error for the second statement:
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'READ_WRITE'."
The database has been created by me and I am the administrator on my laptop. So what could the problem be?
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'ASPNETDB', or the database does not exist.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Apologies again, for asking too much!
use login = "sa" and password = "yourpassword"
to go ahead, I advise you log on the server itself and user SQL Server Management Studio, you'll get a better view of the server.
I do not have SQL Server Management Studio installed. Does it come bundled with Visual Studio 2010?
http://msdn.microsoft.com/en-us/library/aa833241.aspx
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Join our community and discover your potential
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.