Viewing 5 posts - 16 through 20 (of 20 total)
A really easy way is to just use a View with select only rights granted. I don't like giving people rights to tables at all. Granting database object permissons only to views...
August 17, 2006 at 9:26 am
Good article.
For additional thought, before tossing aside a third-party component solution due to cost and complexity consider this, based on your salary what did it cost you to create...
July 5, 2005 at 11:05 am
Not having used dotNet products yet, I use a time proven method. In my project SQL folder I put an empty file "ProcsError.log" and a batch file "CompileProcs.bat". the CompileProcs.bat...
June 1, 2004 at 10:23 am
A good question in which I guessed correctly. Further reading brought me to a remark concerning a potentially damaging side affect if the timeout occurs in a transaction and is not handled properly. According...
March 24, 2004 at 9:23 am
My ActiveX Script Task uses ADO to connect to the database and update a ProcessStatus table with values from some Package GlobalVariables.
August 27, 2003 at 10:05 am
Viewing 5 posts - 16 through 20 (of 20 total)