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 |
|
u4cast
Starting Member
16 Posts |
 Posted - 2004-03-02 : 09:20:26
|
| Has anyone tried inserting text into a text column using something like this:CREATE PROCEDURE SP_WRITE(@ABC TEXT) ASINSERT INTO TBL_IN (TEXTCOL) VALUES (@ABC)and got the error:Error 21037: [SQL-DMO] The name specified in the Text property's 'CREATE ...' statement must match the Name property, and must be followed by valid TSQL statements.It works fine if the table has only got a text column but this table has an INT identifier column (ID) and another column that has a default value.Any ideas what might be the problem? It's SQL 2000 btw.Thanks,Paul |
|
|
u4cast
Starting Member
16 Posts |
Posted - 2004-03-02 : 11:46:02
|
| Dropped the SP and recreated it - hey presto the problem was solved. |
 |
|
|
|
|
|
text column?