I would suggest to use a extra identity column to handle this. Here is the output of 2 possible solutions you can find in my test script :...

A new database is a copy of the model database.

So drop the stored procedures you do not need from model, and the newly created databases want have them.

select TABLE_NAME,COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

where DATA_TYPE = 'datetime'

I even tried the statement

sp_tableoption Employee, 'text in row', 2000

on a test table, and this statement is also correct. I realy do not understand what 's wrong doing this in...