Archive for the 'SQLServer' Category

 

Mar 31, 2009 in Database, SQLServer

  • — Run ‘SQL Server Configuration Manager’
    — click on
    ‘… Network Configuration’
    ‘Protocols’
    TCP/IP,
    Properties
    ‘IP Addresses’ tab.
  • — SQL service info:

    net start “SQL Server (SQLEXPRESS)”

    net start “SQL Server Browser”

  • — sqlcmd info:

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    sqlcmd -S tcp:localhost,2248 -l 60

    sqlcmd -S tcp:localhost,2248 -i script.sql