Robert Cary

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)

2008-01-07 (first published: )

7,939 reads

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)

2006-10-20 (first published: )

537 reads

Blogs

Redgate Software Needs You!

By

I’ve been very blessed to be able to work for Redgate Software. We’ve done...

Extended Events: Database Auditing

By

Extended Events can do things that simply are not possible with Profiler and another...

Speaking for Omaha Azure User Group Wednesday

By

This Wednesday, February 26th, I will be presenting a new session entitled “All Things...

Read the latest Blogs

Forums

Time for a New Adventure with Redgate

By Kendra Little

Comments posted to this topic are about the item Time for a New Adventure...

Introduction to Indexed Views in SQL Server

By Archana

Comments posted to this topic are about the item Introduction to Indexed Views in...

Any way to find the name given to a session\'s local temp table?

By TheGreenShepherd

Someone made a change to the code base, inserting a bunch of records to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers