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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 EXEC sp_tableoption

Author  Topic 

WalkerDA
Yak Posting Veteran

61 Posts

Posted - 2004-05-28 : 11:26:13
I need to place in a row characters that exceed 255 characters, is there a way of doing this? I've tried EXEC sp_tableoption 'MY_VALUES', 'text in row', '6000' but unless I'm missing something else, it's not functioning the way that I need it to.

Any thoughts?

Derrick Walker

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-28 : 12:43:31
So MY_VALUES is a user-defined table and it has a text column in it? What version of SQL Server? What's the error?

Tara
Go to Top of Page
   

- Advertisement -