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.

Your SQL Server user ID must have sufficient authority to reset an identity seed. If you are the table's owner, this grants the authority, as does a sysadmin or db_ddladmin user type. If your user ...