Re: [Emerald] DOH!
Dale E. Reed Jr. ( (no email) )
Tue, 09 Feb 1999 09:34:53 -0800
Brandon Bryant wrote:
>
> Does anyone know how to copy an MBR from one SQL server to another? I
> accidentally deleted an MBR that I shouldn't have and didn't realize it
> until it was too late to re-transfer the backup db onto the primary. I
> want to copy ONE MBR from the backup server to the primary. Is there a way
> to do this? I know it sounds much simpler than it is.. But any help would
> be great. Thanks!
For one, you might be better off just re-typing in the information.
If they are on the same SQL Server (Say Emerald and Emerald2 databases),
you can use an advanced select into statement:
SET IDENTITY_INSERT MasterAccounts on
Insert Into MasterAccounts(CustomerID, ...)
Select (CustomerID, ...)