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

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

891 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

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

SQL Transaction Replication on a large DB

By ARPRINCE

I want to create a transaction replication (SVR-A to SVR-B) from scratch on one...

Establishing SQL server tables Relationships without knowledge of DB and tables

By zocial411

Hi I'm Consultant as A DBA and a manager asked me to add or...

Changing the Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing the Data Frame

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers