[dba-SQLServer] What determines default

FYI, this was caused by installing SP3 to SQL Server.  I still haven't
discovered how to set the defaults for this stuff in SQL Server.  I assume
it's out there somewhere.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Friday, September 10, 2004 11:25 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] What determines default


I am trying to import one a small subset of one of my import files into a
new table.  The import fails "not enough storage".  When I look at the table
definition (it creates the table, but fails on import) the field defs are
varchar 8000.  The other machine was bringing them in as nvarchar 50.  I
have to believe that this is the problem.  How do I cause the table build to
use nvarchar 50 instead of varchar 8000?

John W. Colby
www.ColbyConsulting.com