16, is the size of the text pointer which points to another storage
location where the actual text is stored. I'm not sure why it would
tell you that the data will be truncated since a text field should hold
far more than 8000 characters. Perhaps it is a just-in-case message.
Are you on SQL
If I convert an column in a table that is curently a type of
'varchar(8000)' to a type of 'text(16)', does this truncate
the data?
I'm using Enterprise manager, when I put the conversion in,
I note I can not change the size, so I presume that text is
always size '16' and that this
Look into sp_addlogin and sp_adduser.
Bob
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 3:46 PM
To: CF-Talk
Subject: OT MS SQL Server Question...
I want to add a user via TSQL. I have looked all over and in the books
online. I think I am
3 matches
Mail list logo