Here are the steps I have followed:

1.Took a full back up of an existing database (abc.bak)

2.Executed your script, but using entirely new database name thinking that it will create a...

I have created the stored procedure in Master, then ran the following command:

exec sp_restoredb N'mydatabase', N'D:\mydatabase.bak'

I get the following error when trying to run the restore command:

Msg 213, Level 16, State 7, Line 1

Column name or number of supplied values does not match table definition.

Msg...

Ten Centuries: Thanks a bunch. Your hard work helped (and saved) me.