sql server new users: Database comes up as read only -- sql server new users

You're in the

sql server new users

group:

Database comes up as read only

MikeBach
1/14/2006 4:51:27 PM

sql server new users: I downloaded the Northwind sample database from Microsoft. I attached the DB
through Enterprise manager. It comes up as Read Only, how can I change this
so I can manipulate. Second question, are there any practice lessons
regarding the sample database I can download to practice with ?

Using SQL 2000 Sp3a on MS Standard Server 2003

Thanks

Re: Database comes up as read only

Tom Moreau
1/14/2006 7:45:33 PM

In Query Analyzer, try:

alter database Northwind
set read_write

There are many books that use Northwind as the sample database.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

[quoted text, click to view]
I downloaded the Northwind sample database from Microsoft. I attached the DB
through Enterprise manager. It comes up as Read Only, how can I change this
so I can manipulate. Second question, are there any practice lessons
regarding the sample database I can download to practice with ?

Using SQL 2000 Sp3a on MS Standard Server 2003

Thanks

Re: Database comes up as read only

MikeBach
1/15/2006 7:33:46 PM

Thank you

[quoted text, click to view]

Re: Database comes up as read only

Lacrimosa
1/17/2006 10:51:39 PM

this helped me too
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn