Attaching legacy FMS database to SQL2012 instance
We have an old legacy FMS database which we've just dbattach'd from our old SQL2008 server and are attempting to now attach it to a SQL2012 instance. Unfortunately I'm getting the following error "Could Not Find Stored Procedure 'sp_dboption" midway through the attach process. From the looks of things 'sp_dboption' is not longer supported on SQL2012 so how do we attach the database? Will doing it through the SQL Server Management Studio be sufficient? I also get the same error in the log file if I use the Migration tool on the backup DB Attach made when taking the original FMS DB off the older server.