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)

2008-01-07 (first published: )

8,161 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Designing a table

By Johnson330

I have a scenario where: a company can have many workers(01,02) & worker can...

How to take offline backup in sql without interrupting Application connectivity

By pols

Hello All, My requirement is to to take full backup of the databases in...

Returning To An Employer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Returning To An Employer

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers