I am a self admitted SQL dummy. I need to run audits on SQL permissions and database info and was wondering if anyone can recommend a lesser expensive reporting software I can use? I hope that is enough information. Thanks in advance for your help.
You may not really need a bit of software to do this, as this information is all stored by SQL, so it might be worth having a look at the SYSUSERS table.
Try having a look in the BOL, or maybe try just looking at the contents of that table and see if it helps.
If you know specifically what information you need to show in the report its probably worth posting that; someone here may already have written a query to do that which they may be prepared to post up for you to use.
Fee.
"The question should be, is it worth trying to do, not can it be done"
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.