Wednesday, May 1, 2013

SQL Server and Visual Studio 2012, 32 bit versus 64 bit -- further links

mentioned in this
http://visualstudiomagazine.com/blogs/data-driver/2013/03/bids-templates-added-to-visual-studio-2012.aspx

relevant text is:
For those having issues it seems you need to choose the "perform new install" instead of "add features to existing. "
This seems to get around the 32/64 bit issue. Your only option is The Sql server Data Tools Business Intelligence so its not like it is doing a new install of sql

link is:
http://blogs.msdn.com/b/analysisservices/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx

Its in the comments... Follow-up from black helicopters themselves seems a bit grudging to be honest

SQL Server 2012 -- sp_dboption stored procedure no longer exists

This is a problem as the 2008 style scripts for Northwind and Pubs databases include sp_dboption.
Its not the end of the world, you can  comment them out and use ALTER DATBASE instead.

--exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
ALTER DATABASE Northwind SET RECOVERY SIMPLE 

Seems like a comprehensive reference here:

http://beyondrelational.com/modules/2/blogs/28/Posts/15429/replacement-for-system-stored-procedure-spdboption-in-sql-server-2012-denali.aspx