There is an article here on SQLServerCentral.com that discusses logon triggers and how they can be used to restrict access by IP address. This is valid on SQL 2005...

SQL 2008 has new trigger/audit abilities that would allow you to validate the IP address where the user connected from and cancel the connection or log them off(http://technet.microsoft.com/en-us/magazine/2008.04.sqlsecurity.aspx)....

Since you are only backing up the three system database try to eliminate the select/loop and just specify the database names.

Create procedure [dbo].[Backup]

As

Begin

DECLARE @name VARCHAR(100) -- database name

DECLARE...

I didn't say it wasn't in sysdatabases, I said the query may not be returning it. It could be an issue with the code or something different about the...

Sounds like the SELECT is not returning the database from sysdatabase since there are no errors and the backup attempt was never made. Run the query "SELECT name FROM...

Each instance of SQL server on a server is a complete separate entity (ie. SQLServer1\Instance1, SQLServer1\Instance2). One instance can not be accessed from another instance unless it were setup...