>>I'm developing a stored procedure in a test database and I would have liked then to have pointed it at the "live " database, instead I have to create the stored procedure in the live database.
Do I understand what you want to access data in database L from a stored procedure in database T?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.