Search code examples
sqlsql-server-2008idessms

Is there a way to have SSMS open a certain connections every time I open it up?

Every night the university reboots every machine in my department at midnight and I help my professor with various projects on 11 different sql servers. Since i do not own a personal computer i can't just leave SSMS open over night.

Is it possible to have a setting or some featured enabled so that it remembers to open the connections that i tell it to when i open SSMS?

Thank you.

Solution

  • You can call SSMS from the command line and uses switches to do what you're trying to do.

    There are -S -d -U and -P switches for server, database, username, and password. You should be able to put the call into a .bat file and use that easily enough.

    There is documentation on the Microsoft website.