December 6, 2007 at 10:13 pm
Hi Everybody
Yesterday i created a view through diagram and saved . Later i added some other columns to that view and saved. Today i observed that the columns added to the view are missed. The same thing happened in procedure also . Have any body faced this problem? Is this is a bug?
Andras are you observed this?
Ramaa
December 7, 2007 at 8:57 am
Changes occur immediately if you save them. It is possible to add them and not save them.
December 7, 2007 at 10:09 am
also, bit random i know but if the database was restored to time before the views were created then the changes would be missing
Gethyn Elliswww.gethynellis.com
December 7, 2007 at 11:36 am
Maybe this:
select
name,
create_date,
modify_date
from sys.views
will help you to figure out what has happened to the view
December 11, 2007 at 6:32 am
Hi
Thank you all for your info
Ramaa
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply