Read only database to read-write

I have MSSQL 2000 database wich I made read only for some reason. Now I want
to make it writeable again.
I right click on the database in EM, go to options, remove the checkmark
near the 'read only', and when I click OK i get an error message wich says
that I can't take the database offline because database is in use.
How can a ReadOnly database be in use in such manner that I can't change
that? And, whas is ment by 'taking the database offline'?
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hrI suggest you use the ALTER DATABASE command to change database options. One
of the possibilities it has is to throw out current users, for instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
news:slrnc5vrd4.j1r.majk@.fly.srk.fer.hr...
> I have MSSQL 2000 database wich I made read only for some reason. Now I
want
> to make it writeable again.
> I right click on the database in EM, go to options, remove the checkmark
> near the 'read only', and when I click OK i get an error message wich says
> that I can't take the database offline because database is in use.
> How can a ReadOnly database be in use in such manner that I can't change
> that? And, whas is ment by 'taking the database offline'?
> Mike
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
> Mario Splivalo
> msplival@.jagor.srce.hr|||Hi,
Yes, I agree with tiber on this, Issue the below command from Query analyzer
to make database READ_WRITE.
Alter database pubs1 set read_write with rollback immediate
(Replace pubs1 with actual database name.)
Note:
Rollback immediate option is equalent to Kill statement, it just closes all
the connected sessions. Otherwise even a read only session connected to the
database will create a block and will not allow you to change the database
options even if the database is read only.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uANAkFLEEHA.3716@.TK2MSFTNGP10.phx.gbl...
> I suggest you use the ALTER DATABASE command to change database options.
One
> of the possibilities it has is to throw out current users, for instance.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
> news:slrnc5vrd4.j1r.majk@.fly.srk.fer.hr...
> want
says
>

RDL file not maintaining Extended File Properties

Please try this if you want...
1 For a .RDL file, right click on the file its self and select
"properties"
2 Click the "Summary" tab and enter information in any of the text
fields (Subject, author, ...)
3 Save it and then copy the file on another computer, is your metadata
missing just like mine?
It seems to be saving it somehow locally, but does not transfer with
the file. What gives?
We were originally trying to add some of the install info in here, but
seems to only be local.
Weird thing is... if you look at the same file over the network from
another computer, the information looks to be there, it looses it when
copied.oh well. I just found out why. This data is actually stored in NTFS
and is not in the file. Any time the file is copied into source safe
or email all properties are lost.

RB - Multiple Data Source for Report Builder

I add two data sources to the designer. Create a new dsv using one data source first. Then right click in the designer to add a new table. This time I use the second data source. When I create a Report Model and run it, an error occurred: "Message: Invalid object name 'dbo.tblTrade'. Command: SELECT COUNT(*) FROM [dbo].[tblTrade] t"

It does not recognize the second data source. Look at the property of the dsv, it only points to the first data source, not the other one...

If you look at the XML code for the dsv, there is a DataSourceID tag right above the Schema tag. Can this tag be expanded to include the 2nd data source? Can the XML code be tweaked to include the second data source?

</Annotations>

<DataSourceID>Db House01</DataSourceID>

<Schema>

|||"Our newly created Data Source is positioned as the default, and will serve us in meeting the objectives of our practice exercise. A Data Source View for a Report Model Project, unlike a Data Source View for an Analysis Services Project, can only reference a single Data Source. "

Is this true?

http://www.databasejournal.com/features/mssql/article.php/10894_3598931_4

|||

Yes, that is correct.

|||By creating a named query can overcome the single data source limitation.|||

This solution does not work. If one try to create model bases on such Data source View, table entity for the named query defined in DSV, which is not bases on prime data source, is not being created.

Can you please give some steps to over come this problem?

|||

MSDN Online Book link below:

http://msdn2.microsoft.com/en-us/library/ms175683.aspx