That is correct, but here are some of the cons. This isn't to say tran log shipping isn't a good high-reliability solution. If it wasn't, no one would have figured...

You might also take a look at the free SQL Slammer Retina Scanner from eEye Digital Security. It brute force checks a C-class range at a time. It'll return the...

One of the DBAs in my environment has configured SQL Mail w/ Personal Folders. If you set it up right, this means SQL Mail won't fail if the Exchange Server...

Log shipping can be implemented with or without clustering. The requirement is SQL Server 2000 Enterprise Edition (if you want it handled by SQL Server), which is the same requirement...

If you are on SQL Server 2000, take a look at Global Variables and the Execute SQL Task Object. From the Contents tab:

Data Transformation Services | DTS Package Elements |...

SQL Server supports fail-over clustering, it doesn't support network load balancing (imagine trying to write data pages to disk from two nodes at the same time). Hence the reason you...

This is a MAPI issue and can occur in Outlook as well, so it's not specifically a Maintenance Plan issue. Is there a reason you are using Personal Folders (which...

Take a look at dtsrun.exe and it's command-line parameters. Here's the BOL page for the utility:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

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

Check your server security log as well (Event Log) if you have logon auditing turned on for success & failure.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

It should also be noted that while you may issue a GRANT against a whole table or view, internally SQL Server does the permissions check at the column level anyway,...

This would be someone either trying to log in using a SQL Server account when you are set to Windows authentication only or someone trying to log in from an...

No, SQL Server will not do this natively. However, such row-level security is only present in Oracle and Sybase (most recent version) so far as I am aware.

You can create...

Please don't cross-post. Most readers check all forums.

The T-SQL version:

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

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

It sounds like you're interested in doing something similar to a row-level security solution. If that's the case, check out this article from SQL Server MVP Vyas Kondreddi:

http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

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...