• thanks Bro it is working great.....

    I am having a small issue I cannot login in to my instance. I am getting the following error in my errorlog.

    Error: 26023, Severity: 16, State: 1.

    2013-08-01 14:38:27.65 Server Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use.

    2013-08-01 14:38:27.65 Server Error: 17182, Severity: 16, State: 1.

    2013-08-01 14:38:27.65 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Only one usage of each socket address (protocol/network address/port) is normally permitted.

    2013-08-01 14:38:27.65 Server Error: 17182, Severity: 16, State: 1.

    2013-08-01 14:38:27.65 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Only one usage of each socket address (protocol/network address/port) is normally permitted.

    2013-08-01 14:38:27.65 Server Error: 17826, Severity: 18, State: 3.

    2013-08-01 14:38:27.65 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

    2013-08-01 14:38:27.65 Server Error: 17120, Severity: 16, State: 1.

    2013-08-01 14:38:27.65 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    2013-08-01 14:38:27.76 spid13s A new instance of the full-text filter daemon host process has been successfully started.