Sure, here it is.

CREATE PROCEDURE usp_DailyQMSTrace

@sec int = 600,  --Duration in seconds for the trace

@TraceID INT OUTPUT

AS

-- Create a Queue

declare @rc int

declare @QMSTraceID int

declare @maxfilesize bigint

declare...

Thanks for all the input. I ended up using profiler to create a trace template script. Then incorporating it into a stored procedure which passed in the number of minutes...

Do you know where I can find a sample of a trace script. What i am after is to run this as a job via xp_cmdshell which would execute the...

This function is called from within a update trigger. For instance let say I have 1000 respondents that insert into the respondent table. This update trigger which runs the function...

I know that. It's just xp_SMTPmail is what I have to work with. They do not want to install a mapi client sio I am trying to work with what...

Thank you for your response. i tried doing this way but it dies on the first row. I need the ability to loop through a bunch of rows without using...

I think its more to the point if a job fails (be it a sql statement or standard backup task). I want to work more or less like SQLAgentMail works...

I guess I missed a part, that when the stored procedure runs there is a select statement that utilizes an IN clause such as

Create Proc spname

@i1 int,

@i2 int,

@i3 int

AS

Select name...

Thanks. I used that but it not quite what I am after. Maybe I can disect the Sp_helpuser SP and get what I am after out of it.

Where going with the turning the options to Comma delimited but with the addition of double Quoted identifiers (""). I can't seem to fine that option. Any ideas?

Journeyman,

If I turn the options to

Tool --> Options --> Results -- > "Result Output Format (*)" ='Comma Deliminited CSV'

and make the output type as TEXT. as

you suggested....

This works great up to the point where the column is an integer:

COALESCE(yourCol, '') + ','

And ideas?

They want to see the visible results fro Query Analyzer otherwise I would have just DTSed it out.