Ever needed to compare a ColdFusion hash() directly in MS SQL? I did today and I knew I had accomplished this before but forgot how to do it. Searching the net and twitter I came to some dead end or longish solutions. I knew Steve Good and I worked this out once before but I also remember there being an easier way.

Well there is and here is where I took the solution from: http://orangepips.instantspot.com/blog/Database

The funny thing is I found this nearly a year ago and actually commented on the post just forgot all about it.

<br /> <cfquery datasource="SQL"><br /> insert <br /> into Contact<br /> ( firstName, firstNameHash )<br /> values ( <cfqueryparam cfsqltype="cf_sql_varchar" value="Paul" />,<br /> <cfqueryparam cfsqltype="cf_sql_varchar" value="#hash('Paul')#" /> )<br /> </cfquery><br />

<br /> select id, firstName, firstNameHash, upper(right(master.dbo.fn_varbintohexstr(HashBytes('MD5', firstName)), 32)) AS sqlHash<br /> from Contact<br />

The result:

We recently upgraded a few SQL server boxes to MS SQL Server 2008. I also installed the new Enterprise Admin tools and after working on a new project I hit a slight brick wall.

"Saving changes not permitted" 

This kept coming up when I tried to change column attributes and re-arrange column orders for a table that existed.

It was odd I could make schema changes like this with SQL 2005 why not 2008?

Turns out its a simple setting that's on by default in the SQL 2008 Enterprise manager ( Express and Full ) and João Fernandes gave me the solution over twitter only a few mintues after I asked.

Here are the exact steps:

Click "Tools" , Select "Options", Expand "Designers", select "Table and Database Designers" then deselect "Prevent saving changes that require table re-creation"