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...

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/[/url]

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?...

Does it work sometimes just not all of the time? Have you check response time between source and destination to see if there are any network connectivity issues?

It's not...