System.NET, System.Net.Sockets -> TCPListener Issue
Hi Rich,
Well, the functionality I was looking for was like what MSSQL Profiler
provides. I want to be able to read all the SQL Statements coming down
through the TDS packets and display them on a form.
Do you think shutting down SQL Server and creating a listen socket to 1433
and then restarting SQL Server will do the trick?
Thanks
Quote:
> If SQL is already up and running, the port SQL uses --1433--should be
coming
> back as "in use". If you really want to listen on that port, you'll have
to
> shut down SQL and then create a listen socket asigning its local port to
> that port number.
> hth
> > Hi,
> > I'm trying listen to all the traffic going to my SQL 2000
> > Server using the System.Net and System.Net.Sockets
> > namespace.
> > Is this possible? I tried using TCPClient and TCPListener
> > to do this... but invain!
> > Thank you.
> > Shri
