Clinton Herring


sp_gen_checksum_selects

Compile in master. Set your QA output to text. When run from the db of interest it generates checksum select statements for each user table in the db composed of the PK columns and a checksum for all columns excluding text, ntext, image and sql-variant. There are no parameters. Modify for your own use. Save […]

2005-12-19 (first published: )

164 reads

sp_GetDirInfo

Returns information about the files in the specified directory and/or subdirectories (if requested) and the total bytes for those files. Directory names are excluded so that the total bytes can be computed using the compute clause but you can specify that they be included at the expense of no total bytes. This sp uses the […]

2005-11-25 (first published: )

489 reads

SQL 2K SMTP mail on Windows 2K

SP_SQLSMTPMail is an OLE automation implementation of the CDOSYS dll for Windows 2000 which utilizes a network SMTP server rather than an Exchange server/Outlook client. The stored procedure functions similar to xp_sendmail including the ability to run a query and attach the results. No MAPI profile is required. It is also a working, detailed example […]

5 (6)

2005-10-12 (first published: )

3,733 reads

ufn_vbintohexstr

A function to convert varbinary to hex string. Have you every tried to deal with varbinary via T-SQL? Passwords and SIDs are of this datatype. In Query Analyzer this datatype displays as hex string but under the hood it is binary. Try concatenating a varbinary to a string in a print statement and you get […]

5 (2)

2005-06-09 (first published: )

224 reads

sp_RemoveLogin

Ever have trouble removing logins because of onwership issues and permission grants? This stored procedure checks for a login (sql or nt) on the local server and if found it then checks each database for ownership issues and granted permissions. The rules for action taken are listed in the header of the stored procedure. Works […]

5 (1)

2005-04-19 (first published: )

894 reads

usp_exec_tsql_strfile

Executes a file containing T-SQL code without using OSQL. The file can be up to 80,000 characters. Each line in the file should be no more than 256 characters. (Customize the code as needed.) The DOS Type command is used to retrieve the code. Embedded "go"s are removed so don't expect termination behavior. The only […]

2005-03-25 (first published: )

515 reads

Capture useful info about your SQL Server dbs

The server goes down and you are scrambling to remember settings, file names, locations, etc. about your databases on that server. This script captures that useful information before a serious problem occurs. I run it as an OSQL (ISQL) job and send the output file to my backup folder so the infomation goes to tape […]

4.5 (2)

2003-08-07

653 reads

Blogs

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Two methods of deployment Azure Data Factory

By

Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...

Moving the Community Forward

By

Today is the last day that the PASS and SQL Saturday websites will be...

Read the latest Blogs

Forums

Who is my customer?

By Kathi Kellenberger

Comments posted to this topic are about the item Who is my customer?

Newbie; Unsure where to Start?

By ptmuldoon

Hi,  First time poster, and hoping everyone goes easy on me. I am very...

DB corruption error 8905, fixed using repair_allow_data_loss ,

By huishi.ca

hi all, I need some help here. Recently, I've found a db with error...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers