Re: SQL Server Management Studio Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance





"Erland Sommarskog" wrote:

scuba19 (scuba19@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have installed on a user the SQL Server Management Studio Express
console and they have full control , at least I think so to the a
specific database. The problem is that the user needs to be able to
click on the relationship diagram button in the console but it is
greyed out.

Not really sure what button that is (I hardly use the toolbar) or
whether it may be a permission issue.

However, since the table designer is a piece of crap, I would rather
see it as a feature that it's not available.

Use the various sp_helpxxx insted to find information, and ALTER TABLE
commands to make changes.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Erland,

The user would like to use the button can you advise what can cause
the problem ?
.



Relevant Pages

  • Re: SQL Server Management Studio Express
    ... The problem is that the user needs to be able to ... click on the relationship diagram button in the console but it is ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.tools)
  • Re: Autostatistic ON/OFF on separate tables?
    ... "Erland Sommarskog" wrote in message ... This means that autostats do not set in very often on these tables. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • (BUG) Problem with the SPFileCollection.Add (similar to spin issue)
    ... I have a windows service that monitors a SQL table ... data in the SQL table which can produce 2000-3000 or more ... So I decided to make a simple Console application to batch ... Sharepoint SPFileCollection.Add method. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: SQL 2000 SP4 fails to install
    ... core CPU x64 processors ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.setup)
  • Re: connect from desktop to sqlserverce
    ... It is being used to support my SQL CE Console application and allows for a .NET application to access a remote SQL CE 2.0 database via ActiveSync or TCP/IP. ... recibido este mensaje por error, le rogamos que nos lo comunique ...
    (microsoft.public.sqlserver.ce)