Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fjc718

  1. fjc718

    Stored Prcedures

    Anyone have any advice, tips on the best way to learn stored procedures/triggers. Obviously practice, practice, practice. But I was wondering if there were any materials/fellow employees/techniques that really helped you out. Just curious. Thanks.
  2. fjc718

    Anyone know why tables lose permissions?

    Yeah, I turned on the log...it's in the properties, security tab. Man, I lost more permissions today..this is really odd. It's not a stray user, guaranteed. The org. is not that big and I have double checked security. We do have a customized VB app running on the front end that may be executing...
  3. fjc718

    Anyone know why tables lose permissions?

    Im sure this is simple...but how do I get to the Error log in SQL..I know it also writes to the NT App log...so I get it there, just curious. Thanks for the replies.
  4. fjc718

    Anyone know why tables lose permissions?

    I have had this happen to me on numerous occassions. We have a particular database that is currently running SQL 7. For some reason, out of the clear blue (it seems) at times, a particular table will lose it's permissions. In other words, when you double click on a table and choose permissions...

Part and Inventory Search

Back
Top