A good friend of mine, Thomas (a full-time DBA), shared some tasks he created for Royal TS:
Task Name: SQL Server Management Studio
Command: SSMS
Arguments: -S $Host$ -E
Working Directory:
Task Name: SQLCMD DAC
Command: SQLCMD
Arguments: -S $Host$ -E -A
Working Directory:
Task Name: SQLCMD
Command: SQLCMD
Arguments: -S $Host$ -E
Working Directory:
Just copy/paste the task details and have fun...
(Tested on Windows 2008/SQL 2008)
cheers
Stefan