Is there a 64bit version of SQL Server 2008 Management Studio?
I downloaded the 32bit/64bit version of SQL 2008 Developer R2 and it still installed into the Program Files (x86)\ file location.
Is it necessary to install SQL Server 2005 Express with Visual Studio 2005/2008 if I already have SQL Server 2005 installed? I'm wondering if SQL Server Express adds any integration that SQL Server 2005 doesn't.
So I want to copy just the data from a Prod database (SQL 2005) down to my local machine (SQL 2005 & SQL 2008 Management Studio installed).
The problem is I'm running into foreign key constraints that are causing the task/scripts to fail. I can get by these errors if I import certain tables first, but is there an easier way to do this all at…