The 'sp_OA' stored procedures are rarely utilized in mainstream T-SQL programming. This script (and the accompanying article) is a superb example of what can be achieved within SQL Server and beyond regular DML. Nathan H.O. Moderator SQL-Server-Performance.com
quote:Originally posted by satya Useful link Dragica, thanks. _________ Satya SKJ Moderator SQL-Server-Performance.Com Except for those of us who aren't members of sqlcentral.com. [V] I could post a script I have that uses sp_OA* to put table records to an IBM MQSeries queue if anyones interested. I picked it up in the MQ newsgroups a year or so ago after a couple guys couldn't get it working (credit where credit is due). I spent all of five minutes on it and had it working... I would like to see this pdf script however, if someone could post it here instead. [?]
Its easy to register on SQLCentral websitehttp://www.sqlservercentral.com/forums/join.aspx and then you can access the specified link. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by Haywood quote:Originally posted by satya Useful link Dragica, thanks. _________ Satya SKJ Moderator SQL-Server-Performance.Com Except for those of us who aren't members of sqlcentral.com. [V] I could post a script I have that uses sp_OA* to put table records to an IBM MQSeries queue if anyones interested. I picked it up in the MQ newsgroups a year or so ago after a couple guys couldn't get it working (credit where credit is due). I spent all of five minutes on it and had it working... I would like to see this pdf script however, if someone could post it here instead. [?]
?? Any issues with the site or script? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.