THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

sp_CascadingDataViewer version 1.1 (beta) released!

Just a short note here to inform anyone that is interested that I have just made available v1.1 of sp_CascadingDataViewer at

This release fixes a bug where any dependant tables with columns of type ‘timestamp’ would cause an error:

"Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column"

Given the nature of timestamp columns I didn’t see the point in including them in the results returned by sp_CascadingDataViewer hence they are simply excluded.


This release still has a beta label attached to it just in case there are any more gotchas like this but don’t let that put you off – I still consider this to be a stable release in all but name (as of this most recent check-in it now includes 32 automated unit tests).


Thank you very very much to Calvin Jones who took the time to report this bug in the comments section of my original post Introducing sp_CascadingDataViewer. Much appreciated.


Lastly, I’m still looking for feature suggestions that might improve sp_CascadingDataViewer so please let me know if you think of any.


Published Sunday, September 19, 2010 10:15 PM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Leave a Comment


This Blog


Privacy Statement