I think you lose that information when you use a group to login rather than the domain user account.

Far as I can tell, the only way with this configuration would...

Absolutely. 🙂

Yes, the Team Foundation Server MSSCCI Provider mentioned previously allows you to do this.

(Open an existing DB solution from TFS in SSMS).

There's no way to enforce changes to the db...

Domain accounts are linked to logins rather than users.

The domain name should be stored in sys.server_principals (at the start of the name field), you can link to sys.database_principals via the...

Correct, so in a...

You can view the Windows event logs in the SQL Log File viewer - at least, I can!

I wonder if he could change it to 1752?

GSquared (5/18/2012)

---

mtassin (5/18/2012)

---

Gazareth (5/18/2012)

---

dwain.c (5/18/2012)

---

I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy,...

Not sure if it can or not, but if so hope you sort it!

I rarely type the exact name, even a couple of letters will give you a list to...

Something like:

SELECT 'SELECT ' + TableName + ' AS TableName, ' + ColumnName + ' AS ColumnName, CASE WHEN COUNT(DISTINCT ' + ...

Yes, you'll need to do something with...

No problem. Yep - sorry you'll need to run the CTE part of your code too.

My bit replaces the select you already had after the CTE definition.

Ok, I see now. The Users node on my dialog screen is the same - empty.

You're only selecting a location there, not the user, so you shouldn't see a list.

I...

mtassin (5/18/2012)

---

And why would you need...

I don't think you can, directly from that query.

You'd have to generate some dynamic sql based on your results from the query you have.

Yep, you've piqued my curiosity too with this...

Might try it myself if I can find the time 🙂