Re: [Emerald] Yet another SQL problem

Ed Miller ( (no email) )
Thu, 29 Jul 1999 13:27:55 -0400

When I tried this I got records in the calls table but got nothing in the
Master or subaccount table. Is there a way to copy exclude some tables?
This is why last week I was getting 0 records after a copy.
It sounds like I am hosed.

> Ed Miller wrote:
> >
> > Anyone know what it is and or how to fix it. The working copy of the dB
is
> > the only copy I have
> > all backups are bad. This seems to have been in the dB for a while.
April
> > 15, 1999
> >
> > I have removed all records before April 10, 1999 with no problem.
> >
> > I am reluctant of removing any records past the April 115, 1999 date in
fear
> > of destroying the table or the dB.
> >
> > I need advice from the SQL experts out there.
>
> I would create a clean database (blank) and do a DB Transfer from your
> current DB to the new (blank) one. This will copy just the data, and
> not any errors in your current DB. I've had to do this a couple of
> times when something in a DB was corrupt, and DBCC wouldn't/couldn't
> fix it.
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart