Posts

Showing posts from 2008

Sql Assistant

Removing Most Recently Used (MRU) Server Names from the Connection Dialog The Server name drop-down list box in the Connection dialog stores the 10 most recently used (MRU) server names (see Figure 4-25 ). The Connection dialog stores the server name after it has successfully connected to the server. Although this is a convenient feature, there are situations in which you may want to remove the dormant servers from this list or remove all the entries for security reasons. You may also want to copy the list to another workstation or share it with another user. Figure 4-25 Making a DAC connection from Management Studio. The server name MRU list is distinct for each user on a computer. The list is stored in a file named mru.dat under the Application Data directory for each user: C:\Documents and Settings\ \Application DataMicrosoft\Microsoft SQL Server\90\Tools\Shell\mru.dat Importing Registered Servers from Enterprise Manager SQL Server 2005 provides the functionality to keep your SQL