SQL Server view reverts
Posted on 2013-01-22
I have a SQL Server database which manages our orders and production scheduling, including integration with our Fedex and UPS meters. The database (not created by me) has a view which is a source table for our UPS & Fedex computers to pull shipment data from.
I have altered the view to include a few additional columns from one of its source tables (in fact I have added a new table to the view definition), and altered the Fedex & UPS integration profiles also. All works perfectly, until the server running SQLserver reboots. When that happens, the view reverts to the original view definition. I have searched online for a solution to this but have found nothing. it's quite a problem because the import/export profiles don't work if the view has reverted and i have to run a script to drop/recreate the view every time the server is rebooted.
As well as this problem, if I open a View in Design mode and alter it, I can't do a 'Save as' to overwrite the existing view definition. I've only been able drop and recreate the view to alter it. Perhaps the two things are related?
I'd appreciate any insight into either of these issues -