Can I use DTS to transfer data to another sql server 2k?
During DTS transfer, can sql server allow user to insert
data? If so, would the databased be crashed by DTS ?

"DTS" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You can use DTS to transfer data, but you will need to be carefull about
what type of locking and blocking takes place, and to some degree this may
depend on the amount of data and the speed of connection between the
servers. A smaller transfer will be less likely to impact your system.


--
Darren Green
http://www.sqldts.com