How to connect SQLserver from cmd

Syntax:
C:net use \\server_name /u:corporateNetwrkname\ur_sqldba_id
C:query session /server:server_name

C:\xx_dba>net use \\srvr_name /u:c.network\xx_dba

The command completed successfully.

C:\xx_dba>query session /server:srvr_name
SESSIONNAME USERNAME ID STATE TYPE DEVICE
console 0 Conn wdcon
rdp-tcp 65536 Listen rdpwd
rdp-tcp#26 xx_dba 2 Active rdpwd

(or) can use tsadmin

Connect isql from command prompt in local machine:

C:\Documents and Settings\xx_dba>osql -E -s SERVER_NAME
1> select spid,cmd,blocked from sysprocesses where blocked>0
2> go
spid Gcmd Gblocked
------G----------------G-------

(0 rows affected)

connect isql from remote machine or from ur local box(sql should install/path)

H:\>osql -U -P -S SERVER_NAME