Can I reseed Identity field of replicated table (at subscriber)

Question

Can an identity value be reseeded to its inital value, provided that the table is in subscriber db (Sql Server Ce) under replication.
If yes, then how? as this statement cannot be executed over Sql Server Ce. 

DBCC CHECKIDENT(ALaCarte, RESEED, 2001)

Omair Imran, S. M.

---

9221

Answer 1

You can reseed as described here: http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/7b3d4664-a49b-4874-9091-75ee5909988c/

I don't think you can do this on a replicted table, tough. Generally, I avoid identity columns in merge replication, but use uniqueidentifier instead.

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 2

Many thanks

It worked over replicated table. All I needed to do is to bring the compact db to workstation from the hand held and execute the script and move it back. Later on the new transaction were successfully performed as well as synchronized.

Thanks

Omair Imran

---

9221