Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calling COM From T-SQL Expand / Collapse
Author
Message
Posted Monday, September 12, 2005 11:54 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:00 AM
Points: 912, Visits: 208
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/callingcomfromtsql.asp






My Blog: http://dineshasanka.spaces.live.com/
Post #218901
Posted Sunday, October 30, 2005 3:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:40 PM
Points: 8, Visits: 77

Conceptually, databases are to store and retrieve data - that what they do best.

Having "ability" doesn't mean you have to use it. As a DBA and developer, I strongly discourage people to use applications inside SQL Server, or any other database... Because I generally don't trust such applications to properly manage system resources. Using COM from T-SQL will slow down your SQL Server (at best). In most cases it will crash it eventually - fact.

Instead of "smart assing" with T-SQL, you (and your installation) will be better off by having a dedicated server to run application(s) which connect to database server for data.

Post #233663
Posted Monday, October 31, 2005 8:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, Visits: 33

First off -- very well written article!  While as a practice I agree with the above post that this generally isn't a good idea, there are instances where I've seen it used effectively as a stop-gap measure to re-writing an entire application.

It certainly is a security risk (many recommend removing the OA procedures althogether), and there is a visible performance depending on how often the COM object is instantiated.

With all the risks and performance hits, it is a handy feature to be aware of, but NEVER make it your primary plan of action. However, there are circumstances where it might be the only viable option. The realities of most companies place financial and temporal constraints on projects that cause us to consider options we would normally avoid at all costs.

Have I used the OA procedures in production work- no.  Would I use them? Not on something I was building for a client.  Would I tell a client that they absolutely should be removed if already used for an existing application? Not necessarily.  I would point out the risks and costs involved, and stress to them that they should consider eliminating them in the future.

I think they are very useful to know about (and this was a well-written article introducing them), but should considered as a last resort or temporary work-around.




Post #233830
Posted Tuesday, November 1, 2005 5:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:00 AM
Points: 912, Visits: 208
yes it should be used as final "Trump", I should have mention these in the article. Sorry About it!!






My Blog: http://dineshasanka.spaces.live.com/
Post #234081
Posted Tuesday, November 1, 2005 11:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, Visits: 33

Actually I like the article just as is.  It's a great reference for someone in that "trump" situation.  I didn't get the impression you advocating it's usage rather than exploring what it can do and how to use it. Sometimes I think it's good to separate information from recommended practice...

Again, Kudos. Well written an organized and will probably help somebody who has hit that "trump" situation




Post #234239
Posted Friday, April 3, 2009 12:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 25, 2010 5:28 AM
Points: 1, Visits: 7
he he he ......Stop copying from MSDN

http://msdn.microsoft.com/en-us/library/aa238863(SQL.80).aspx
Post #690141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse