-
A problem on restore the database to a new device
Hi Experts,
I am Kenny and this is my fisrt time to try this site.
I have a problem on restore the database to a new device.
When I backup a new device to the disk and restore to an other new device,
the data totally work and use DBCC check consistency. However,
the store procedure and the view is abnormally and need to recompile again
Why ?
And I want to know SQL Server 6.5 have a command to compile all
the view and store procedure that no need to compile one by one ?
Thanks for you advice.
Best Regards
Kenny
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|