Neil Jacobson

Technical Article

Run a blackbox trace

There is a script for setting up a blackbox trace on SQL 2000 described by Kalen Delaney in "Inside SQL Server 2000". Since I can never remember where to look it up I wrote this simple stored procedure to run the blackbox trace when I need it. This should be used with caution as it […]


612 reads

Technical Article

Get list of files from dir and put in table

This stored procedure reads the file names from a directory and stores just the names in a given table. It returns also the number of files present. The sp uses xp_cmdshell and so permissions are restricted to sysadmins and SQLAgentCmdExec. You can test with the following: Create Table ##tmp2 ( fldx nvarchar(255) ) Declare @FilePath […]

1 (1)


1,928 reads


New Job -> Week 2 -> Creating a Checklist


This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out


SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present


Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs


SSIS C# Script Question

By water490

Hi everyone I am working on a SSIS package where I am automating data...

Review Early and Often

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Review Early and Often

SQL Agent jobs - script to get what jobs failed

By Summer90

I have been trying to find SQL that shows what SQL Agent jobs failed...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers