Scott.Deagan (11/5/2009)

---

Another solution that works well in most situations is to simply avoid allowing users to execute SQL statements at all - ensure that all access to tables is performed...

I would like to add couple of aditions/changes:

1. You don't need to use xp_cmdshell to find whether the new backup is available. You can refer to MSDB database to find...

Whenever you create a dynamic query in SP , it will be recompiled everytime adding to cost and time to execute it. Try writing Static SQL in SP and you will...

UNKNOWN and FALSE should give UNKNOWN as is with any data with null gives null.