Get size in bytes of SP, View, Trigger, UDF or Rul
This UDF and its equivalent stored procedure will return the size of a stored procedure, view, rule or user defined function in bytes .
2002-12-07
86 reads
SQLInsider Scripts
Decrypt Stored Procedures, Views and Triggers
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 […]
2002-12-06
1,413 reads
123 TSQL functions
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, […]
2002-12-05
982 reads
Text to Speech + Convert Numbers to Words in 4 languages
These are functions and stored procedures to convert numbers to words, in three languages: English, Portuguese and Spanish. There is also a function to convert text to speech.
2002-12-04
143 reads
Find SA password with public role-perm test DBA
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 […]
2002-12-04
953 reads
TSQL Encryption TEA, RC4, Vigenere, Caesar, XOR
Encrypt fields with these stored procedures and functions: TEA (new variant), TEA, RC4, Vigenere, Caesar, XOR, XOR8 for SQL Server This is a collection of stored procedures and encryption functions (UDF's) in TSQL.
2002-12-02
404 reads
SP to get Trigger and Table info
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
324 reads
Find Constraints on a table
This script would help find primary key, foriegn key, unique constraints, check constraints on a table. With slight modification you can use it to find various information about a table.
2002-04-01
589 reads
Get BCP out for all tables in a DB
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 […]
2002-03-15
2,084 reads
Script to list user tables with related procedures
This script interrogates the system tables and provides a list of user tables with related stored procedures and triggers. Alternately, reordering the temporary table provides a list of stored procedures with the table names used in each procedure.
2002-02-18
360 reads
Blogs
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Forums
Logging SQLExceptions
We have a web front-end which I believe in some cases is throwing unhandled...
An Incomplete Window Definition
Comments posted to this topic are about the item An Incomplete Window Definition
A Lack of Privacy in Smart Cars
Comments posted to this topic are about the item A Lack of Privacy in...
Ask SSC