I've been hating on it ever since i first was forced to use it, about a year and a half ago.
I first started out working with MS Access, and while SQL Server 2012 only sucks about half as much, it's still a sore and painful experience.
Now one of the worst things about SQL Server 2012 is that by default it requires you to be 100% flawless in you database design. You're not allowed to change a single thing after deploying the database, and if you try, then you get this error:
And being a grade A noob at database management i assumed there was no way around this. So i have been redoing entire databases from scripts way to many times now. And i must admit that i got a bit mad when i found the solution to this problem ;)
Just go disable this error dialog in:
Tools -> Options -> Designers
And uncheck "Prevent saving changes that require table re-creation"
And voila! no more silly errors!
No comments:
Post a Comment