Results 1 to 2 of 2

Thread: SQL RowVersion

  1. Mar 3rd, 2002, 11:15 PM #1
    Roshec
    Roshec is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2002
    Posts
    17

    SQL RowVersion

    I've recently migrated data from MS Access to SQL Server 2000, after migrating the data (around about 5 million), I added a column with a data type of TimeStamp, I wanted to make it RowVerion but my SQL Server 2000 beta version doesn't have it. Anyway, my question is, is there a way of populating the column with unique values so that I'll be able to maintain concurreny?

    Thanks heaps!
    Last edited by Roshec; Mar 3rd, 2002 at 11:25 PM.
    Reply With Quote Reply With Quote
  2. Mar 3rd, 2002, 11:39 PM #2
    Roshec
    Roshec is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2002
    Posts
    17
    Don't worry about it, now I know that it gets populated automatically!...( i was looking at the records through the Enterprise Manager and didn't see any data for the TimeStamp!), then I used Query Analzer and they're there!)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width