I have a stored procedure that I use to execute database backups.  It deletes
old backup files and then creates the full backups of all the databases.

I want to create an ID that can only execute this procedure.  I tried
creating a SQL ID with execute permission on this SP and then put the ID in
the db_backupoperator role in each database.  But I keep running into
permission issues.

Any suggestions?

Different between ##table and #table regarding performance
Problems while migrating from MSSQL 2000 to 2005 - select... into fails in a trigger - please help.
sp question re: dynamic sql
Crazy Row Numbering Poblem
Stored Proc SQL 2000 and Dates