Nope. Did not rebuild the index yesterday.

Hats off :-):-):-):-):-):-) To coooooooooooooool !!!!!!!!!!!1

WOW !!!!! That worked like a charm :-):-):-):-):-):-):-):-):-):-):-)

120 vendors as of now vendors added at the rate of around 2 for a month. Will it be possible to auto-increment if a new vendor is added.

Yep In spite of the Numeric Primary Key. We need 2 character Vendor Code for each vendor.

This is a Vendor table. This already has a primary key. The requirement is Alphabets as the unique key rather than the numeric primary key.

Thanks a lot for the prompt reply. Will try implementing as advised.:-)

Our Current Production Server runs on SQL Server 2008 R2 Enterprise Edition. We want to implement a separate Report Server & Tables on the report server will be...

Thanks a lot for updating me with this information :-).:-)

Thanks a lot for the information provided.:-)