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