That should work. Be sure you add a WHERE clause based on your criteria.

When you login as sa, thre is no NTUsername, that's when you log in using Windows authentication.

I agree with AJ, change the pwd and you'll find out, or someone will...

You might have to write some ASP or VB code to get it to display. I suspect the textbox thing in QA is limited here for some reason.

the checkpoint should occur every minute or so. Are you sure of the recovery model? Also, dbcc opentran, there might be an open transaction which is causing it to grow.

If your website is for authenticated people in your company, you'd use CALs. If it's the internet and anonymous people, it's per CPU.

You can check syslogins for the last change date. This is for any aspect of the login, not just passwords, but in reality, it usually is the password that is...

You need an IF statement.

If x = 1

select y, z from my table

else

select y, z, from table2

You cannot change the from statement with a case.

Interesting, and I thought objectname was broken as a filter. Thanks for the info, scott.

It's highly frowned upon and could cause problems. In SQL Server 7, triggers on system tables were not guarenteed to fire.

I'd setup a job that runs every hour to look...

The app might have been an admin on the nondedicated machine and you were not aware of it. Being an admin and named pipes v TCP should not have anything...

Hopefully you can track an IP or hostname. If you can't, you might need a network sniffer to find the traffic.

Agree with above. The login failures are being caused by something else if your app is working.

Should fix them all, report how many were fixed. Are you running Auto fix?

Who owns the tables? If you own the tables and stored procedure, then you can grant execute on the procedure and the developer will be able to run it. If...

Are the Novell clients runnng Windows or Linux? Trusted connections are only available from Windows machines.