> 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 th
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 Serv
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 m
3 matches
Mail list logo