|
|
|
Author |
Message |
kmaki
|
Posted: Tue Oct 26 06:59:21 CDT 2004 |
Top |
SQL Server >> Restore from MDF file
I'm using 2000 version and trying to recover data from MDF file but the
message shows up:
Error 5172: The header for file 'x.mdf' is not a valid database file header.
The FILE SIZE property is incorrect.
SQL Server186
|
|
|
|
|
swati
|
Posted: Tue Oct 26 06:59:21 CDT 2004 |
Top |
SQL Server >> Restore from MDF file
HI!
I want to audit some collumns of one of my huge table . I wrote a trigger
for copying updated data and original data in audit table.
But when I try to update multiple rows , it gives error of "cannot update
multiple rows. "
Is there any easy way of auditing tables without using triggers . I donot
want to use C2-audit .
Regards,
Swati
|
|
|
|
|
Uri
|
Posted: Tue Oct 26 06:55:16 CDT 2004 |
Top |
SQL Server >> Restore from MDF file
Hi
How did you try to recover it?
Have you detached the datafile properly?
> I'm using 2000 version and trying to recover data from MDF file but the
> message shows up:
>
> Error 5172: The header for file 'x.mdf' is not a valid database file
header.
> The FILE SIZE property is incorrect.
|
|
|
|
|
Uri
|
Posted: Tue Oct 26 07:04:41 CDT 2004 |
Top |
SQL Server >> Restore from MDF file
swati
create trigger tru_MyTable on MyTable after update
as
return
insert MyAuditTable
select
i.ID
, d.MyColumn
, i.MyColumn
from
inserted i
join
deleted d on d.ID = o.Id
go
> HI!
>
> I want to audit some collumns of one of my huge table . I wrote a trigger
> for copying updated data and original data in audit table.
> But when I try to update multiple rows , it gives error of "cannot
update
> multiple rows. "
>
> Is there any easy way of auditing tables without using triggers . I donot
> want to use C2-audit .
>
> Regards,
> Swati
>
>
>
>
>
|
|
|
|
|
swati
|
Posted: Tue Oct 26 08:00:25 CDT 2004 |
Top |
SQL Server >> Restore from MDF file
Thanks!! It works properly .
Regards,
Swati
> swati
> create trigger tru_MyTable on MyTable after update
> as
>
> return
>
> insert MyAuditTable
> select
> i.ID
> , d.MyColumn
> , i.MyColumn
> from
> inserted i
> join
> deleted d on d.ID = o.Id
> go
>
> > HI!
> >
> > I want to audit some collumns of one of my huge table . I wrote a
trigger
> > for copying updated data and original data in audit table.
> > But when I try to update multiple rows , it gives error of "cannot
> update
> > multiple rows. "
> >
> > Is there any easy way of auditing tables without using triggers . I
donot
> > want to use C2-audit .
> >
> > Regards,
> > Swati
> >
> >
> >
> >
> >
>
>
|
|
|
|
|
|
|