I have on my SQL box a Stored Procedure in a database called 'Asset'. My problem with this stored procedure is that it wants to reference another table in a separate SQL Server database called 'Discovery' held in the same server group. The table name in 'Discovery' is called 'Audit' and the error message is "[Microsoft][ODBC SQL Server Driver][SQL Server]invalid object name 'Discovery.Audit'" when running the stored procedure. I have tried (with no luck) 'Discovery.dbo.Audit' and am using the generic 'sa' login. The stored procedures permissions are set to 'public' as is the table 'Audit'.
I might resign soon over this, which isn't that bad, but only after I have kicked to pieces the Comms room, which is that bad.