SNMP and SQL Server, is it possible to store the alerts in sql server without using any program?

Solution 1:

SNMP is a protocol. Your legacy system is polling or receiving SNMP from what it's monitoring, and then storing that in SQL. The monitoring system is a program, it doesn't need an additional program to speak to SQL. It's probably got an ODBC or other connection to the database. Check the legacy system for existing ODBC connections. If it doesn't have any (and they might be for the service account running the monitoring system so you wouldn't see them if you were logged in as yourself), then it might have the SQL connection string in an init file somewhere.

What actual problem are you trying to solve?