resetting ms sql id counter

[pld]

hi all, was wondering if anyone knows the syntax to reset the id field column in an ms sql server?

[stolzyboy]

give this a read

[pld]

Worked like a charm, thanks!