Setting Database Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PGene2 - 22 Sep 2006 05:57 GMT

I run several DTS Packages that load databases residing on two seperate
instances of SQL Server 2000 on the same server. For security reasons, I
need to be able to set the Databases on one instance to Read/Write access,
set the database access on the other instance to Read only, run the packages
on the first instance, and then reset the access to Read Only. The ideal
solution would be writing the logic in T-SQL in a stored procedure that is
already part of the Package or add a new stored procedure to the package. I
have not been able to find any reference to setting the Database access in
code. I would appreciate and welcome any advise on how to accomplish this
programming task. Thank you.

Signature

grp

Reply to this Message

Arnie Rowland - 22 Sep 2006 07:59 GMT

ALTER DATABASE MyDatabase
SET READ_ONLY

ALTER DATABASE MyDatabase
SET READ_WRITE

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

>I run several DTS Packages that load databases residing on two seperate
> instances of SQL Server 2000 on the same server. For security reasons, I
[quoted text clipped - 8 lines]
> code. I would appreciate and welcome any advise on how to accomplish this
> programming task. Thank you.

Reply to this Message

PGene2 - 25 Sep 2006 17:46 GMT

Thanks for the help. This is what needed.

Signature

grp

> ALTER DATABASE MyDatabase
> SET READ_ONLY
[quoted text clipped - 14 lines]
> > code. I would appreciate and welcome any advise on how to accomplish this
> > programming task. Thank you.

Reply to this Message