Thanks as it worked like a charm

PHXHoward (2/24/2016)

---

That is a nice idea. I modified it a bit to make it more useful by excluding offline databases, combining the results, and adding the database name...

Hello,

Cool script! I would just make one change and add the following

PRINT @dbname

EXEC ('EXEC [' + @dbname + '].dbo.sp_change_users_login @Action=Report')

This would show the database name where the orphan...

You sure can. As in most things, there are many ways to get a job done.

Yes good point. However, by the time you install it, this script would have been...

patrickpartin (2/5/2016)

---

Perhaps you did it intentionally, and if so, totally disregard the rest of this message, but SQL Server 2016 is looking to be Version 13, right?

If so, line 220...

terry.home (2/3/2016)

---

Really like the script and wanted to thank you for this.

Not sure about turning database mail functionality off, appreciate that if anybody hacks system they can send email to...

SQL Guy 1 (2/2/2016)

---

There are couple of bugs in this script, but otherwise it's very thorough, very comprehensive security settings as well as recommendations report.

If not bugs, would put...

dainolib (2/2/2016)

---

Section "Remote Admin Connections" is not correct.

1. This option is not related to restriction on local administrator but on local connections

2. The recommended value is 0 (only local connections...

Jefferson Elias (2/2/2016)

---

Hi, thanks for sharing.

This seems interesting but it doesn't work against a 2008 R2 instance.

Reason:

Msg 207, Level 16, State 1, Line 245

Invalid column name 'physical_memory_kb'.

You could use an...

shadighaith (2/3/2016)

---

Good day, the script does not work with SQL 2008 R2. Multiple errors shown that require to be resolved one by one. Do you have an older version for...

Hello Mike,

Sorry that the script didn't work in SQL Express. We don't use that edition of SQL so I haven't tested it. Assuming that you could make changes to the...

quackhandle1975 (11/26/2015)

---

Great article, a question I've just thought of (and it might go in your "Post Work" section) is a traceflag check. So if you have a number of traceflags...

Thanks for the comments 🙂

Glad to see that this article is creating conversation as there isn't a lot on this topic in the wild. My goal here was to provide...

Kris Gruttemeyer (10/16/2015)

---

One thing which is not mentioned: You can only restore 2008+ in SQL 2014, if you have a SQL2005 (or SQL2000 :w00t: database), you'll have to restore it...