I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
Showing posts with label read-only. Show all posts
Showing posts with label read-only. Show all posts
Wednesday, March 7, 2012
database (read-only)
I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?
ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
there a script that can change my database from being read-only?
ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
database (read-only)
I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?ALTER DATABASE pubs SET READ_WRITE
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?|||ALTER DATABASE dbname SET READ_WRITE
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
there a script that can change my database from being read-only?ALTER DATABASE pubs SET READ_WRITE
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?|||ALTER DATABASE dbname SET READ_WRITE
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
Saturday, February 25, 2012
Data Versioning Transactional Replication
Hi,
I've got a requirement to know when some data has been propagated to
all my (read-only) subscribers. This is because the data will be
cleaned, and the subscribers shouldn't "use" the new version for
certain queries until I know that the new data is there.
I've created a model where I have a "version" table with an identity,
that gets updated by the log reader every time it reads. I check the
version at the time the data changes are finished. Then, when i save
the version with the query that i want to run at the subscriber, and
wait until the version number is greater than or equal to my version
number.
This model seems to work, it requires me to add some steps to the
distribution job, but I'm wondering if there is a better way? Ie,
some form of replication that doesn't require me to custom code the
versioning scheme of the data.
Thx,
Doug
If the data is updated on the publisher in discrete batches you can always
wait for the distribution agent to complete. Other than that the scheme you
have implemented sounds like the best way to go. SQL 2005 will have tracer
tokens that might help with your requirement.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Douglas Tarr" <douglas.tarr@.gmail.com> wrote in message
news:c33eac8b.0409070825.1654dcb3@.posting.google.c om...
> Hi,
> I've got a requirement to know when some data has been propagated to
> all my (read-only) subscribers. This is because the data will be
> cleaned, and the subscribers shouldn't "use" the new version for
> certain queries until I know that the new data is there.
> I've created a model where I have a "version" table with an identity,
> that gets updated by the log reader every time it reads. I check the
> version at the time the data changes are finished. Then, when i save
> the version with the query that i want to run at the subscriber, and
> wait until the version number is greater than or equal to my version
> number.
> This model seems to work, it requires me to add some steps to the
> distribution job, but I'm wondering if there is a better way? Ie,
> some form of replication that doesn't require me to custom code the
> versioning scheme of the data.
> Thx,
> Doug
I've got a requirement to know when some data has been propagated to
all my (read-only) subscribers. This is because the data will be
cleaned, and the subscribers shouldn't "use" the new version for
certain queries until I know that the new data is there.
I've created a model where I have a "version" table with an identity,
that gets updated by the log reader every time it reads. I check the
version at the time the data changes are finished. Then, when i save
the version with the query that i want to run at the subscriber, and
wait until the version number is greater than or equal to my version
number.
This model seems to work, it requires me to add some steps to the
distribution job, but I'm wondering if there is a better way? Ie,
some form of replication that doesn't require me to custom code the
versioning scheme of the data.
Thx,
Doug
If the data is updated on the publisher in discrete batches you can always
wait for the distribution agent to complete. Other than that the scheme you
have implemented sounds like the best way to go. SQL 2005 will have tracer
tokens that might help with your requirement.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Douglas Tarr" <douglas.tarr@.gmail.com> wrote in message
news:c33eac8b.0409070825.1654dcb3@.posting.google.c om...
> Hi,
> I've got a requirement to know when some data has been propagated to
> all my (read-only) subscribers. This is because the data will be
> cleaned, and the subscribers shouldn't "use" the new version for
> certain queries until I know that the new data is there.
> I've created a model where I have a "version" table with an identity,
> that gets updated by the log reader every time it reads. I check the
> version at the time the data changes are finished. Then, when i save
> the version with the query that i want to run at the subscriber, and
> wait until the version number is greater than or equal to my version
> number.
> This model seems to work, it requires me to add some steps to the
> distribution job, but I'm wondering if there is a better way? Ie,
> some form of replication that doesn't require me to custom code the
> versioning scheme of the data.
> Thx,
> Doug
Subscribe to:
Posts (Atom)