Yes with DTSHave you tried to issue
ALTER DATABASE dbname
SET RESTRICTED_USER
and then run the DTS Package
When the user reads the data it does not block writes ,sql server obtains a
share lock ,so anyway try running the above commad and see what si going on
"Tanmaya Kulkarni" <tanmaya_kulkarni@.persistent.co.in> wrote in message
news:%23oazDUttGHA.1288@.TK2MSFTNGP02.phx.gbl...
> Yes with DTS
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment