Robert Cary

  • Interests: Sleight of hand magic, cycling, bowling, poker

SQLServerCentral Article

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.

4.8 (5)

You rated this post out of 5. Change rating

2008-01-07 (first published: )

8,337 reads

Technical Article

Find Nth Occurrence of Character Function (Set Based)

This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com

5 (1)

You rated this post out of 5. Change rating

2006-10-20 (first published: )

541 reads

Blogs

What Does Redgate Test Data Manager Do?

By

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...

Extracting PostgreSQL database metadata for presentation in Excel format

By

(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...

Change Notebook Spark Session Time-Out in Microsoft Fabric

By

You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...

Read the latest Blogs

Forums

case for 'DBCC TRACEON - Trace Flags'

By VAI

Please share a situation when enabling and taking further advantage of DBCC TRACEON -...

EXEC (@SQL) AT QASERVERNAME; Fails with read-only database error.

By sgmunson

All, Need a linked server guru.   Trying the following in a stored procedure: SET...

ACCIDENTAL DUPLICATE...

By sgmunson

Accidental Duplicate...  my bad...

Visit the forum

Question of the Day

SQL Express Agent

How can I run SQL Agent with SQL Server Express 2022?

See possible answers