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 |
|
adasnc
Starting Member
3 Posts |
 Posted - 2003-02-17 : 22:23:18
|
| I'm transferring a table with a trigger from a MSSQL server 6.5 database to another MSSQL server 6.5 database, however, the trigger cannot be created because of error: "[Msg 2735, Level 16, State 4] Object text is too long - can only support 255 rows in Syscomments. Shorten the object text or split into multiple objects. Text which caused overflow starts at......". The only difference is the source MSSQL server is running on an alpha machine, whereas the destination MSSQL server is running on an intel machine. Why this problem occurred? Is there any other solution for it other than shortening the trigger??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-19 : 12:50:45
|
| [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23897[/url] |
 |
|
|
|
|
|
Transfer between Alpha and Intel machines problem