Scripts

Script to Search SQL Error Log For a String

This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III

4 (1)

2001-08-13

1,814 reads

SQL Server Current Activity SuperCheck

This gives a quick check of the current activity on a SQL Server. I developed this after getting continually frustrated with "Current Activity" in SQL/EM getting blocked by processes when I needed to see blocking issues on the server. It has been immensely valuable to me in quickly identifying production-stopping issues on the database. It […]

4.2 (5)

2001-08-13

4,804 reads

Optimize Character Field Usage

This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table name, Column name, Defined datatype and length, Average length of data for that column, Minimum […]

2001-08-10

1,644 reads

Email using CDONTS (via smtp)

Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]

2001-08-09

3,501 reads

Generate Insert Statements Easily

This script will generate insert statements for the given tables. You can pass the tables names, separated by commas, into sp_DataAsInsCommand stored procedure as in the example below: EXEC sp_DataAsInsCommand 'employee,titleauthor,pub_info' Updated on 5/25/01 to correct an issue with columns that are short like a column defined as char(1), to correct another issue with the […]

3 (9)

2001-08-09

4,548 reads

Blogs

Adding a Column with a Default Constraint

By

Last week a question came up about adding a column to a table, and...

Rename Azure VM OS Disk

By

In a recent post about creating Azure VMs using PowerShell, I noted a common...

How I Continuously Learn About SQL Server

By

Watch this week’s episode on YouTube. In order to stay current in a technology...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Remove SQL Server from Failover Cluster

By SJD

Hi, I'm having a problem with a Windows Server 2008 R2 Failover Cluster with...

Existing logins get mapped to new databases

By TechotelNO

Pretty new with SQL but working my may up:-) When I create a new...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers