I've tried both Lumigents AuditDB (Entegra at the time) and Idera's SQLCompliance. It's been a couple of years since I've used Lumigents product but here is what I know...

The user must have a DENY permission set at some level. Can the user select against any other table? Check to see what roles the user is part...

To give execute privileges to all procedures, I give execute rights to a DB Role at a schema level then assign users to that role... but database level should work...

Why do you need to specifically deny privileges? If a user is not granted access to object then it cannot access the object. The deny is used to...

The only reason you would need to do anything to the second user after adding him to the database role is if has deny privileges somewhere. Once you add...

I'm not aware of any threads... but I would venture to say there probably are some.

You can change the port in the TCP/IP properties using SQL Server Configuration Manager under...

When you select the permissions tab on the Schema you should only see the database role not any users. If you do, remove any specific user permissions on the...

You still need to give the user privileges to the database or schema. If you want to limit the users to just read privileges on a specific schema then...

As Markus suggested, it would be good idea to rename the sa account. If possible, change the port from 1433 and make sure that SQL Server Browser is disabled....

If you are on 3042 you want KB934458 http://support.microsoft.com/kb/934458/. KB934459 will references this as well.

I use this on all SQL 2K5 installations and have not had any...

Marketing is a huge business, just look at the money spent on 30 second adds in the Super Bowl. One of the benefits of all the data mining is...

Glad I could help.

Bring up the Registered Servers view in Management Studio then right click in the window and select "Previously Registered Servers". This will import the registered servers and groups from...

I've seen this tool by Red Gate but never really looked into it.  Based on your article, I can definitely see some major benefits for...

Great article.  We are in the planning stage of upgrading databases to SQL2K5 and several have FTS... so thanks for the information.  Hopefully now I won't have the same issues