Identity Seed

Hi guys,
Please is it possible in SQL SERVER any version (Prefferably 2005) to set my Identity seed to the current year so that when we are in 2008 it continues from 2008 ?

Best Regards

I'm not too sure why you want to use current year as the seed. Anyways, AFAIK this is not possible.

Can you explain your problem so that we can help you better ?

|||

websyd:

set my Identity seed to the current year so that when we are in 2008 it continues from 2008

This defeats the purpose of an identiy column, Identiy columns are "dataless", they have no intrinsic meaning other than to uniquely identify the row within a table. And you can't do it, anyway.

What are you trying to do?