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 |
|
SqlStar
Posting Yak Master
121 Posts |
 Posted - 2003-12-02 : 06:58:01
|
| Hi,I have faced an problem when creating table from Query Analyser. See the following scenario:a) Once in my table had an "image" datatype column.b) Now I have removed that column from my table.c) I have generated that table script from Enterprise manager.d) When generate that table script,that script contains this option "TEXTIMAGE_ON [PRIMARY]"I have removed that image datatype column. Why this option coming, when generate script??If I remove that option "TEXTIMAGE_ON [PRIMARY]" and execute the same script, table didnt create it says error like "Cannot use TEXTIMAGE_ON when a table has no text, ntext, or imagecolumns." WHY??Please send me your valuable reply as early as possible.Thanks in advance.While we stop to think, we often miss our opportunity. |
|
|
|
|
|
TEXTIMAGE_ON problem