A fair amount of cleanup...

/*-------------------------------------------------------------------------------------------------
Name: LoginWindowsGroupMemberSelect.sql
Purpose:To find all user accounts for a Windows Group in SQL Server logins.
Author:Patrick Slesicki
Notes:Returns all user logins for a Windows Group

Simply execute...

Never you mind, found it, it's a SQL Prompt by Redgate feature...

Ran into the same issue, but I have SSMS Tools Pack and do not have the 'Script as INSERT' option.  I do have the save as Excel and script or...

Hi and thanks for taking the time to post your script.  It appears a space is missing before the 'FOR LOGIN' in the dynamic sql below:

Drew:  Thank you, I was noticing that when I was researching on the web.

Steve:  I am displaying the view in a custom ActiveReports project/viewer.  And fortunately, it rendered...

Hi, and thank you so much for taking the time to reply.  It reminded me about my original post!  

I was able to cobble a solution together, ugly,...

Coming into this a little late, but is there really a good reason to use the built-in SSMS dialog for 'Specify Values for Template Parameters'? It seems you...

Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found the comments...

It's actually the SQL from a view being created that is part of a large deployment script.

Thanks for the quick reply. My problem is not so much with the functionality of ISNULL with a concatenated field. My problem is the syntax I need to...

Works like a charm. Does have some extra html formatting code on Line 13 (an extra </pre>) at the end of the line. And yes, I could see...

Is there a reason you chose 64-bit instead of 32-bit? (or is this another article...) In other words, are there circumstances where one is more preferable than the...

Am I missing something? Besides the comment to add brackets to protect against special characters in the server name/instance, why is everyone giving this such a low rating? ...

Many thanks! I absolutely loved this. I need to make a copy of my current dev db so many times. This will be a great time saver....

Many thanks, this is much cleaner than my previous code.

I did add

AND INDEX_ID = 0

to the WHERE clause to keep my name list unique and not show indexes. ...