ISQLW.EXE COMMAND LINE OPTIONS V2K The constant login prompt when working with isqlw/SQL Server can be cumbersome. But similar to most utilities, Isqlw.exe supports command line options that may help alleviate some aggravation. isqlw [-?] | [ [-S server_name[\instance_name]] [-d database] [-E] [-U user] [-P password] [{-i input_file} {-o output_file} [-F {U|A|O}]] [-f file_list] [-C configuration_file] [-D scripts_directory] [-T template_directory] ] Use the following shortcut example for a quick, no prompt login attempt that loads an existing file. Note that your file path may vary depending upon your install options. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -S SSLT02\sql2k -U sa -P sa -d pubs -f c:\temp\test.sql This command line placed in a desktop shortcut will log you in to the SQL Server instance SSLT02\sql2k with a login id of "sa." A password of "sa" places you in the pubs database and preloads the designated file C:\temp\test.sql. This replaces quite a few keystrokes and mouse clicks if you are constantly performing repetitive tasks. Note that the "-E" option will log you in with SQL integrated security or trusted connection. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe" -E -S SSLT02\sql2k Remember to secure your machine since storing any user id or password information is a potential security hole. -------------------------------------------