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.
TIA