just run this sql "Select DISTINCT(name) FROM sys.Tables" you will get the result
more info How to find tables in a Database in C# Find the tables in a Database
Thanks for this. Just what I was looking for
For Windows 7 I just made a copy of the simsperm script and then did a search and replace on program files to program files (x86) seems to work fine. This is assuming your Windows 7 folders are installing into the x86 folder.
If you post in that thread, they can test for you...
@vikpaw I'm trying to get hold of a Windows 7 system to test it on. If I can get it working I will report back with the results.
@kevin_lane In my school simsperm is still required, as we haven't switched to SOLUS yet.
It is until SOLUS 3 is fully working everywhere, at least for the upgrade process. Users still need permissions on certain areas just for daily usage, though they may not need to be all that elevated, as most files would be in the documents folder.
See here though: http://www.edugeek.net/forums/mis-sy...t-win-7-a.html
i didnt think simsperm was needed any more
Good job. Why don't you post it in the MIS forum for others to test.
It would be good to have a windows 7 version as i'm pretty sure it would need modifying to cope with the increased security on the C drive, so maybe you or someone there can do that.