SQL Server--- Sending a message to DOTNET from SQL Server

Question

SQL Server--- Sending a message to DOTNET from SQL Server

deepakkn

Default port

Points: 1430
More actions
January 28, 2010 at 7:17 am

#209544

Can we send a message to DOTNET (and DOTNET shows that message as a pop up).
We have two solutions.
1) We planned to use SQL Server Service Broker.
2) Using xp_cmdShell and using net send.
But, do we have any other solution to send the message?
Thanks
Deepak

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

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Out of the two ideas that you have floated, I guess the Service broker is the best.

Take a look at power Shell, You might be able to do quite some thing with PowerShell and you wont have the security risk of enabling xp_CMDSHELL

-Roy

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 2

I'd also suggest using Service Broker.

Why are you looking for another solution?

deepakkn Default port Points: 1430 More actions · Answer 3

Thanks Roy and Florian.

Roy, I will try to look into the PowerShell.

Florian, we are trying to have any other simple solution rather than using Service Broker. The usage of these messages is very less in the project. So, we are trying to find any other simple solution.

Thanks

Deepak

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

Actually using service broker is quite easy. The SQL Server does all the work for you. Also helps maintain data concurrency since it works with transactions. (Atleast from what I have read, that is what I understood)

-Roy