Send data from SQL to a serial port or IP address I've been asked to integrate SQL transaction data with a video monitoring system in real-time. The video system's application is only capable of receiving data by listening on a serial port or a specific IP address and port. 

Is it possible to write/send data from SQL to a serial port or IP? How?

The transaction data is stored in a Microsoft SQL Server 2005 database.

I can't find anything around this on Google or this site. Every search returns how to pick up data from serial and write to SQL dbs, not the other way around.

I may be going around this the wrong way - any related relevant ideas are welcomed.
No SQL Server will not be able to write directly to a serial port or TCP socket.  You'll need to either write an application that pulls the data from the SQL Server, or a SQL CLR procedure that calls out to the TCP IP address and socket.

I'd recommend using an app to query the SQL Server database then write that data to the serial port or TCP socket.