July 15, 2014 at 2:27 pm
Hi,
I am looking for a query where i can get alll the information for all databases, users, linkedservers etc... for that instance.
eg: which user is mapped to what database with kind of access, all the linked servers, database recovery models etc.. I have one but might need more descriptive since doesn't list all
exec sp_helpsrvrolemember 'sysadmin'
go
EXEC sp_MSforeachdb @command1= "PRINT '?' EXEC [?].dbo.sp_helprolemember 'db_owner'"
go
Thnaks so much all for looking into it and hope find something even better that above query.
July 16, 2014 at 4:20 am
I don't think there is just one script to get all your desired information. You could search the script section of SSC site for several scripts and combine them yourself. See http://www.sqlservercentral.com/Scripts/
July 16, 2014 at 10:39 am
As HanShi said, there really isn't one query (I suppose you could write one) that would get all that for you. I recommend you look at SQL Power Doc[/url] on codeplex. This a set of PowerShell scripts that, I believe, can provide you with all the information you are looking for.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy