Waseem Jaleel (7/20/2008)

---

I mean, how do I retrieve info about the permission for each user using this alternate table that you (Gail Shaw) has suggested..only if I...

Do all the users have the same permissions? If so, create a DB role, grant the permissions to that and assign each user to the role.If not, you'll have to...

I'm not sure I understand your question. Processes within SQL, processes visible to the OS, something else entirely?

You can read the system tables if you connect with the DAC. Updating them is still not...

You cannot modify the system tables in SQL 2005. Even in SQL 2000 where it was possible it was strongly recommended againast. It's a very quick way of messing up...

Do...

I don't think you can, unless you have some profiler or a server-side trace running.

Is there anything in the windows event log (under system) that gives any clue why the system was shut down?

No, because it's not a...

Lots of dynamic SQL. 😉 If you get stuck, we can help.

One other thing I noticed looking over your trigger code. Be careful of constructs like this in trigger code

SELECT...

Don't feel too easy with it. It's not something that should be...

Identity not for replication is not the same as Identity insert

sbalaven: identity insert is set per session and may only be enabled on one table at a time. So if...

Whatever query you called ran longer than 30 sec (or whatever the timeout is set to)

To fix, you are going to have to identify what query is been called and...

hengert (7/18/2008)

---

Hi,

I am in no way a db expert, but I am required to create a generic trigger to track changes to a few tables. We don't want to write...

Query stats has no user-related info in. If you query that for the most recent statement, you'll get the most recent statement by any user on the server, not by...