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: )

163 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: )

488 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,732 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: )

892 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: )

512 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

652 reads

Blogs

SQL Prompt and SSMS 18.5

By

I downloaded SSMS 18.5, as there were a lot of fixes in here and...

Jupyter Book Challenges in ADS

By

I was excited to try the Jupyter Book feature in the March Azure Data...

Join me (virtually) in Adelaide!

By

I will be presenting a session to the Adelaide SQL Server User Group on...

Read the latest Blogs

Forums

Always on Availability Groups

By shamantha4

Can i configure a 2 Node AG Availability group in the same data(local site) ...

DB mail issue

By ramyours2003

We received error when testing the DBmail The mail could not be sent to...

Issue with case statement

By mcfarlandparkway

i have a table A where the data looks like ID        Name      Phone            CODE...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

ADF Triggers

See possible answers