Viewing 3 posts - 136 through 139 (of 139 total)
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.
March 5, 2004 at 12:38 am
#497471
select TABLE_NAME,COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
where DATA_TYPE = 'datetime'
March 5, 2004 at 12:33 am
#497470
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...
March 2, 2004 at 12:19 am
#496595