No, because even with the trigger option, a sysadmin level account could simply disable the trigger. Anyone bearing that level of privilege should be highly trusted, just as a person...

Another option is to apply column-level security preventing updates... for instance:

DENY UPDATE ON dbo.Orders (OrderID) TO Public

Of course, this won't stop anyone who is mapped as...

This is where the technique used by Patrick and by my alphabet soup certification friend is invaluable. By scheduling the test, you've got incentive.

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Usage: you'll actually have to do a breakdown based on size of the organization and core technologies. MySQL is promising to be Enterprise-ready in the next version by adding full...

You're welcome. And if you have suggestions that you didn't see in the article that has helped you in your pursuit of certification, please post them. We can all learn...

The problem is the maximum row length is > 8060. If someone filled out all the fields to their max length, you're talking 36000 bytes. I'd look at either splitting...

A full version is not. You can install the client tools. That should be sufficient. They are part of the same install package.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

You're going to have to use the indexkey_property() system function in order to get this information. For instance, the logic from sp_helpindex that determines whether or not an index is...

Greg,

this is true if you have sysadmin rights for the box (which is the minimum required to execute xp_cmdshell unless addition GRANT statements are executed). However, if a user isn't...

The current price within the US I believe is now US$125 per Microsoft exam.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

When you say "security," that's an awfully broad topic. Are you speaking of how to lock down each or are you speaking of how to manage user rights within the...

Please do not cross-post. Most forum participants read all forums.

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11794

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

When in doubt, go grab the SQL Server Critical Update tools to patch the MSDE. It works when the normal installs don't. We've had to use it on a couple...

Also make sure you have the appropriate accounts specified as sysadmin fixed server role members before dropping BUILTIN\Administrators. Last thing you want to do is drop that group and then...

Since ISA and SQL Server (MSDE) are on the same box, you can probably configure SQL Server not to use a network library. In this case it'll go to shared...