Here is a script that does what you are looking for:http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=298
Unfortunately I don't -- but that's not a bad idea for another tool. Perhaps someone else has created one. I've been sitting on DumpSQLSec for three years and I bet quite a few DBAs have some cool SQL-DMO code out there. Let's start posting it.
On seperate note, creating a SQL-DMO applicaton is a great way for DBAs to brush up on their programming skills. I plan on creating a .NET SQL-DMO application sometime this year in order to start learning .NET and of the course there's the added benefit of having yet another useful tool.
I have some code written in C# that dumps all users, table defs, and permissions to local files on disk.
The code installs as a service and would only need a tweak to read the server name from a file or a registry setting. I'll post the code on here if anyone is interested and they can amend it and use it as they see fit.
where is the free downloads section ?
i've just had a look for it and can't find it ...
Yeah! I do remember reading that in the docs. My bad. That was it - the SQL client, they forget to add that to my new hard drive image. I have it back and the app works! Thanks! You rock!
~Chuck
I had it working and it rocked...then my company upgraded my pc from NT workstation to XP and now I get this error when I try to select a server from DumpSQLSec's Report menu:
