We had this problem when trying to install SQL 2K on a box where we had already remapped the drives... we didn't have time to figure it out (which is...

Auditing can be turned on for both SQL Server 7 and 2000 for NT users. Results will show up in the Security Log on the system. However, if...

Try BabelFish from AltaVista. It can do translations of web pages including SQL Server Central's. Given, it's a rough translation, but it does do them. And it's...

Then there's the saying that goes something like: When you finally make something idiot-proof, they just go and build a better idiot. Unfortunately, these words seem very, very true.

K....

Are the user accounts SQL Server based on Windows based? If they are Windows based, there are some things that can be done to find out the last time...

This doesn't sound like a very efficient process, but if they are editing row by row and they simply enter end in a field on a new row, a trigger...

Or your wife asks you to figure out which kids want chocolate ice cream at the birthday party and you instantly start coding the query in SQL.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

You're suffering from that problem, too? I've got three different systems up at my cube (1 desktop and 2 laptops) and am active on all of them at the...

That makes sense since the system tables work off smallint for uid in order to join back to sysusers. But always better safe than sorry.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

quote:

---

Some times, I think part of the problem is (at least for our SQL dept) is that we're not given enough time...

quote:

---

But deny would be taking the check box out, revoke is an X ad grant is a check

---

K. Brian Kelley
@kbriankelley