Scripts

Last week we had a conversion and the bank number was going to change during the process. I knew there was a lot of special code written for the bank and I did not want to miss anything. I needed to find an easy way to scan all tables in the database to f

Need to find if a string value exists in your table? This script will help you find all occurrences in all columns in a SQL Server table.

I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned. Well, you can im

Learn how to use T-SQL code to dynamically create windows folders to store database files or backup files to keep things organized.

Learn how to run the same command against all SQL Server databases using sp_MSforeachdb along with several examples of how to use it.

One problem that you may be faced with is the need to find text data that is contained in a larger set of text. There are two ways this can be done either using the LIKE operator or by using Full Text indexing. Let's take a look at some of the options o

In a recent tip (Accessing the Windows File System from SQL Server) options were outlined to capture files from a specific directory into a temporary table or table variable for additional processing. A similar file operations task that is needed in part

In your earlier tip (Die Sucker - Killing SQL Server Process Ids (spids)) you outlined an option to kill spids (system process ids) to perform database restores or database maintenance when exclusive use of the database is needed. Do any other options ex

Learn how to use the SQL Server KILL command to stop a SQL Server process from running.

Learn how to execute the same batch of SQL Server commands X number of times using the GO command.

In this tip we look at a SQL Server script that we can use to lookup and replace words in a table.