Datatype nvarchar(max) not accessible

Hi,

trying to input

create table T (c1 nvarchar(max));

in MS SQL Server Manangement Studio Express results in an error :

Fehler beim Analysieren der Abfrage. [ Token line number = 1,Token line offset = 30,Token in error = max ]

create table T (c1 nvarchar(4000));

is processed w/o errors.

I′ve installed SQL Server 2005 Express Ed. SP2

Microsoft SQL Server Management Studio Express 9.00.3042.00

Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML 2.6 3.0 4.0 5.0 6.0

Microsoft .NET Framework 2.0.50727.42

Betriebssystem 5.1.2600

Any ideas?

Thanks in advance

Werner

This command should work without problems, and did on my computer. Could you check the error log to see if there is more informaiton about the failure there?

Mike

|||

Hi,

thanks for your reply. I think I found the reason.

Being a newcomer I accidently selected "SQL Server Everywhere" and generated a compact sdf-DB. This type of server doesn′t support nvarchar(max) (which is not mentioned in any documentation available in the net).

Setting up a new db (conversion of the sdf to mdf format is not possible (?)) fixed the problem.

btw, I can imagine using large datafields even on a PDA, so what′s the reason for not supporting this datatype (I do see a parallel to those guys of TI in the late 70s who invented the datetime format for PCs, saving 2 byte...)

Thanks anyway for your fast reaction and your help offered

Werner

Databaseaccess

Hi,
how it is possible to make a limition of access to a
database ?
I want that the database is only accessible from only one
other database !
Greetings,
Daniel RakojevicYou limit access by assigning rights to Logins. If you don't want anyone to
have access then don't give them a Login or password and they won't be able
to get in.
Andrew J. Kelly
SQL Server MVP
"Daniel Rakojevic" <anonymous@.discussions.microsoft.com> wrote in message
news:113cb01c3f4a6$9f16dcd0$a601280a@.phx
.gbl...
> Hi,
> how it is possible to make a limition of access to a
> database ?
> I want that the database is only accessible from only one
> other database !
> Greetings,
> Daniel Rakojevic|||Thanks,
i have an internet application and my user is iusr_daniel.
For the hidden database, i need now a new user ?
How to make it, with an new user ?
Greetings,
Daniel

>--Original Message--
>You limit access by assigning rights to Logins. If you
don't want anyone to
>have access then don't give them a Login or password and
they won't be able
>to get in.
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Daniel Rakojevic" <anonymous@.discussions.microsoft.com>
wrote in message
> news:113cb01c3f4a6$9f16dcd0$a601280a@.phx
.gbl...
one
>
>.
>|||If that database is on the same server then just make sure the user from the
other database is a valid user in that one. If you don't add any other
users into the second database then that user should be the only one who can
access it other than sa's.
Andrew J. Kelly
SQL Server MVP
"Daniel Rakojevic" <anonymous@.discussions.microsoft.com> wrote in message
news:10e1401c3f52f$6620cec0$a101280a@.phx
.gbl...
> Thanks,
> i have an internet application and my user is iusr_daniel.
> For the hidden database, i need now a new user ?
> How to make it, with an new user ?
> Greetings,
> Daniel
>
> don't want anyone to
> they won't be able
> wrote in message
> one