Solved

Invalid object name master.dbo.spt_datatype_info

Posted on 2011-02-15
6
2,117 Views
Last Modified: 2012-05-14
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.
0
Comment
Question by:mcseteach
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:devlab2012
ID: 34897997
Set the compatibility mode of database to 2000. But be careful that if you new features of SQL 2008 will not be available in that case.
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 34898934
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

http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/53c17b91-0681-4ef7-a443-68cce17614b4/

It tells you all about this view and even an idea to create a new table manually.

I strongly suggest the application is updated to work with 2008 with its new features but at least this solution will get you back up and running until its updated.
0
 

Author Comment

by:mcseteach
ID: 34900153
Thank you for the lilnk GMGenius.  We found a simular post in a different forum with the method to recreate the table but when our database admin attempted to use it he stated that it is missing a fixed length column and therefore did not perform properly.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 12

Expert Comment

by:GMGenius
ID: 34900568
I suppose the question next is, what are you using this data for?
0
 

Author Comment

by:mcseteach
ID: 34900742
Goldmine is used to work with potential students by Admissions.  Once they are accepted the information is sent from Goldmine to a campus wide CRM running on SQL2008.  Our current Goldmine is on SQL2000 and we would like to upgrade to a newer version running on SQL2008.

The stored procedures referencing the "expired" object are optional procedures that are used in conjuction with the Goldmine API. Apparently a standard installation of GM 6.7 does not contain references to the  retired object. This communication between databases was setup before my time here and there is little documentation.
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 34901102
I think the only option is to re-work the additional updates, perhaps the content can be copied here?
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question