Any users can use the MAXDOP query hint. If the value specified in the MAXDOP hint can be more than the value in sp_configure.

Please refer MSDN documentation here.

Did you try starting it from Services (services.msc)?

and also give more details about the version/edition of SQL Server 2008

Does the wbemess.log provide any insights?

Also check if this post on MS Site helps.

What is the Error that you get?

Moreover, it is not recommended to have data files of a live database on UNC paths!

This is official documentation of AWE

Check if some settings on the server is blocking access on Port 25. Also check with the Messaging Team, if they had changed something.

Regarding TELNET not showing the desired result...

A Database Administrator without Administrative privileges will not be able to perform many of the tasks

Looks good to me.

If there is no trust between the domains, you will not be able to use Windows Authentication for registering the server. Use SQL Server Authentication to register those servers in...

You can also use Process Explorer to track which SPID is consuming CPU. I have explained it here[/url]

Check if this helps

From the error message, it is clear that some DBCC command was being executed when the error occured. In SQL Server 2005 and above, during DBCC command execution Database Snapshots...

Did you try starting SQL Service in Single User mode from the command prompt?

Usually it gives the right picture there.

Try enabling the WMI logging and see if it helps. Refer this and this.

Check if sqlsrv32.dll is missing. You may find this post[/url] useful.