I've written code to do this - getting all syscomments text, that is - so if you'd like the code, PM me.

The code is a sproc that builds a table of...

As a follow-up to Kevin's post, this is something I did recently to provide a search facility where I work.

I've got a sproc that creates a table containing all the...

You should be as independent as you were before the sale.  Naivety aside, that's the simple answer.

I've never had a problem with the advertising, because it's so well focussed.  I...

Congrats to Steve, Andy, and Brian.  You've been responsible for creating the best MS SQL site on the t'Intermaweb, so congrats on your success

I'm glad there're people like you to do this stuff for us - nice article

A comment about the VB code.  I think it's...

If I don't have a need for the product in question at the time, then I almost certainly won't bother visiting the site or downloading a whitepaper etc.  And if...

It's often easy enough to find similar suggestions on different sites, and that's usually enough to convince me to give something a try.

Obviously, I test this stuff on something other...

I love my Sky Plus TV system because it's so easy to record stuff and then fast-forward through the ads.  Sometimes, if I want to watch something when it's actually...

I work 08:00 to 16:00, Monday to Friday.  I'll work extra if I need to, but that is rare these days.

When I was a programmer I worked more hours, trying...

The site's excellent and the ads don't bother me.  I just tried out the page peeler, and it's fine, because as soon as you move the mouse away the page...

My biggest regret would be not having had the courage to start my own company.  I've got a lot of good skills and experience with software development and databases etc,...

We identify sources of data by using a column called SourceSystemID.  This links to the SourceSystem table which lists all our data sources.

Our data warehouse tables - well, it's more a...

Our Access apps create the DSN on the user's PC when the app starts.  It's a neat enough solution, but I think the other suggestion of a DSN located on...

Having two phones, one with goodies and one without, would be a major pain.

I love my camera phone.  It also has an MP3 player, contacts, diary, organiser, games etc.  I...

I've fallen foul of this before when trying to parameterise certain aspects of DTS.  One thing to check is that your transformation task - if you have one - is...