Excellent!

One last question....

The results (Query Analyzer.... text results) return...

synopsis                                                                                            

------

Residential

Rural

(2 row(s) affected)

Residential,Rural,

I only want to return Residential, Rural to the calling function.

How can I supress the earlier result section? I...

sounds perfect!

Are you able to share the it of code you are referring to please as I've never used/tested for @@rowcount....

select foo from bar

if @@rowcount > 1 then foo =...

Hi Phil,

Sorry I didn't explain as well as I could have.

There is only 1 text field in the select statement. The commas are needed if the field has more than...

Answered that one meself too.

EM, right click packages, versions, delete.

I'll have RSI by the time I delete this lot!

many thanks for all your help Phil.

234 versions!!!

Is there a way to weed out the intial 233 versions?

This is a feature/annoyance(?) of DTS I was not aware of.

Is there...

sorry, ignore the Q asking which were non-user.

It occured to me to look(!!)

Doh! I did mean to run it in MSDB but my fried brain wouldn't let me!

OK this appears to be the culprit:

MSDB sysdtspackages pk_dtspackages 1217 657136 208

MSDB sysdtssteplog PK__sysdtssteplog__245D67DE 121237 30992 384

I wonder what makes it so large? Someone saved...

Cancel that! Was missing a space between 2 words.

Results show....

master syscomments syscomments 2168 7904 48

master syscolumns syscolumns 4956 1472 872

master sysmessages sysmessages 3769 1312 16

master HG_SpatialRef PK__HG_SpatialRef__77017CD9 951 688 80

master HG_SpatialRef_Saved PK__HG_SpatialRef__0C31A3E9 951 688 80

master sysobjects sysobjects 1421 352 272

master syscharsets csyscharsets 114 264 32

master sysindexes sysindexes 110 256 16

master sysdepends sysdepends 5545 232 200

master sysaltfiles sysaltfiles 91 176 16

master spt_values spt_valuesclust 728 56 80

master sysxlogins sysxlogins 197 40 48

master syspermissions syspermissions 896 32 16

master syslanguages csyslanguages 33 24 48

master sysdatabases sysdatabases 46 16 32

master SQL_Statistics SQL_Statistics 96 16 8

master sysusers sysusers 16 8 48

master sysfilegroups sysfilegroups 1 8 32

master sysservers csysservers 4 8 32

master systypes systypes 26 8 32

master spt_datatype_info datatypeinfoclust 36 8 16

master spt_datatype_info_ext datatypeinfoextclust 10 8 16

master spt_provider_types datatypeinfoclust 25 8 16

master spt_server_info serverinfoclust 29 8 16

master sysconfigures sysconfigures 38 8 16

master sysdevices sysdevices 6 8 16

master HG_OneRow HG_OneRow 1 8 8

master MSreplication_options MSreplication_options 2 8 8

master spt_monitor spt_monitor 1 8 8

master sysfiles1 sysfiles1 2 8 8

Apologies if that's hard to read....

Thanks again Phil,

That's throwing an error around...

ON sInd.[id] = SumIn.[id]

    , (SELECT v.[low] / 1024 as PageSize

        FROM master..spt_values v

        WHERE v.number=1 and v.type=N'E') as Pg

WHERE sInd.indid...

Thanks Phil.

To my (semi untrained eye) that hasn't unearthed a HDD stealing culprit.

Here is the results of running that for MSDN.

name                                                                                                                             rows        reserved           data               index_size         unused            

-------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------ ------------------...

Thanks all, I answer all (the ones I can) here...

Not the log, the log is only 450k.

MSDBData is (used space) 779MB!!

I've run select * FROM msdb..sysjobs and it looks as...

I haven't even looked at 2005 (beta) yet, I get the feeling I'll be left behind once it goes live. I'll get a chance to have a look when I...

true but we have 2 most important products/dbs each designed to live on their own instance

I googled for it after posting here (should have done that 1st!)

I see it's an EM bug.

Strange that I've never come across it (approx 18 months) and then come across...

Thanks, I looked at the trial version of Log Explorer and really liked it. It was a bit pricey though. Value for money you reckon?

It was the "per server" bit...