I am using SQLServer v2005. When I open a database object in Tabbed or MDI view there is a long title for top of the tab/window. It is prefixed by my SQLServer's name, which is Dell340_C9WBL1S. So every tab/window has that on it and makes reading the title painful.
When I fire up the SQLServer Maagment Studio, it does not ask me for either 'local' (like v7 did), just the actual SQL server name(s) on my network
Anyway to get rid of that server id as a prefixe to a tab or MDI window??
You'll have get used to it. The structure of that title in the tab is to your beneffit as you want to make sure that you are on the right server and on the right database. Believe me, you need that. It
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…