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 execute "ALTER DATABASE ASPNETDB SET READ_WRITE", I get the following error:
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 1User does not have permission to alter database 'ASPNETDB', or the database does not exist.Msg 5069, Level 16, State 1, Line 1ALTER DATABASE statement failed.
You should have the corresponding rights and launch following query :
ALTER DATABASE mydatabase READ_WRITE
Good luck !