No. Thats actually the default.
> (I've seen scripts posted by Dale before saying "you need to be running
> 7.0", but I want to be sure that none of the stored procedures that Emerald
> 2.5.294 call NEED to be SQL 6.5)
Nope. SQL 7 has new functions/features that some scripts use (like
replace) that 6.5 doesn't have. Those are the ones that need 7.0.
Its not a sp_dbcmptlevel issue.
> The reason for this is I want to run: ALTER TABLE Calls ALTER COLUMN
> UserName VARCHAR(32) NULL
> to change the length of the UserName column to match the length of the
> UserName column in the Subaccounts table.
Thats fine. I would just use Enterprise manager to change the designe
of the table. Its much better than SQL scripts.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart