Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-04 : 08:29:25
|
| Scott writes "I have a third party program that monitors a named pipe for requests and answers those requests (on the same pipe).Using the dbms_pipe stored procedure in Oracle, I am able to programatically write to and read from the named pipe from within a stored procedure and am wondering if it is possible to do the same from within SQL Server.There is a wealth of information on the web on communicating with SQL Server using named pipes from external applications, so I am assuming that there must be some method for using pipes from within the database.Has Microsoft supplied any System Stored Procedures to communicate with local (or network) pipes? Is there a way to communicate with the supplied system DLLs?As named-pipe friendly as SQL Server seems to be regarding backups et al it seems that there must be some way to talk back and forth with named pipes from within Transact SQL, but there doesn't seem to be any mention of this functionality on the net (at least when googled with the queries I've written).Anybody have any advice?-A frustrated PL/SQL programmer trying to ramp up on a new database" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-04 : 13:43:59
|
| You can communicate via named pipes by adding an alias via Client Network Utility that uses named pipes. All communication though on that machine will be via named pipes as it isn't session specific.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Writing and Listening to Named Pipes from a Stored Procedure