This may give you what your looking for:

exec sp_spaceused syscomments

and will yield:

name rows reserved ...

DTS data resides in msdb, so if that's being backed up, you should be fine.

Forgive me for speaking about SQL 2000 in this forum but that's what were running here. When we would replace servers, there is a table in msdb called sysjobs. By...

DOH! sp_configure returns all the characteristics of SQL. Amazing how much your mind begins to atrophy when your not using the tools!

Gary, A lot more detail is needed for anybody to attempt to help you. Such as:

1) What are you trying to duplicate, certain rows of data or entire tables?

2) What...

At the server running MSSQL go to Control Panel->Admin Tools-> Services. Find MSSQL (and any related SQL services running on the server, if needed) and double click the service. Go...

Cool, thanks. I was just going to download it. I appreciate the quick responses.

Sorry, I thought these only pertained to SQL 2005. I used these at my last company which had several 2005 installations and for freebies, thought they were great starting points...

I haven't seen it crash a server. I've seen an application be affected, of course. Did you contact Microsoft? When we had consistency errors, we were able to simply rebuild...

Any tape sweeps of the files running at this time? That one has got me a few times in the past where infrastructure was running automated tapes sweeps of my...

This may sound crazy but did you apply the service pack on the client machines? I once was bit by this years ago. Different clients, running different versions of the...

Thanks anyway. Found my answer. Amazing some on the things you can find in BOL!!:rolleyes:

Is there an easy way to do it? I have around 100 packages on one server and I'm, of course looking for the easy way around it as opposed to...

Lowell,

That worked perfectly. I do wonder how the case statement works as I am not seeing the valuew in your evaluation but it does come out with true values where...