Nuts (11/7/2007)

---

Hi

Ill explain the situation again

Its really simple for ex a patient 'A' was in rest home from '1/1/2004' to 12/2/2004'

and then the same patient 'A' was then...

Ken LaRoy (11/7/2007)

---

I'm not sure what that means. However, I have looked at the system event logs and do see Failure Audit entries in the Application log for the people...

Nonrepudiation = you can't deny you did it. As soon as a password is cracked, at least 2 people know it. Now you can.

NGS Software has some great tools for this:

NGSSQLCrack

and

NGSSQuirreL for SQL Server

However, as soon as you crack a password, if it belongs to a user, your organization may no longer be...

They want the trace of all statements going through, or are they looking for something more?

As the previous poster asked, "What do you mean by levels?"

SQL Server 2005 has more granular security,...

If you still have the time and the resources, getting certified in SQL Server is not a bad idea. You never know what tomorrow will bring. Case in point, a...

If you read through my blog post you'll see that when you add a second condition to the WHERE clause...

Have you audited your SQL Profiler or a server side trace looking for Audit Failures?

The recommended best practice for SQL Server 2005 in this regard is to grant the permission at the schema level. If all of your objects are in one schema, you...

To piggy-back on what Noel has said..

The SQL Server AD Helper Service allows SQL Server to register objects in Active Directory as needed. When is it needed? When SQL Server...

vbourdages (11/6/2007)

---

when I use my database user, I am getting this error:

Execute Master.dbo.SYS_show_All_Processes

Server: Msg 229, Level 14, State 5, Procedure SYS_show_All_Processes, Line 1

EXECUTE permission denied on object 'SYS_show_All_Processes', database 'master',...

You will most likely have a SID issue. Unless your directory service admins ensured the SIDs were the same between the two domains (something that can be done during a...

SQL Noob (11/6/2007)

---

MSSQL needs a federated design like Oracle and MySQL where you use a bunch of cheapo boxes and don't need MSCS clusters. if one fails you simply reroll...

I blogged on this last Thursday;

Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs

When you add a second condition to the WHERE clause, you have an evaluation order issue.