Thanks you very much Grant and John. So, when there is no CU released like in case of SQL Server 2008r2 RTM, in general scenario, do we need apply SP3+MS15-058(6220)+TLS1.2(6542)+Security...

Can anybody reply?

Thanks jack

Thanks Perry

But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if the...

Thanks Gail.

Avg. page life expectency is 41299. No max memory limit is set. Total physical memory in the server is 32GB. SQL server is consuming 29.6GB(seen from task manager).

Gail,

Do you recommend...

Thanks Stuart.

Any way to find out the only fixes as part of SP4 as compared to SP3

Hi,

The eventviewer is showing "Windows cannot determine the user or computer name (The RPC Server is unavailable). Group Policy Processing aborted"

The job takes 1 hr to complete which usually takes...

Hi,

One DTS job is ruuning which is causing the blocking.

Lock type- sch-s

DBCC Inputbuffer gives the select query

Have you checked the setup bootstrap logs?

This is what I was looking for. Thanks a lot, Anthony.

Yes, in table variable result set can be stored.

No, a single variable can store single value. A result set with more than one rows and columns returned from a table can not be put into a single variable.

Hi Anthony

This works fine. Thanks a lot.

Hi Anthony,

I have tried with single user mode but it does not work.

C:\Windows\system32>NET START MSSQLSERVER /m

The SQL Server (MSSQLSERVER) service is starting.

The SQL Server (MSSQLSERVER) service could not be started.

A...