Thanks for sharing. That's a relatively quick and dirty way to get the error log entries from multiple systems. I don't yet have PS3 installed, so I modified...

liam.gavin - good info to be aware of. I opted to use the stored procedures after tracing what the GUI does. In the situation I'm in, we have...

CDA (8/18/2014)

---

What are the current limitations / gotchas around CMS?

Back in 2008, there was some guidance from Microsoft that CMS shouldn't group > 200 servers together. Does anyone know...

Hi virgo,

You can change the code over to the following that uses suser_sname(sid) instead of [name]. I'll update the posted script accordingly. Thanks for finding that issue.

+ '...

Ross.M (2/18/2014)

---

Thanks TheJrDBA, that's a very useful solution.

I tried something else which seems to work on my dev server to actually remove the jobs from any reports that...

Anyone think that a good use case for a Hekaton table would be for the ASPSession database tables? Obviously there are alternatives to caching session data, but for those...

I came across this link describing a problem with two rules:

http://social.technet.microsoft.com/Forums/systemcenter/en-US/ffeefe0d-0ef7-49a3-862e-9be27989dc5d/scom2012-alert-sql-2008-db-average-wait-time-recompilationis-too-high?forum=operationsmanagergeneral

specifically:

YES there have been bugs reported with this MP.

You should disable the following rules:

MSSQL 2012: Collect DB Engine CPU...

In reviewing this for a while, I think the only way to go is to specify creating the user without a login, rather than setting a default password. I...

aruopna (1/24/2014)

---

Do you mean to say you need something like this? Try executing this piece (in text mode) on your database, it will generate create user scripts only for those...

benjamin.reyes (1/17/2014)

---

Here you go.

http://www.sqlskills.com/blogs/paul/missing-index-dmvs-bug-that-could-cost-your-sanity/%5B/url%5D

Just as with the performance tuning wizard you should take the recommended indexes as a suggestion, not as a rule. You still need to verify that...

I agree with Perry. In our environment, we have used a port up over 8000 away from any system ports, but checking for the available ports would be your...

ALZDBA (3/21/2012)

---

To help out a bit more I've added a Powershell (2.0) script that I created at the time I installed my n-th instance.

We provide an MSDTC-resource with each individual...

logicinside22 (3/28/2013)

---

Hi

I am looking for same script to generate script for User DB roles . Can you share if you have it now?

Or if anyone have it can...

Glad you got some good use out of it!

Cheers.

Sorry for leaving you hanging. I haven't had a chance to get back on to SSC in quite a while. Did you ever get a resolution to this?...