Advanced Search Stored Procedure

The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful.  It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson.  I left in the original credits.  Excellent procedure.  Some may scoff but I place it […]

2004-07-15 (first published: )

513 reads

CSV Lists of Columns in Different Formats

This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements.  The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]

2002-12-26

196 reads

Blogs

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Read the latest Blogs

Forums

Log shipping performing log backups despite its backup jobs being disabled

By alexhdavies

Hi Came across an odd issue this evening. Running a migration over the weekend...

Granting Schema Permissions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Granting Schema Permissions

Lots of Data and AI Helping Firefighters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lots of Data and AI...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers