Printable View
I have a sql server database version 2005. i have a problem when I want to modify the tables with error:
This backend version is not supported to design database diagrams or tables.
I use Management Studio Express Editon.
What is the solution to this?
thank you
It sounds like maybe Management Studio Express will not allow you to design on a non-Express instance. I can't really test that theory but that's what it sounds like from the information you've provided. Can that same instance of MSE perform the same task for a database attached to a SQL Server Express instance?
I will try to install again. possible ways this could be a solution
now i not use sql server management express. but i have same error.
but when i search i found this articel :
http://support.microsoft.com/kb/822535
What version of SME are you trying to use?
-tg
I have been using MSE for version 9.00.1399.00
this for details info :
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
I enclose the following example of a typed view can not connect to the database on the server
What is that (Restricted User) business about?
I do not know, but there is no problem when I use sql server on another pc. only happens in my own pc