I have SQL server 2005 client with SP3 (Microsoft SQL Server Management Studio 9.00.4035.00).
Back end database is SQL server 2008 SP2
I can create/alter a table via sql script.
In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error - "Unspecified Error. MS Visual Database Tools."
I was able to use SSMS 2008 client to create tables with out any issues. Looks like a compatibility issue between SSMS 2005 and SS 2008 server. Has anyone seen this issue and if yes is there a fix for
View Complete Post