Skip to content

MikeBevers.be

Putting it out there…

Archive

Archive for July, 2010

Context

I’m not a big fan of handling exceptions in stored procedures. It means that you have complicated queries, thus have some business logic in them. Although I like to keep my logic in code, sometimes it’s necessary to have some logic in your stored procedure.

Usually, I only use it to increase performance.

continue reading…

The Problem

I generally like using the IDE’s that Microsoft provide for developers. But in this case, I had an annoying problem. When creating my database model I always use Microsoft SQL Server Management Studio. As you all know, during development your tables often change a bit. You create new columns, delete old ones, change the type of a column, define new keys, etc.

In SQL Server 2005 SSMS I don’t remember doing one of the above actions resulted in an error. Now I’m using SQL Server 2008 SSMS and I repeatedly got the error: “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created”.

continue reading…