Neil Jacobson

Technical Article

Stored Procedure to read tape backup log

If you need to check that the tape back of your database backup files was successful, you would generally read the errorlog for the backup software.If you are just interested in today's results or a particular day's log it can be a pain to get.  You could have a shortcut on the desktop or you […]

3 (1)

You rated this post out of 5. Change rating


367 reads

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 […]

You rated this post out of 5. Change rating


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

You rated this post out of 5. Change rating


1,928 reads

Technical Article

Stored procedure to expose information for a file

I wanted to be able to use info about an operating system file in TSQL. So I wrote this stored procedure that uses the special stored procedures xp_fileexist and xp_getfiledetails. This can tell if a file or folder exists, and if it is a file what is its size, created date and time, last written […]

You rated this post out of 5. Change rating


1,201 reads


Know Thy Platform


IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger


I got this message recently while committing some changes: This post shows my work...

EightKB 2024


EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

Read the latest Blogs


ssis catalog not showing all executions

By stan

Hi we just migrated to 2019.  Unlike our previous server on which every ssis...

Is there a such thing as connections being made too fast in a package?

By stricknyn

Hi all, SSIS doing some quirky things and I wanted to run a scenario...

inplace upgrade of 2008R2 SP3 Standard to 2017 Standard - Auth Error in WMI?

By DaveCon

This is a 2 Node FCI on Windows Server 2012 R2.  Let's call the...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?


See possible answers