3 ms·
SQL server by default creates tablespaces with non ANSI SQL NULL behaviour. Exlicitly specifying ANSI SQL compatibility when creating tablespace makes it "to d
by VladRussian2 13y ago
SQL server by default creates tablespaces with non ANSI SQL NULL behaviour. Exlicitly specifying ANSI SQL compatibility when creating tablespace makes it "to do the right thing"
Edit: was doing it many years ago so forgot the details (or they changed :), so just checked - it is "alter database" that can switch various "ansi_null" default settings into ON from default OFF
- chiph 13y agoThe default in upcoming versions of SQL Server will use the ANSI NULL behavior. http://msdn.microsoft.com/en-us/library/ms188048.aspx http://msdn.microsoft.com/en-us/library/ms188048.aspx