Just a short note here to inform anyone that is interested that I have just made available v1.1 of sp_CascadingDataViewer at http://cascadingdataviewer.codeplex.com/releases/view/52586
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.