Currently our dept is using SQL Server 2005. The company doesn't want to spend money on another copy of Visual Studio 2005 for debugging. I notice SSMS for SQL Server 2008 has debug tools built in (something lacking in SSMS for SQl Server 2005).
The company has licenses for both SQL Server 2005 Standard & SQL Server 2008 Standard.
Our dept is still using 2005.
Are there any technical issues with installing SSMS 2008 on development workstation to gain access to debug tools built into SSMS 2008 (missing in SSMS 2005)? The workstation will be accessing SQL Server 2005 exclusively.
Are there any licensing issues related to deploying SSMS 2008 to workstations that will connect to SQL Server 2005? It is my understanding that with SQL Server 2005/2008 Standard you can deploy "workstation tools" to an unlimited number of machines.