Next time make sure you drop all the permissions on the old database after
moving the server, this way they simply wont be able to enter anybody new
and you'll know about it immidiately. It happened to me too, but i caught
it after less then 10 accounts :)
At 09:11 PM 12/2/97 -0600, you wrote:
>
>
>I need some help... We are in the process of switching to a new SQL server
>machine and
>like an idiot, I forgot to tell one of our locations to stop entering
>people into the old system..
> I have 200 records sitting in the old server that I would like tranfer
>over to the new one.
>Question is: How can I re-transfer the old DB to the new DB without
>"hurting" the new
>data that has been entered? I am SQL clueless so detailed instructions
>would be nice.
>
>
>Barry
>barry@mdex.net
>
>
>
>Take care,
>
>Barry Kiesz (barry@mdex.net)
>Internet System Administrator
>
>-----------------------------------------------------------------
>Hard Drive Central http://www.hdc.net - LOCAL ACCESS IN:
>423 Moccasin Drive Voice 605.229.1562 - Aberdeen,Yankton,
>Aberdeen,SD 57401 Fax 605.229.1563 - Mitchell,Watertown,
> - and Sioux Falls! Flat-rate unlimited Local dialup for only
>$14.95/month
>Commercial Web Hosting starting at only $10.00/month
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>
Laslo Orto Computer Pages / Better.Net
Systems Administrator 253 Sheppard Ave. West
laslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2
www.cpol.com / www.better.net Ph: +1 416 225 3030
Fax: +1 416 225 6737