We are finally in a position to upgrade our business system server from 2000 to 2005. ( we cannot go any higher yet as the system needs to support an old version of uniface).
The server chaps are asking me for:
the details of any user accounts you require creating on the new SQL 2005 , we need username, password, database and permissions level.
This server supports a main massive application, a 2nd large database for another 3rd party app, and several database which have been built by various departments for various web apps and other systems.
There are about 800 user accounts, 10 databases of various sizes, and a host of automated jobs, stored procedures or other scripts.
Is it possible to extract a list of the users on the DB using SQL? i'll need to list all the accounts, and analyse their permissions on each database, and if possible produce a script which can create them or at least assign their groups and permissions... which can be run on the new 2005 server once the databases have been imported.