| Author |
 Topic  |
|
|
raastab
6 Posts |
 Posted - 02/15/2009 : 21:46:06
|
The following line is found in some of the static data scripts generated by DBGhost
DECLARE @FileLocation nvarchar(max)
The files are generated when scripting a database located on a sql server 2000 box. I'm attempting to build a database on a sql server 2000 box. Because of the nvarchar(max) keyword, which is not supported by sql server 2000, the build fails.
Is there a way to make the scripts generated compatible with sql server 2000? What are my options here?
Thank you for your time on this.
|
|
|
raastab
6 Posts |
Posted - 02/15/2009 : 21:58:31
|
Quick Update:
The line described appears in just one static data sql script. Other scripts contain variations of that line. The pattern would be:
DECLARE [SomeVariable] nvarchar(max)
The common thread is that each file containing this pattern has a column called SomeVariable of type nvarchar() and size of 4000.
Unfortunately, I still don't know how to prevent this line from being generated. In the next few days I'll try changing those columns to NVARCHAR(3999), though that's not an ideal solution. |
 |
|
|
raastab
6 Posts |
Posted - 02/15/2009 : 22:02:33
|
Quick correction :)
I should have said nvarchar(2000), not 4000. |
|
|
|
raastab
6 Posts |
Posted - 02/15/2009 : 22:34:23
|
One last update:
My last note is incorrect. This only happens when the column is nvarchar(4000).
I did change a couple of columsn to be nvarchar(3999) and it corrected the problem. I'm still interested to know what my other options are. |
|
|
|
Mark Baekdal
86 Posts |
|
|
raastab
6 Posts |
Posted - 02/16/2009 : 10:42:01
|
Hi Mark,
Thanks for checking in.
Version: 5.0.0.852 |
|
|
|
Mark Baekdal
86 Posts |
|
|
raastab
6 Posts |
Posted - 02/16/2009 : 10:59:05
|
I'm evaluating right now, so I don't believe the latest version is available to me. That said, I believe I'll be making the purchase in the coming days. So far, this is the only issue I've run into and I have been able to work around it.
Once I purchase, I should get a member userid/pass and be able to upgrdade. At that point, I'll retest and let you know what I experience. Thanks again for getting back to me. |
|
|
|
Mark Baekdal
86 Posts |
|
|
Mark Baekdal
86 Posts |
Posted - 02/17/2009 : 06:28:47
|
could I get the DDL for one of the tables that you are having problems with? And if you could the insert script? You can post them to support at innovartis dot co dot uk if you like.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Take control of your SQL Server code.
|
|
|
| |
Topic |
|
nvarchar(max)
