Open SSMS -> GO TO Tools -> Option and Check the below highlighted check box and restart the Management Studio. It will hide all the system objects in Object Explorer.
How to Hide System Objects in Object Explorer?
Leave a reply
Category Archives: Notes
Step By Step Log-Shipping Configuration for SQL Server
Setting up Log Shipping for SQL Server is not that difficult, but having a step by step process is helpful if this is the first time you have setup Log Shipping. In this tip we walk through the steps to setup Log Shipping.
To read the step by step Log-Shipping steps CLICK ME to read it.
Or Open http://mssqltips.com/tip.asp?tip=2301 link
Surface Area Configuration in SQL Server 2008
I got an email from one of my reader and He is asking me that where is SAC in SQL Server 2008. Microsoft has removed the Surface Area Configuration tool that was shipped in SQL Server 2005. The Services and Connections which were previously managed using Surface Area Configuration tool is now managed using the SQL Server Configuration Manager.
To manage the database engine features you have to use Policy Based Management. For that you have to use Surface Area Configuration facet.
You can follow below steps to configure the Database Engine features.
- Right Click on Server Name and Select Facets from pop up windows
- Select “Surface Area Configuration” from facets windows and do the appropriate desired settings
SSMS Startup Options
You can configure SSMS to startup with the below options. Default one is Open Object Explorer.
Go Tools –> Options –>Environment(page)–>General.
Options are self explanatory.
SQLWB.exe (SQL2k5) and SSMS.exe(SQL2K8)
SQLWB (sqlwb.exe) /SSMS(SSMS.exe) is the executable file that launches SQL Server Management Studio. I am usually using it to launch the SQL Server management studio instead of navigating through Start -> All Programs -> SQL Server 2005 -> SQL Server Management Studio.
Above command will launch the SQL Server 2005 Management Studio. You can launch the SQL2k8 management studio using SSMS.exe
You can also pass below list of argument with it, I am executing below command to see the list of parameters.
c:\sqlwb.exe -?
aiDeeva.com 