Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwilliams
194 Posts |
 Posted - 2004-10-11 : 15:59:21
|
| Tech Info: SQL Server 2kI have a basic table that I'm working with in the Enterprise Mgr. Interface, and it has a column called "Answer" with a datatype of varchar. I tried copying & pasting data into one of the fields, but it doesn't allow it. SQL Server acts like it contains too many characters, so I changed the length to the maximum of 8000 characters to see if it would work. The text only has 1,093 characters including spaces. But it still didn't work.So then I tried changing the datatype from varchar to text, and but that didn't with either. Has anyone ever had this problem before? If so, what should I do? Thanks for any & all help.KWilliams |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-11 : 18:11:08
|
| Don't use enterprise manager. Use query analyser and do an insert/update.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kwilliams
194 Posts |
Posted - 2004-10-12 : 09:35:25
|
| Can I ask why I shouldn't use Enterprise Mgr? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-12 : 11:19:45
|
| Because it's very limitted as an update tool and doesn't give a record of what you've done.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Strange SQL Server 2k Problem