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.
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.