Sergiy, it may not be that at all. If Ben's organization only has a single domain or if the users and servers are in the same domain, this would produce...

It sounds like you've got a solution that works for you. On a side note (in case someone else comes across this thread) in a more complex situation, nslookup and...

On SQL Server 2000, syslogins is the system table you're looking for. And you are correct, sp_grantlogin allows a Window security principal (user, group, or computer account) to connect to...

When you toggle auditing on, the audit events get written to the Application event log for the server. It's a simple matter to use a tool like EventCombMT to...

There is a system stored procedure for this: sp_helprotect. use it with the @username parameter. For instance, to see everything the public role can do:

EXEC sp_helprotect @username = 'public'

This will...

My two year-old daughter has medical issues, some of which we're still seeing specialists for to see if we can try to diagnose why certain problems still exist. It has...

Yeah, it's kinda nice being referred to as the mouse that tried to take over the world.

Yup, that's about right. Hence the reason most people recommend you get in with a not-for-profit or something of that sort during the college or job transition years in order...

If you are looking at scripting the logins, such that the SIDs are maintained in the event of a database restore, see the following KB article:

How to transfer logins...

Sometimes when a process creates a file, it chooses to break inheritance and assign different permissions than what the folder has. SQL Server 2005 does this whenever you create a...

Check the SIDs for the logins on both your dev and production systems. If they aren't the same, export the login from production and delete and create the login on...

You mean DML triggers. DDL triggers monitor for changes to the schema and objects themselves.

As to the original question, there are two options:

• Triggers...

The problem with an application role is that when it is set in SQL Server 2000 using sp_setapprole (SQL Server 2005 has sp_unsetapprole to revert back), you lose all identity...

This forum thread also provides some guidance:

SOX and SQL server 2000

However, SOX compliance isn't a "cookie cutter" type of thing. So you'll probably finding yourself tweaking...

Well, a mix of both. Scheduled job polls a table. User has the ability to execute a stored procedure which makes a change in the table. Scheduled job notes the...