What's the cost? What do you see as a downside?

A little lawyer...

Yes and no. As a DBA, I've tried to be proactive and look for ways to prevent issues....

http://www.sqlservercentral.com/search/?q=script+out+permissions&t=s&sort=relevance

Thank you. I'll be back - http://www.youtube.com/watch?v=WgPePk3kGZk

sp_addserver should populate the fields correctly for applications to work with the instance. I'm not surprised it isn't documented, but you can certainly submit a doc bug to have that...

Sounds good. It's yours.

Both are fine. Include some scenarios/examples, so that someone not sure how to do this understands what they are doing here.

Take it. I prefer that you get one done before doing another, but since this and the server one are very similar, do them both.

You can use the same style/template/language...

It's yours.

You may want to look at fn_my_permissions: http://msdn.microsoft.com/en-us/library/foo30f97f00-03d8-443a-9de9-9ec420b7699b.aspx

You can also check for roles with IS_Member() - http://msdn.microsoft.com/en-us/library/foo77cb68a0-19b7-4fe1-ab17-e5587699631b.aspx

There's also an analogous server role function.

If you just want a larger view of...

Does Andy's idea work?

It's not quite clear what you mean. Do you want to show the email if the device is not null or show the email only and NULL...

There isn't a good way to do this. SQL doesn't really track access of resources by user and aggregate it. It can track some things by resource accessed, but not...

As a hint, there are AVG aggregates you can use in T-SQL, as well as the datepart function which can support quarters, which can be used in a GROUP BY...

Which datasource field?

Do you mean you are uninstalling the old server on a Windows host and then installing SQL 2K8 on the same host? It's not clear what you are...

Bouke Bruinsma (4/21/2014)

---

We advise the lesser of 4 or the nr of physical cores for the nr of tempdb datafiles. Almost all discussions on any tempdb issue has this advice....