When I run the sp like this it creates the table but never insert data into it. ????

Never mind...I took out the begins and ends and it works fine...

Thanks sooo much! You have been a life saver!

This works, but I know it can be cleaner. I wasn't sure how to check for existing table and create or truncate.

CREATE PROCEDURE spALARMS

AS

IF OBJECT_ID('tALARMS') IS NULL

BEGIN

CREATE TABLE...

That is exactly how I felt...

This is what i came up with. It works, but I am not sure (not being very adept at SQL Server) if there is not...

I removed my post because I figured it out. I was not trying to be sarcastic, I just didn't want to waste anyones time when I already got the answer...