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 |
|
Goalie35
Yak Posting Veteran
81 Posts |
 Posted - 2011-03-04 : 02:18:11
|
| I created a new stored procedure on my test machine successfully. Everything worked fine.When I went to create this same SP on my live production machine however, I received an error:----------------------------------------------Msg 6354, Level 16, State 10, Procedure procedure_trigger, Line 19Target string size is too small to represent the XML instance----------------------------------------------So I performed a few tests:1) I removed all sql code from the SP just to see if I could create a basic, blank SP but still received the same error. So it's nothing within my SQL code.2) I'm still able to alter any preexisting SP's successfully. So it's only a problem when I CREATE3) I do have several triggers setup (which are not on my test machine) however I don't have any called "procedure_trigger", as it mentions in the error, from what I can find. Any idea what may be wrong?Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-03-04 : 11:17:13
|
| Are there any triggers involved in the objects accessed by procedure_trigger? Do you have any DDL triggers in place?=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
|
|
|
Unable to CREATE stored procedure