database Locking
There is a DTS package which contains only one process as
select * into temp_tbl1 from
(select * from openqyery(linked_ser,'select * from act_tbl1))
where temp_tbl1 is my table at my local machine while the act_tbl1 is the table at the remote site from where i need to pull the data....
when ever i try to execute the package the whole local database gets locked for the time the package is executing. i can query the tables and views but i cannot look into their definitons
can some one pls help
select * into temp_tbl1 from
(select * from openqyery(linked_ser,'select * from act_tbl1))
where temp_tbl1 is my table at my local machine while the act_tbl1 is the table at the remote site from where i need to pull the data....
when ever i try to execute the package the whole local database gets locked for the time the package is executing. i can query the tables and views but i cannot look into their definitons
can some one pls help
Topic Participants
meenakshi.p.jain
app_support
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?