I have some C# code that dumps table defs and permissions using DMO.

If you want it let me know.

Steve

Excellent!! Works very nicely Do you have any code that will dump(to a file) all user permission, writes, etc so that once I create another database on differenet server (test environment) I can reload the file and it would automatically load all users and ther permissions, passwords, etc??

Thanks and again, excellent work!

Well, I've been looking for a reason and an opportunity to familiarize myself a little on DMO.  This seems like a useful tool that I can employ on a current project, so I think this is the opportunity.

Thanks.

I'm definitely gonna take a look at this, but I'm wondering...

Can this tool (or another other tool/script/sproc) show a "last logged in" date?

Always trying to determine if a particular user is "active" or not.

Sweet tool!

Thanks...

out community: PASSJ
PASSJ is Professional Association for SQL Server Japan.
I'm a PASSJ dicector, and security-board leader.

I already introduce DumpSQLSec in my BLog by Japanese.
 DumpSQLSec (Tools for output Security Setting to Excel)