The solution to this problem is that you have to use another DNS alias.

Kerberos doesn't resolve DNS, so for authentication you can use different DNS names for the same machine.

In...

Thanks SSC-Enthusiastic,

I'll do that

Alren

Alren (10/13/2008)

---

This would be great if the deny was restricted to the windows group but in my understanding this is what happens:

user A is part of windows groups G1 and...

This would be great if the deny was restricted to the windows group but in my understanding this is what happens:

user A is part of windows groups G1 and G2.

G1...

What do you call disable the login?

If it is "ALTER LOGIN ... DISABLE", I tried it but it doesn't seem to work for windows groups...:(

I have found a "DENY CONNECT...

I have users that access the database via windows groups.

I want to kill their sessions and avoid them to be able to log in again during the run of some...

Thank you for your response.

But sp_spaceused only gives the answer to "how much tempdb is currently in use". 🙁

Your link to the space monitoring view is interesting (I bookmarked it)

but...