SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

How to Reset an Identity Seed in Microsoft SQL. Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one ...