naveenreddy.84 (5/12/2009)
Further, also let me know in which scenario the CLR based stored proceduers, triggers etc implemention are used.
The three general cases for SQLCLR use are:
1) Access to external resources not accessible from T-SQL.
2) To insure a common codebase is used on both client and server.
3) When the computation per column or byte is fairly high.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]