Subject | Can't restore database with invalid SP-s |
---|---|
Author | kimon_the_athenian2 |
Post date | 2005-11-03T07:48:59Z |
Hi!
Once I managed to setup my stored procedures so that in one place (a
trigger) a procedure was used with different parameter list than in SP
definition. It only caused errors when the trigger was executed or when
database was backed up and then restored. Seemed that dependency
information between SP and trigger was lost.
Then I could fix the SP usage in trigger, but now I have a backup which
seems to have same problem. gbak restores only tables but no sp-s or
views.
Tried gback with -n option but it didn't help.
Any advice how can I restore it fully?
thanks,
Aivar
Once I managed to setup my stored procedures so that in one place (a
trigger) a procedure was used with different parameter list than in SP
definition. It only caused errors when the trigger was executed or when
database was backed up and then restored. Seemed that dependency
information between SP and trigger was lost.
Then I could fix the SP usage in trigger, but now I have a backup which
seems to have same problem. gbak restores only tables but no sp-s or
views.
Tried gback with -n option but it didn't help.
Any advice how can I restore it fully?
thanks,
Aivar