Create a stored procedure

This script creates a stored procedure that updates the servers table. It can be run from the SQL Query Analyzer.

CREATE PROCEDURE add_server  @servername  varchar(20) AS 
Insert servers VALUES (@servername)
GO