Hi,

You can put the database under restricted access.

SP_dboption OR use Enterprise Manager.

John

-----Original Message-----
From: Tanmaya.[Email Address Removed]
Sent: Thursday, April 29, 2004 10:04 PM
To: LazyDBA.com Discussion
Subject: Several databases


Dear all,
I have several database running on the SQL Server with different
types
of users working on different databases.
For some maintenance purposes, I want to stop access to the users to one
of
the database.

Can it be possible to stop the access to one particular database while
continuing the other databases.





Tanmaya Kumar Pattajoshi
Sr. Executive-IT
Vishay Components India Pvt. Ltd.
Loni,Pune
Ph: 91-20-26913285-5562/5624

"Champions aren't made in the gyms. Champions are made from
something they have deep inside them - a desire, a dream, a
vision."
"The best proof of love is trust."



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page