SQLInsider Scripts

Technical Article

Decrypt Stored Procedures, Views and Triggers

  • Script

This SP will decrypt Stored Procedures, Views or Triggers that were encrypted using "with encryption" There are 2 versions: one for SP's only and the other one for SP's, triggers and views version 1: INPUT: object name (stored procedure, view or trigger) version 2: INPUT: object name (stored procedure, view or trigger), object type('T'-trigger, 'P'-stored […]

1 (2)

You rated this post out of 5. Change rating

2002-12-06

1,386 reads

Technical Article

123 TSQL functions

  • Script

This is a collection of 123 TSQL functions for professional, academic or learning purposes. There are many conversions hexadecimal/octal/binary/Roman numerals, mathematical functions such as hyperbolic, logic and trigonometric. Combinatorial functions such as combinations, permutations (factorial), arrangements. Other interesting functions include turning a number into plain English, Morse code, EBCDIC and vice-versa, Levenshtein Distance (linguistics), encryption, […]

You rated this post out of 5. Change rating

2002-12-05

970 reads

Technical Article

Find SA password with public role-perm test DBA

  • Script

Find SA Password (Brute Force) with Public RoleFindSApublic is a brute-force password cracker that requires only public role.Possibilities  returns how many different passwords are possible with 1 up to c characters from a universe of n different characters.Usage:FindSApublic nN is an integer which is the maximum length of the password to attempt cracking.Acknowledgmentsoriginal idea: David […]

You rated this post out of 5. Change rating

2002-12-04

950 reads

Technical Article

Get BCP out for all tables in a DB

  • Script

           The script mentioned below will export data in all tables into textfiles to a physical path on your system using BCP utility from a Database. The sql commands used in this stored procedure are BCP utility,Identity function and temporary tables.    Here you required to give 4 input parameters, they […]

You rated this post out of 5. Change rating

2002-03-15

1,998 reads

Blogs

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

What is Always Encrypted and how does it work?

By

Always Encrypted was a new encryption feature added to SQL Server with the 2016...

Power BI – Empowering Users to Disable Tooltips

By

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...

Read the latest Blogs

Forums

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

The table InventDim has some indexes, we create one index idx1 which has index...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers