Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.
SQL SERVER – Find Name of The SQL Server Instance
SELECT @@SERVERNAME returns the name of the SQL Server instance. We used it in stored procedures that ran different logic on each server during a migration.
SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio
Where is the Query Editor in SQL Server 2005? It is part of SQL Server Management Studio, and I list the enhancements it brings over older tools.
SQLAuthority News – Active Directory Integration Sample Script
A Microsoft sample script that reads computer names from your SQL Server database and adds them to an Active Directory security group for agent assignment.
SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005
A Microsoft white paper on connecting Visio 2007 to SQL Server 2005 data, including an Analysis Services cube shown as a Visio PivotDiagram.
SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt
Start, stop or restart SQL Server from the command prompt with net start mssqlserver and net stop mssqlserver. A batch file can run both together.
SQL SERVER – 2005 – Introduction and Explanation to sqlcmd
An introduction to sqlcmd, the SQL Server 2005 command prompt utility that runs ad hoc T-SQL statements and scripts, and how it improves on isql and osql.