Author: techfox9

Tuesday, March 31st, 2009 @ 12:56 pm

  • — 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

Database, SQLServer


 


Comments are closed.