Ihave MSSQL 2000 and MSSQL 2005 Express on the same server. I need to connect to the SQL 2005 instance via command line to run a script against the DB. The instance name for the 2005 DB is Teller. Here is the command that I tried but it ran it
against the 2000 instance rather then the 2005 instance.
C:\Documents and Settings\stevemize>sqlcmd -s shelby\teller -i "c:\Documents and Settings\stevemize\SetAutoCloseOff.sql"
Any assistance would be greatly appreciated.
Thanks,
Steve
...
Go to the complete details ...