Vg Database

[jewillis]

In the database scripts for VG, all the non numeric column are defined as NTEXT. Is there any reason why that can not be replaced with NVARCHAR(MAX). There are many reasons, including compares, etc., but from Microsoft SQL Server 2005 documentation: "...ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead..."

 

http://msdn.microsoft.com/en-us/library/ms...93(SQL.90).aspx

 

Jeff

 

 

 

 

[SupportTeam]

You should be able to change them to NVARCHAR(max).

 

Just make the changes in VoiceGuide's \system\setup\Db_Create_System.Data.SqlClient.sql then stop VoiceGuide delete the tables in vgDb on the SQL Server and the restart VG and let VG create the new tables.

 

Thanks for raising this point. Looks like we will probably change the TABLE CREATE calls in Db_Create*.sql files to use NVARCHAR(max).