NVarchar(Max) odd results

• 
  I haven't come across this problem before - could you provide me with a little more information?
  
  1) Where does the script folder come from? Is it saved directly from the live database (and if so with what version of Compare), or has it been edited by hand / generated by some other tool?
  
  2) Does the script file for the troublesome object actually contain the string '[sys].[nvarchar(max)]' or is the script parser changing the line containing this type in any way?

  Michelle T December 01, 2008 06:10

  - 0 +
• 
  Sorry, my fault...
  
  I was editing the scripts to remove a large number of extended properties and changed from ntext to nvarchar(max), but I wrote it as [nvarchar(max)] rather than [nvarchar] (max) so the parser was confused.
  
  Paul

  paulh December 02, 2008 11:05

  - 0 +

Add comment

Please sign in to leave a comment.