Name	Name	Last commit message	Last commit date
parent directory ..
README.md	README.md	Remove Kenneth Fisher stored procedure and added links to its repository	Jun 2, 2019
Recover_Deleted_Data_Proc.sql	Recover_Deleted_Data_Proc.sql	Add Recover_Deleted_Data_Proc stored procedure	Aug 21, 2020
dbo.PerformanceGraph.sql	dbo.PerformanceGraph.sql	Add dbo.PerformanceGraph procedure	Oct 19, 2019
dbo.sp_AllocationMetadata.sql	dbo.sp_AllocationMetadata.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_BenchmarkTSQL.sql	dbo.sp_BenchmarkTSQL.sql	Fix documentation	Aug 26, 2019
dbo.sp_BlitzInMemoryOLTP.sql	dbo.sp_BlitzInMemoryOLTP.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_Blocked_Process_Report_Viewer.sql	dbo.sp_Blocked_Process_Report_Viewer.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_ChangeDatabaseOwnerShip.sql	dbo.sp_ChangeDatabaseOwnerShip.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_DBA_job_notification.sql	dbo.sp_DBA_job_notification.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_Defrag_Indexes.sql	dbo.sp_Defrag_Indexes.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_Depends.sql	dbo.sp_Depends.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_DropIndexes.sql	dbo.sp_DropIndexes.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_Example_RegisterAssembly_PDFCLR.sql	dbo.sp_Example_RegisterAssembly_PDFCLR.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_FailedJobs.sql	dbo.sp_FailedJobs.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_FailedLogins.sql	dbo.sp_FailedLogins.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_GenerateMerge.sql	dbo.sp_GenerateMerge.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_IndexAnalysis-v11.sql	dbo.sp_IndexAnalysis-v11.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_PerfSQ.sql	dbo.sp_PerfSQ.sql	Add dbo.sp_PerfSQ	Dec 1, 2019
dbo.sp_PrintString.sql	dbo.sp_PrintString.sql	Update dbo.sp_PrintString.sql	Dec 15, 2024
dbo.sp_RestoreGene.sql	dbo.sp_RestoreGene.sql	Update dbo.sp_RestoreGene.sql	Jun 27, 2023
dbo.sp_RestoreScript.sql	dbo.sp_RestoreScript.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_SQLskills_ExposeColsInIndexLevels.sql	dbo.sp_SQLskills_ExposeColsInIndexLevels.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_SQLskills_helpindex.sql	dbo.sp_SQLskills_helpindex.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_Snapshot.sql	dbo.sp_Snapshot.sql	Add new article and format some stored procedures	Sep 29, 2017
dbo.sp_WhatsupQueryStore.sql	dbo.sp_WhatsupQueryStore.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_capture_login_auth.sql	dbo.sp_capture_login_auth.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_ctrl3.sql	dbo.sp_ctrl3.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_doc.sql	dbo.sp_doc.sql	Rename sp_doc.sql to dbo.sp_doc.sql	Jan 13, 2021
dbo.sp_estindex.sql	dbo.sp_estindex.sql	Rename sp_estindex.sql to dbo.sp_estindex.sql	Jan 13, 2021
dbo.sp_foreign_key$batch_drop_and_recreate.sql	dbo.sp_foreign_key$batch_drop_and_recreate.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_generate_merge.sql	dbo.sp_generate_merge.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_helpExpandView.sql	dbo.sp_helpExpandView.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_help_permissions.sql	dbo.sp_help_permissions.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_helpme.sql	dbo.sp_helpme.sql	Rename sp_helpme.sql to dbo.sp_helpme.sql	Jan 13, 2021
dbo.sp_ns_shrink_db_log.sql	dbo.sp_ns_shrink_db_log.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_sizeoptimiser.sql	dbo.sp_sizeoptimiser.sql	update sizeoptimiser	Jan 13, 2021
dbo.sp_sizing.sql	dbo.sp_sizing.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sp_sqltrace.sql	dbo.sp_sqltrace.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.sqlg_ParseDiskskpXml.sql	dbo.sqlg_ParseDiskskpXml.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.udp_IntegerListfromRanges.sql	dbo.udp_IntegerListfromRanges.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_Breadth_First.sql	dbo.usp_Breadth_First.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_BulkUpload.sql	dbo.usp_BulkUpload.sql	Add new articles, fix some bugs and code formating	Apr 24, 2019
dbo.usp_CopyLogins.sql	dbo.usp_CopyLogins.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_CreatePlantUMLCode.sql	dbo.usp_CreatePlantUMLCode.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_DBA_Rename_Database.sql	dbo.usp_DBA_Rename_Database.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_Dijkstra.sql	dbo.usp_Dijkstra.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_EnableAndAddFileStreamForDatabase.sql	dbo.usp_EnableAndAddFileStreamForDatabase.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_FindDbObjects.sql	dbo.usp_FindDbObjects.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_GenerateRandomPassword.sql	dbo.usp_GenerateRandomPassword.sql	Add usp_GenerateRandomPassword stored procedure	Feb 18, 2019
dbo.usp_Generate_Merge.sql	dbo.usp_Generate_Merge.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_GetPackageDetails.sql	dbo.usp_GetPackageDetails.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_GetUntrustedForeignKeys.sql	dbo.usp_GetUntrustedForeignKeys.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_Kruskal.sql	dbo.usp_Kruskal.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_LoadTableBlobs.sql	dbo.usp_LoadTableBlobs.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_LogError.sql	dbo.usp_LogError.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_Object_Search.sql	dbo.usp_Object_Search.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_Prim.sql	dbo.usp_Prim.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_PrintDebug.sql	dbo.usp_PrintDebug.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_PrintError.sql	dbo.usp_PrintError.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_RandomWait.sql	dbo.usp_RandomWait.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_RunCheckAllUntrustedForeignKeys.sql	dbo.usp_RunCheckAllUntrustedForeignKeys.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SQL_Server_System_Report.sql	dbo.usp_SQL_Server_System_Report.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SQLskillsAnalyzeLog.sql	dbo.usp_SQLskillsAnalyzeLog.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SSIS_ScriptEnvironment.sql	dbo.usp_SSIS_ScriptEnvironment.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SearchOnAllDB.sql	dbo.usp_SearchOnAllDB.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SearchStoredProcedureText.sql	dbo.usp_SearchStoredProcedureText.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_SetFileGrowth.sql	dbo.usp_SetFileGrowth.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_String_Search.sql	dbo.usp_String_Search.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_TableUnpivot.sql	dbo.usp_TableUnpivot.sql	Update dbo.usp_TableUnpivot.sql stored procedure	Jan 29, 2020
dbo.usp_TopologicalSort.sql	dbo.usp_TopologicalSort.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_TransliterationEN2RU.sql	dbo.usp_TransliterationEN2RU.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_UnusedInputParameters.sql	dbo.usp_UnusedInputParameters.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_bcpTableUnload.sql	dbo.usp_bcpTableUnload.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_bcpTableUnloadBatchMode.sql	dbo.usp_bcpTableUnloadBatchMode.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_bcpUnloadSelect.sql	dbo.usp_bcpUnloadSelect.sql	Change default code page to UTF8	Jun 21, 2021
dbo.usp_checkAllDatabases.sql	dbo.usp_checkAllDatabases.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_generateIdentifier.sql	dbo.usp_generateIdentifier.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018
dbo.usp_who5.sql	dbo.usp_who5.sql	Add scheme name (dbo) for stored procedure file names	Nov 5, 2018

Name

Last commit message

Last commit date

README.md

Remove Kenneth Fisher stored procedure and added links to its repository

Jun 2, 2019

Recover_Deleted_Data_Proc.sql

Add Recover_Deleted_Data_Proc stored procedure

Aug 21, 2020

dbo.PerformanceGraph.sql

Add dbo.PerformanceGraph procedure

Oct 19, 2019

dbo.sp_AllocationMetadata.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_BenchmarkTSQL.sql

Fix documentation

Aug 26, 2019

dbo.sp_BlitzInMemoryOLTP.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_Blocked_Process_Report_Viewer.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_ChangeDatabaseOwnerShip.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_DBA_job_notification.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_Defrag_Indexes.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_Depends.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_DropIndexes.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_Example_RegisterAssembly_PDFCLR.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_FailedJobs.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_FailedLogins.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_GenerateMerge.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_IndexAnalysis-v11.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_PerfSQ.sql

Add dbo.sp_PerfSQ

Dec 1, 2019

dbo.sp_PrintString.sql

Update dbo.sp_PrintString.sql

Dec 15, 2024

dbo.sp_RestoreGene.sql

Update dbo.sp_RestoreGene.sql

Jun 27, 2023

dbo.sp_RestoreScript.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_SQLskills_ExposeColsInIndexLevels.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_SQLskills_helpindex.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_Snapshot.sql

Add new article and format some stored procedures

Sep 29, 2017

dbo.sp_WhatsupQueryStore.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_capture_login_auth.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_ctrl3.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_doc.sql

Rename sp_doc.sql to dbo.sp_doc.sql

Jan 13, 2021

dbo.sp_estindex.sql

Rename sp_estindex.sql to dbo.sp_estindex.sql

Jan 13, 2021

dbo.sp_foreign_key$batch_drop_and_recreate.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_generate_merge.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_helpExpandView.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_help_permissions.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_helpme.sql

Rename sp_helpme.sql to dbo.sp_helpme.sql

Jan 13, 2021

dbo.sp_ns_shrink_db_log.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_sizeoptimiser.sql

update sizeoptimiser

Jan 13, 2021

dbo.sp_sizing.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sp_sqltrace.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.sqlg_ParseDiskskpXml.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.udp_IntegerListfromRanges.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_Breadth_First.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_BulkUpload.sql

Add new articles, fix some bugs and code formating

Apr 24, 2019

dbo.usp_CopyLogins.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_CreatePlantUMLCode.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_DBA_Rename_Database.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_Dijkstra.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_EnableAndAddFileStreamForDatabase.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_FindDbObjects.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_GenerateRandomPassword.sql

Add usp_GenerateRandomPassword stored procedure

Feb 18, 2019

dbo.usp_Generate_Merge.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_GetPackageDetails.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_GetUntrustedForeignKeys.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_Kruskal.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_LoadTableBlobs.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_LogError.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_Object_Search.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_Prim.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_PrintDebug.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_PrintError.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_RandomWait.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_RunCheckAllUntrustedForeignKeys.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SQL_Server_System_Report.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SQLskillsAnalyzeLog.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SSIS_ScriptEnvironment.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SearchOnAllDB.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SearchStoredProcedureText.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_SetFileGrowth.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_String_Search.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_TableUnpivot.sql

Update dbo.usp_TableUnpivot.sql stored procedure

Jan 29, 2020

dbo.usp_TopologicalSort.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_TransliterationEN2RU.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_UnusedInputParameters.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_bcpTableUnload.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_bcpTableUnloadBatchMode.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_bcpUnloadSelect.sql

Change default code page to UTF8

Jun 21, 2021

dbo.usp_checkAllDatabases.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_generateIdentifier.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

dbo.usp_who5.sql

Add scheme name (dbo) for stored procedure file names

Nov 5, 2018

Microsoft SQL Server Stored Procedure

SQL Server Name Convention and T-SQL Programming Style

Start all procedure from if exist statement:

IF OBJECT_ID('dbo.ProcedureName', 'P') IS NULL
EXECUTE ('CREATE PROCEDURE dbo.ProcedureName AS SELECT 1');
GO


ALTER PROCEDURE dbo.usp_ProcedureName(

It helps to save all grants for procedure (analog CREATE OR REPLACE PROCEDURE in Oracle).

sp_IndexAnalysis-v11

Author: Jason Strate
Original link: http://www.jasonstrate.com/2013/05/index-analysis-may-update/
Tested on SQL Server version: 2012/2014

sp_RestoreGene

Author: Andy Yun
Original link: https://sqlbek.wordpress.com/2015/03/04/sp_helpexpandview-well-i-didnt-expect-that/
Tested on SQL Server version: 2008/2012/2014

sp_RestoreGene

Author: Paul Brewer
Original link: https://paulbrewer.wordpress.com/sp_restoregene/
Tested on SQL Server version: 2008/2012/2014

usp_GetUntrustedForeignKeys

Author: Jefferson Elias
Original link: http://www.sqlshack.com/managing-untrusted-foreign-keys/
Tested on SQL Server version: 2008/2012/2014

usp_RunCheckAllUntrustedForeignKeys

Author: Jefferson Elias
Original link: http://www.sqlshack.com/managing-untrusted-foreign-keys/
Tested on SQL Server version: 2008/2012/2014

sp_capture_login_auth

Author: Unknown
Original link: Unknown
Tested on SQL Server version: 2012/2014

sp_Blocked_Process_Report_Viewer

Author: Michael J. Swart
Original link: https://sqlblockedprocesses.codeplex.com/
Tested on SQL Server version: 2012/2014

sp_sqltrace

Author: Erland Sommarskog
Original link: http://www.sommarskog.se/sqlutil/sqltrace.html
Tested on SQL Server version: 2005/2008/2012/2014

usp_BulkUpload

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_EnableAndAddFileStreamForDatabase

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012

usp_FindDbObjects

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_LogError

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_Object_Search

Author: Sean Smith
Original link: http://www.sqlservercentral.com/scripts/object/66798/
Tested on SQL Server version: 2008/2012/2014

usp_PrintDebug

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_PrintError

Author: Microsoft
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_RandomWait

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_SQL_Server_System_Report

Author: Sean Smith
Original link: http://www.sqlservercentral.com/scripts/Administration/70243/
Tested on SQL Server version: 2008/2012/2014

usp_SearchOnAllDB

Author: David Musgrave
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_String_Search

Author: Sean Smith
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_TableUnpivot

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_UnusedInputParameters

Author: Sean Smith
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_bcpTableUnload

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_bcpTableUnloadBatchMode

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_bcpUnloadSelect

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_who5

Author: Sean Smith
Original link: http://wwwservercentral.com/scripts/sp_who/68607/
Tested on SQL Server version: 2012/2014

usp_PrintString

Author: John Huang
Original link: http://www.sqlservercentral.com/blogs/john-huangs-blog/2015/11/19/print-long-string/
Tested on SQL Server version: 2014

usp_Generate_Merge

Author: Narayana Vyas Kondreddi
Original link: https://github.com/SQLauto/generate-sql-merge/blob/master/master.dbo.sp_generate_merge.sql
Tested on SQL Server version: 2008/2012/2014

usp_Generate_Merge

Author: Jeff Jordan
Original link: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/135173/
Tested on SQL Server version: 2012/2014

usp_SQLskillsAnalyzeLog

Author: Paul S. Randal
Original link: http://www.sqlskills.com/blogs/paul/code-to-analyze-the-transaction-hierarchy-in-the-log/
Tested on SQL Server version: 2012/2014

usp_CreatePlantUMLCode

Author: Phil Factor
Original link: https://www.simple-talk.com/sql/sql-tools/automatically-creating-uml-database-diagrams-for-sql-server/
Tested on SQL Server version: 2012/2014

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Files

Stored_Procedure

Stored_Procedure

README.md

Microsoft SQL Server Stored Procedure

sp_IndexAnalysis-v11

sp_RestoreGene

sp_RestoreGene

usp_GetUntrustedForeignKeys

usp_RunCheckAllUntrustedForeignKeys

sp_capture_login_auth

sp_Blocked_Process_Report_Viewer

sp_sqltrace

usp_BulkUpload

usp_EnableAndAddFileStreamForDatabase

usp_FindDbObjects

usp_LogError

usp_Object_Search

usp_PrintDebug

usp_PrintError

usp_RandomWait

usp_SQL_Server_System_Report

usp_SearchOnAllDB

usp_String_Search

usp_TableUnpivot

usp_UnusedInputParameters

usp_bcpTableUnload

usp_bcpTableUnloadBatchMode

usp_bcpUnloadSelect

usp_who5

usp_PrintString

usp_Generate_Merge

usp_Generate_Merge

usp_SQLskillsAnalyzeLog

usp_CreatePlantUMLCode

Collapse file tree

Files

Stored_Procedure

Directory actions

More options

Directory actions

More options

Latest commit

History

Stored_Procedure

Folders and files

parent directory

Microsoft SQL Server Stored Procedure