ch.omkarreddy (11/19/2012)
the above table i created should have its transactio_id auto-incremented begining with 6 digit number
your requirement is not clear here but what i can assume here is you want to start this identity column with value 100000 ..right ??? if yes then see this link http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)