Can't create table - SQL 2008 R2
-
Hi, I have SQL 2008 express R2 installed. I have visual studio express 2010 and 2012 also installed. Windows 8. I'm trying to create a new table but I get this strange message:
Quote:
This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
I googled the net but didn't find a solution to the problem. (replacing the dsref80.dll of 2012 with the one from 2010) Did anybody encountered this issue and solved it?
I have never used database tools in Visual Studio and I see no reason to. I prefer to just write the SQL statement or use the designer in SSMS.
-
I have never used database tools in Visual Studio and I see no reason to. I prefer to just write the SQL statement or use the designer in SSMS.
I'm using the 'SQL Server Management Studio' (=SSMS). he error that I get appears while I'm trying to create a table there.
-
I'm using the 'SQL Server Management Studio' (=SSMS). he error that I get appears while I'm trying to create a table there.
Ah, then I don't know. Just write some SQL. "Would you like some help with that?" -- Clippy
-
Ah, then I don't know. Just write some SQL. "Would you like some help with that?" -- Clippy
Thanks, but I'm looking to solve this problem so I could have access to the designer.
-
Thanks, but I'm looking to solve this problem so I could have access to the designer.
Right. I've been using the Express versions too and had no trouble with the designers. SQL Server 2012 Express has been causing other trouble though. Did you try a repair install?
-
Right. I've been using the Express versions too and had no trouble with the designers. SQL Server 2012 Express has been causing other trouble though. Did you try a repair install?
OK. So I removed the current installation but right now I can't install the management studio because of compatibility issues. (Windows 8) Besides going back to Windows 7, Any advice??
-
OK. So I removed the current installation but right now I can't install the management studio because of compatibility issues. (Windows 8) Besides going back to Windows 7, Any advice??
Nope, I'm on Win 7. You could possibly use a virtual Win 7 system. Hopefully someone else will have something more useful.
-
Nope, I'm on Win 7. You could possibly use a virtual Win 7 system. Hopefully someone else will have something more useful.
So I managed installing Management studio but now I'm trying to create a database and I get: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) It looks like I need to update something but I don't know what...
-
So I managed installing Management studio but now I'm trying to create a database and I get: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) It looks like I need to update something but I don't know what...
That could be an access problem. I forgot exactly when I've seen that.
-
That could be an access problem. I forgot exactly when I've seen that.
Solved it! I had to install this: http://www.microsoft.com/en-us/download/confirmation.aspx?id=26729[^] Finally!!
-
Solved it! I had to install this: http://www.microsoft.com/en-us/download/confirmation.aspx?id=26729[^] Finally!!
Excellent! I may need that too. :thumbsup: