?
Solved

Set default table view to Custom for a Database Diagram in SQL Server 2008 Management Studio

Posted on 2009-05-16
5
Medium Priority
?
711 Views
Last Modified: 2012-05-07
Just as the title says, I'd like to set it so that the default setting when I add/create a table within the database diagram in SQL Server 2008 Mgmt Studio uses the custom view, as I've modified it for my needs.
0
Comment
Question by:yetti78
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24404289
It can't be done.
0
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 1000 total points
ID: 24404383
Yes it can, in the Diagram Options section of the Tools>Options menu.
SSMS2008-Tool-Options.png
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24404475
Oops.  My mistake.  Learn something new every day,
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24404571
:-)
That's a good day when you learn something new!
0
 

Author Comment

by:yetti78
ID: 24405213
Well done!!!!!!!! :)
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question