Hi,

Do you have an example of the FSO syntax that I could use please?

Thanks

Hi,

I believe that xp_logevent logs a message rather than returning existing messages. I have found xp_eventlog but cannot find any documentation relating to it. Does anyone know what this sp...

Although the following syntax will insert the results of the sp into a table, how can I append another value to the result set?

INSERT INTO tblTest EXEC sp_who

For example, if...

I've found the answer to one of my questions, for the hard disk space use:

exec master.dbo.xp_fixeddrives

My Select statement already contains rtrim(task_attribs.string_value) in the Case statement.

Thanks Vasc but I don't understand. Is the RTRIM causing the problem?

Ok, thank you both for your help anyway.

Regards

David

Hi Govinn,

Will any of these sps allow me to edit SQL Server registration properties (right click on database in EM)

Thanks

Thanks to you both, Alzdba's suggestion is working so I'm using this for the moment until I can determine an exact maintenance plan to utilise.

Regards

David

Yes, it is our test server and no-one else is connected or working on this.

Works perfectly! Thanks Jesper!

Chris,

Just completed the move, had a couple of problems but it seems to have sorted itself out. Thanks for your help!

Hi Noel,

The column name is being specified when the sp is run by giving @Month the appropriate value. Could the problem have anything to do with the sub queries I'm...

Thanks for that but unfortunately the problem is still there. Just for information, I'm running the sp from Query Analyser.

It's not so much the message that not working, when I run the sp the second table is not updated (checked by querying the table). When I run the statement...