June 2005 Blog Posts

  • Determining RI Sequence

    My project is getting ready to roll, so data versioning has commenced.. Backup, restore, BCP etc... Digging around in the toolkit, I dredge up an old procedure I wrote for load/unload in version 7.  It didn't have the “owner” of the table and avoided circular references.  So I set out to bring it up to speed ... It should work in both 2000 and 2005 (and 7 when turned into a proc). Can someone give it a whirl on 2005 and tell me how it goes ? 'Cause if they have messed with the INFORMATION_SCHEMA views I 'll.........#%#%#$#$%................ CREATE FUNCTION RISequence()RETURNS @RISEQUENCE...