Can someone give me a script that builds a tsql code to do the following
Add db_datareader role for a given login name - that I provide as a string to all user databses that it finds on the server
The script should build a complete sql code with name of user and the name of the user databases it finds on the server embedded into the tsql - and then allow me to review it and execute it seperately.
It should be generic and perhaps flexible enough to run on 2k databases too if possible
we have a mixture of 2008, 2005 and 2k machines.