Raised request to Microsoft after their conclusion this is bug and they are releasing CU 1 to resolve the issue, that is release pending on July, once the CU will...

could you please explain what settings you are talking about

Nope all protocols are enabled

TITLE: Microsoft SQL Server Management Studio

------------------------------

Unable to cast COM object of type 'System.__ComObject' to interface type 'System.Management.IWbemServices'. This operation failed because the QueryInterface call on the COM component for the...

firewalls are off, ports are specified and Services failing over and failing back perfectly, not able to find where the issue exactly.

Yes I am able to connect remotely and no aliases, I checked all low level

Yes, browser service running

We have TCP\ip and ( changed the default port), named pipes are enabled

Thanks

Hi Thanks for the reply

Below are the SQLagent.out output

2016-06-02 03:03:24 - ? [100] Microsoft SQLServerAgent version 13.0.1601.5 (X64 unicode retail build) : Process ID 9008

2016-06-02 03:03:24 - ? [495]...

User databases running on the server..

Not exactly what you mentioned I run the profiler when the developer start the loading, I havent find the exact reason but i found that checkpoint issue but I am...

I tried select loginproperty('loginame','passwordlastsettime')As 'passwordlasttime'

Its showing the last password change.

Can please explain clearely because in my server having around 225 databases, so many logins at the same time I dont want disruption to the application users , what i...

Actually I am migrating the system from Sql server 2000 to Sql server 2008, I am restore the database from Sql server 2000, on that testing server when 2 to...

How can I repair the code, and how to know which code is consuming the high CPU utilization Can you please give me solution.

Thankiing you in advance