Hello all,

You can avoid xp_cmdshell to get max and min memory as follows:

DECLARE

@MaxMemory NVARCHAR(10) -- Max memory

, @MinMemory NVARCHAR(10) -- Min memory

SET @MaxMemory = CONVERT(NVARCHAR(10), (SELECT VALUE FROM SYS.CONFIGURATIONS where...

This worked for me:

Resolution:

First check if the following is in place.

a. Run REGEDIT

b. Expand - "HKEY_CLASSES_ROOT"

c. Expand - "TypeLib"

d. Expand - (91A74EB0-EFA0-482B-B43C-35CFC74B275F)

e. Expand - a.0

f....

Hello,

Great work on your part!! I haven't added any more to the script,yet and don't know of how to add additional information. Really haven't done more with the script.

Thanks,

Rudy

Hello John,

Thanks for the information and testing the script. As you can see, it can be hard to test against older SQL Server installations.

Will work on making the script check...

Lee,

Oh I see and yes you are right. I will have to make that change. In the mean time if you or anyone else sees any other issues please let...

Lee Linares (2/11/2015)

---

Rudy,

Try this statement on a SQL Server with NO members of the serveradmin role:

SELECT COUNT(*) FROM sys.server_principals WHERE (type ='R') and (name='serveradmin')

What I get is 1

If you run...

Hello Lee

In this statement

IF (SELECT COUNT(*) FROM sys.server_principals) = 0

If 0 then there is no one in the SysAdmins. Now there always should be but I don't assume anything here...

Hello,

If you change the name you also need to do the following to update sys.jobs. If you don't you won't be able to modify the jobs.

-- Update the server name...

Glad to see that my article has created much discussion. I would like to point out that my checklist is "My" checklist and is no way complete. I appreciate all...

mauriciorpp (12/30/2014)

---

I decided to close my 2014 blogging year by linking your article, Rudy.

Please take a look at it: https://thelonelydba.wordpress.com/2014/12/30/last-post-of-the-year-sql-server-2014-checklist-for-performance/

Also instead of discussing any general tip, I would...

Hello everyone,

I see this article has received much discussion. I believe I should have mentioned that this is only a guideline and that, as usual.. it depends. This checklist has...

Here is how I update the script

USE ReportServer

GO

DECLARE @UserName VARCHAR(200) = '%%' -- If you want to list all users

SET @UserName = '%BUILTIN\Administrators%' -- If you want to...

Excellent script!

I have made a change to the script so that I don't have to be in the ReportServer database to execute.

INNER JOIN reportserver.dbo.Policies Pol ON Cat.PolicyID = Pol.PolicyID

INNER...

Yes you're right. I didn't write the code for that section yet.

Thanks

[/quote]

Because it is easy to automate using PowerShell. Kendal has put in a lot of efforts and the script that he does a lot of better checks than u have....