Hi David,

>I have several databases on my server that have the same structure. I have a stored procedure that I want to run periodically on each database. Instead of copying the same sp to each database, I could add it to master. If I do that, how do I tell it which database tables I want to reference? I get 'invalid object name' because it looks like it switches to the master database to run the sp. Tell me if I am not making sense.

you can either switch to a specific database with

USE yourdb1

or you can explicitly reference the DB objects with

SELECT * FROM yourdb1..tablename

HTH,
Armin