• The state of this 18456 error is important. However, you always receive this "Logon Error: 18456" error message that has a state set to 1 in the client application.

To...

Better try doing it in the command prompt.

NET STOP MSSQLSERVER

and then again start it by enabling the trace.

Use this

NET START MSSQLSERVER t1400.

The above mentioned commands are for default instance.

Thanks,

Leks

Better try doing it in the command prompt.

NET STOP MSSQLSERVER

and then again start it by enabling the trace.

Use this

NET START MSSQLSERVER t1400.

The above mentioned commands are for default instance.

Thanks,

Leks

Sreedevi,

The two possible action that you could do is

1. Update the system catalog by using alter database command by dropping that filegroup that is offline. So that the system will...

If you have installed SQL server on the default directory look for the dts import/export wizard at C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder.

As said by previous answerers , use the dts...