SQL_CLR procedure triggering for no reason

Question

SQL_CLR procedure triggering for no reason

deepakdilse

SSC Journeyman

Points: 97
More actions
June 4, 2009 at 11:51 pm

#205503

Hi There,
i have an SQL_CLR Stroed Proc , which has partof my business logic , registers to a socket server .
for some reason this is called to triggered to many times .
when i see "netstat -b" , i could see many socket connections all by SQLserver.exe process .
is there any trigger point inside sqlserver which will responsible for this . i think this is defintly not by my code.
any suggestions/comments ?
Thanks
Deepak

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

A stored procedure only executes when called by your code. What do you mean by registers a socket server and why are you doing this from a SQLCLR stored procedure? This isn't a supported operation, and the socket server is going to be created for each invocation of the stored procedure, so it isn't surprising that you would be leaking sockets as shown by netstat.

deepakdilse SSC Journeyman Points: 97 More actions · Answer 2

hi Jonathan ,

Thanks for the reply, the bug was acutally on the application , sorry for wasting your time.

Regards

Deepak

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

No problem.