Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 AdventureWorks2012 readonly

Author  Topic 

jks7reid
Starting Member

3 Posts

Posted - 2012-11-30 : 12:06:53
I'm brand new to sql server. I downloaded the adventureworks db, and it is recognized in management studio, but it gives the name of the database as it looks in the subject of this question. The owner is stated as my user, LHC\John, but i am unable to do very much with the database under its current readonly status. How might i make it readwrite, so that i can move forward in my education?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-11-30 : 12:57:11
Right click on the database - options - near the bottom there is a status readonly which you can change.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

jks7reid
Starting Member

3 Posts

Posted - 2012-11-30 : 14:24:25
quote:
Originally posted by nigelrivett

Right click on the database - options - near the bottom there is a status readonly which you can change.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Go to Top of Page

jks7reid
Starting Member

3 Posts

Posted - 2012-11-30 : 14:25:49
quote:
Originally posted by nigelrivett

Right click on the database - options - near the bottom there is a status readonly which you can change.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.



Sorry for the null xmit. THat seems to have worked. Right clicked to properties, then options, then scrolled down a ways. Thanks a bunch.
Go to Top of Page
   

- Advertisement -