mssql-server-cheatsheet.md (3991B)
1 --- 2 title: "MSSQL Server" 3 topic: "Methodology and Resources" 4 topicSlug: "methodology-and-resources" 5 sourcePath: "Methodology and Resources/MSSQL Server - Cheatsheet.md" 6 sourceUrl: "https://github.com/swisskyrepo/PayloadsAllTheThings/blob/3ac27901c711/Methodology%20and%20Resources/MSSQL%20Server%20-%20Cheatsheet.md" 7 sha: "3ac27901c711" 8 isReadme: false 9 --- 10 11 # MSSQL Server 12 13 :warning: Content of this page has been moved to [InternalAllTheThings/cheatsheets/mssql-server-cheatsheet](/internal/cheatsheets) 14 15 - [Tools](/internal/cheatsheets) 16 - [Identify Instances and Databases](/internal/cheatsheets) 17 - [Discover Local SQL Server Instances](/internal/cheatsheets) 18 - [Discover Domain SQL Server Instances](/internal/cheatsheets) 19 - [Discover Remote SQL Server Instances](/internal/cheatsheets) 20 - [Identify Encrypted databases](/internal/cheatsheets) 21 - [Version Query](/internal/cheatsheets) 22 - [Identify Sensitive Information](/internal/cheatsheets) 23 - [Get Tables from a Specific Database](/internal/cheatsheets) 24 - [Gather 5 Entries from Each Column](/internal/cheatsheets) 25 - [Gather 5 Entries from a Specific Table](/internal/cheatsheets) 26 - [Dump common information from server to files](/internal/cheatsheets) 27 - [Linked Database](/internal/cheatsheets) 28 - [Find Trusted Link](/internal/cheatsheets) 29 - [Execute Query Through The Link](/internal/cheatsheets) 30 - [Crawl Links for Instances in the Domain](/internal/cheatsheets) 31 - [Crawl Links for a Specific Instance](/internal/cheatsheets) 32 - [Query Version of Linked Database](/internal/cheatsheets) 33 - [Execute Procedure on Linked Database](/internal/cheatsheets) 34 - [Determine Names of Linked Databases](/internal/cheatsheets) 35 - [Determine All the Tables Names from a Selected Linked Database](/internal/cheatsheets) 36 - [Gather the Top 5 Columns from a Selected Linked Table](/internal/cheatsheets) 37 - [Gather Entries from a Selected Linked Column](/internal/cheatsheets) 38 - [Command Execution via xp_cmdshell](/internal/cheatsheets) 39 - [Extended Stored Procedure](/internal/cheatsheets) 40 - [Add the extended stored procedure and list extended stored procedures](/internal/cheatsheets) 41 - [CLR Assemblies](/internal/cheatsheets) 42 - [Execute commands using CLR assembly](/internal/cheatsheets) 43 - [Manually creating a CLR DLL and importing it](/internal/cheatsheets) 44 - [OLE Automation](/internal/cheatsheets) 45 - [Execute commands using OLE automation procedures](/internal/cheatsheets) 46 - [Agent Jobs](/internal/cheatsheets) 47 - [Execute commands through SQL Agent Job service](/internal/cheatsheets) 48 - [List All Jobs](/internal/cheatsheets) 49 - [External Scripts](/internal/cheatsheets) 50 - [Python](/internal/cheatsheets) 51 - [R](/internal/cheatsheets) 52 - [Audit Checks](/internal/cheatsheets) 53 - [Find and exploit impersonation opportunities](/internal/cheatsheets) 54 - [Find databases that have been configured as trustworthy](/internal/cheatsheets) 55 - [Manual SQL Server Queries](/internal/cheatsheets) 56 - [Query Current User & determine if the user is a sysadmin](/internal/cheatsheets) 57 - [Current Role](/internal/cheatsheets) 58 - [Current DB](/internal/cheatsheets) 59 - [List all tables](/internal/cheatsheets) 60 - [List all databases](/internal/cheatsheets) 61 - [All Logins on Server](/internal/cheatsheets) 62 - [All Database Users for a Database](/internal/cheatsheets) 63 - [List All Sysadmins](/internal/cheatsheets) 64 - [List All Database Roles](/internal/cheatsheets) 65 - [Effective Permissions from the Server](/internal/cheatsheets) 66 - [Effective Permissions from the Database](/internal/cheatsheets) 67 - [Find SQL Server Logins Which can be Impersonated for the Current Database](/internal/cheatsheets) 68 - [Exploiting Impersonation](/internal/cheatsheets) 69 - [Exploiting Nested Impersonation](/internal/cheatsheets) 70 - [MSSQL Accounts and Hashes](/internal/cheatsheets) 71 - [References](/internal/cheatsheets)