HP3000-L Archives

August 2004, Week 5

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
OT: SQL Server 2000 assistance
From:
Bob McGregor <[log in to unmask]>
Reply To:
Bob McGregor <[log in to unmask]>
Date:
Tue, 31 Aug 2004 09:27:42 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (18 lines) 
We have a database in SQL Server 2000 and I need to change a field from type TEXT to type VarChar with enterprise manager (I think).  Anyway what I planned to do was to add a new varchar field and then update it with the contents of the TEXT field, delete the TEXT field and rename the varchar field to the TEXT field name.  Hopefully that works...

My problem is when I go to add the varchar field I get these messages:

warning: One or more existing columns have ANSI_PADDING 'off' and will be re-created with ANSI_PADDING 'on'
warning: The table was created with ANSI_NULLS 'off' and will be re-created with ANSI_NULLS 'on'

Is there a way in enterprise mananger I can set these items before I add the field to the table? I can't seem to locate a command window in enterprise manager to set the items.

The database is vendor supplied with the ability to add custom fields which we did only specified TEXT instead of varchar and want to change it. I'm concerned if I change the settings above the software will not like it.

Any help would be appreciated.

bob

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2