Which version are you using? Looks like you have migrated from a previous version of Sql Server. I had a similar problem when I tried to migrate from 2008 to 2008 R2.
There is probably a good reason for that. Instead of figuring out how to bypass it, you should figure out what that reason is and decide what you want to do.
dn631
Member
6 Points
39 Posts
Re: how to get system date
Dec 22, 2012 12:03 PM|LINK
when i am saving.....
i get this error
arun banik
Member
90 Points
21 Posts
Re: how to get system date
Dec 23, 2012 01:51 PM|LINK
Which version are you using? Looks like you have migrated from a previous version of Sql Server. I had a similar problem when I tried to migrate from 2008 to 2008 R2.
oned_gk
All-Star
31549 Points
6446 Posts
Re: how to get system date
Dec 23, 2012 11:19 PM|LINK
Hey
Hey, change your management studio setting
Tools -> options -> Designer -> prevent saving changes that require table re-creation
The error not from your datetime, you will get this error message when you change table that need re-creation.
Change the option above and you will never get the message again.
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: how to get system date
Dec 23, 2012 11:36 PM|LINK
There is probably a good reason for that. Instead of figuring out how to bypass it, you should figure out what that reason is and decide what you want to do.