Command-Line Tool osql for SQL-Server 2005

If there is no management tool on the system, from which you want to access a SQL-Server, osql-tool can be used from command-line like SQLPlus in Oracle. Each command must be ended with "go".

The basic connection command is as follows;

c:\>osql -U sa -S srv-sql\SQLSERVER2005

-S switch stands for server name (and instance, if applicable). The whole switches of osql are;

osql [-U login id] [-P password]
[-S server] [-H hostname]
[-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input]
[-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1

Common Regular Expressions

Valid IP-Addresses: ^([\d]{1,3}\.){3}[\d]{1,3}

Valid Times (24 hours: ^([0|1|2]{1}\d):([0|1|2|3|4|5]{1}\d)

Valid Domainnames: ^(((\w+)|(\w+((-)+\w+)+))\.)+(\w+$)

Valid account names: ^([(\w+)|(\w+((\-|\.)+\w+)+)]+(\w+$))

Valid email adresses: ^(([(\w+)|(\w+((\-|\.)+\w+)+)]+(\w+))\@(((\w+)|(\w+((-)+\w+)+))\.)+(\w+$))

Valid int numbers: ^\d+$