Patrick Slesicki


Technical Article

Select Group Members from Logins

Know who all the individual group members are for a given WINDOWS_GROUP login. This script uses the sys.xp_logininfo procedure to find group members for each login on an instance. This is useful when attempting to remove orphaned WINDOWS_LOGINS. May have issues working across your logged in domain.

1 (1)

You rated this post out of 5. Change rating

2020-03-23 (first published: )

1,579 reads

Technical Article

Orphaned Users Search and Destroy

This script will find all orphaned users on all databases on an instance, and generate a script to drop each user. Simply execute, copy the values from the DropScript column to a new SSMS window and execute. There are two risks with this script. Use with caution: This script attempts to take into account users […]

You rated this post out of 5. Change rating

2020-03-16 (first published: )

1,233 reads

Technical Article

String Search

The script searches through every column of every record in a database to find a value. It works with numbers too. Simply assign a value to @MyString. Indicate what datatype(s) you wish to search through, and indicate if you want wildcards, and execute. The search is smart and will only search through columns where @MyString is […]

3 (3)

You rated this post out of 5. Change rating

2020-03-05 (first published: )

1,161 reads

Blogs

Sabbatical le Troisième: A Recharge Week

By

It’s been a week since I flew home from London and Redgate to begin...

SQL Server Careers: Still a Goldmine, or a Dead End?

By

When you're searching about the future of a career in MS SQL Server, you're...

AI Destroying Creativity or Creative Industry

By

In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in...

Read the latest Blogs

Forums

how to move all SP from one db to another db?

By water490

Hi everyone I have two db - one is test and other is archive. ...

The Long Weekend

By Grant Fritchey

Comments posted to this topic are about the item The Long Weekend

Need Help to implement the De Duplication

By bala2014

Dear All, Good Day. I have a requirement to implement de-duplication on customer data...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers