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

You could still use UPPER or LOWER (or their equivalent in SSIS Expression) to compare.

What you'd need to do is alter the mapping in the package by looking to see...

You are talking about auditing in some way. There are a number of options, but all will affect performance. You can use

- triggers

- trace

- CDC/change tracking

- custom code in...

Moved to SQL 2000

govindarajan69 (4/21/2014)

---

Hi All,

Our company procured MS SQL Server 2008 R2 with 5 CAL. I installed MS SQL Server 2008 R2. How to ensure that only 5 CALs are...

I don't think this is the case. Public should have very few rights, and I'd be surprised at this. Public has few rights, and I wouldn't expect this to be...

I tend to agree with jasona.work here. You may or may not mask or relieve some tempdb issues with a second instance. There isn't a hard and set rule...

CDC is an enterprise only feature as well. That can be an issue.

The CDC stuff can get complex and be cumbersome to deal with, especially with DR environments. Make sure...

You can use the UPPER() or LOWER() functions to force case for a comparison.

A few things here. You say log drive, but I think you mean log files. Is that correct? The drive is the letter/path designation your Windows host sees. Like c:,...