The issue we are experiencing is with cross database communication. We have a custom built solution (Golmine API, Triggers and Stored Procedures).
After we upgrade from Goldmine 6.7 (SQL Server 2000) to Goldmine 7.6(SQL Server 2008) our test user attempts to initiate a transfer between the two databases and receives the message “ Invalid object name 'master.dbo.spt_datatype_info' ”. After research it appears that this is a table that was retired by Microsoft between versions 2000 and 2005 of SQL server.
This is a mission critical application for us. Any thoughts on how to resolve this issue would be greatly appreciated.
Just to add some additional info
I recently had cause to look into this also and found a good thread on a form you can read
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.