Viewing 3 posts - 1 through 3 (of 3 total)
If you really need a flat file and DTS is not suitable then the bcp utilily might be worth a look. It is quite powerful. You can use it for import...
August 18, 2005 at 2:14 am
#582931
You may find sp_help_revlogin useful. I have used it when migrating a database, to help transfer the relevant logins *and* passwords to the new server. But it can just as easily be used...
August 9, 2005 at 2:50 am
#580624
What you outlined is a really useful technique, I have used it many times.
However sometimes you may need something a little more complicated. In those situations the OPENROWSET statement may...
July 8, 2005 at 3:17 am
#572221