I agree with Andy, buld a small exe and have it do the processing. Just have your trigger put a record into a table that the exe looks at for...

I prefer to use a logging table instead. Simply insert the records into the logging table and then when you want to check the status select from the log table...

Check sp_help_job.

The only way I know of to do this is to use xp_cmdshell and call osql. Rather than doing it this way I usually use a batch file to run...

Fred,

I think we need more information on this. Are you saying that on Server1 you used SQL_Latin1_General_CP1_CI_AS as the default when you set up SQL? And that on Server2 you...

I would do this with a couple of jobs. First create a backup device for your log, then create a job that will run your trans log backups (Look at "BACKUP"...

I've never actually run across this. I wonder though if it is due to you not having a primary key on the table?

Can you script your table out for us...

Look at sp_start_job and sp_stop_job. You should be able to start/stop the replication agent job with these.

You might also look at using OPENDATSOURCE and simply inserting the data directly into an XLS file.

To retrieve data...

---------------------------------------------------------------------------------------------------------------------------------

-- TODO: Make sure to change the name/path of...

Depending on if you have permission for xp_cmdshell you could alter Richards print statements to call xp_cmdshell and print the line into your file.

DECLARE @ctr int

    , @Cmd    nvarchar(255)

SET...

Hmmm... Why do you say it is using too much tempdb? With all those subqueries I'm not surprised! As Ken stated it would be nearly impossible to do the analysis...

Try something like this....

SET @var = REPLACE(@strWord,'''','''''')

Then build the rest of the string.

If you return the results in Query Analyzer to a grid you can then save the results in CSV format. Unfortunately you can't save the column settings that way. Another...

If Jonathan's suggestion doesn't work use xp_cmdshell and call osql with the command.  BTW: That will also work even if you need to do it on another machine

I agree with Keith on this. I think I would make a new table or add a column so that the abreviation of the region could be mapped to the...