How to poll a database using a stored procedure?

Using a stored procedure, how do I po开发者_C百科ll a table every 15 minutes (maybe longer)? Based on what that polling finds, I'll be inserting data into another table.

You should use the SQLAgent or some scheduler to run the procedure every 15 minutes.
A stored procedure is a transaction. You don't want one procedure just looping/waiting.

Is there a reason you don't want to use a trigger?

This isn't really a job for a stored procedure in my opinion. This sounds more like something for SQL Agent.

That said, you could run a stored procedure that used a WHILE loop along with WAITFOR and that should do what you're trying to do.

WHILE (1=1)
BEGIN
    -- Check your table, etc.

    WAITFOR DELAY '00:15:00.000'
END

An UPDATE/INSERT trigger could also be used for this, then you don't have to worry about anything constantly running and potentially failing.