Have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=175213

He provides a bunch of user defined functions that may help you out.

GilaMonster,

Thanks for pointing out the MS article, having an issue on a stage box that this cleared up a treat.

I used to have an issue like this when I was using quest spotlight to monitor some of my servers, I would issue a kill command from a script but...

Might be worth looking at log shipping.

it is most likely ascii characters, you should be able to use the ascii function in conjunction with the replace function to get rid of these. Should be...

Here's one suggestion:

convert

(datetime, convert(char(10), Put_Date_Here, 103

if you have a version of 2005 running on a machine other than production, why not create an sp that has the

exec sp_procoption N'procname', N'startup', N'true'

GO

set and have the...

look up xp_cmdshell in bol, the sql job will be an operating system type 

should be xp_sendmail

You can use LogParser (free from MS) to do a simple query of the event log and insert the results into a table. If you gather...

This is assumming that the null character is trailing, you will most likely need to rework this if the null catcter is anywhere in the string.

Try this, could probably write it in a loop, bit brute force but should give you what you need:

update

TableName Set ColumnName