[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2454
  • Last Modified:

- conversion from 'int' to 'text' is not supported on the connected database server

I have a numeric field that the client wants to be text now. I right-click, choose modify, and change it from type int to text (I also tried ntext). I am doing this in SQL Server Management Express. The database uses Windows Authentication. I get the error message:

conversion from 'int' to 'text' is not supported on the connected database server

What do I need to do? Thanks!
0
gaynes
Asked:
gaynes
1 Solution
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I would change the type to varchar(max) instead of text.  It is much more text like and you would alleviate having things that you had to deal with on the update and changing of the text field.

If this is NOT SQL 2005 then I would change it to a varchar(30) and save it and then change it to text.
0
 
Cvijo123Commented:
imo never use ntext or text if u really dont need and for your example changeing int to varchar(30) should be more than enough.

text and ntext fields are not stored on pages with rest of row data, they are stored on separete part of page and every query that select those columns is slow and u are limited on doing some thing if u have text/ntext field.

so use varchar :)

0
 
gaynesAuthor Commented:
Thanks! Exactly what I needed.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now