You can also try a print statement:

print @sqlstring

The advantage of this is that you don't get the dashed line above the output.

-n

Normally, typos don't bother me but this one took me a minute to figure out what you meant. In the explanation, you write:

The ENCRYPT() function will perform a one way HAS...

You can use clustering or network load balancing (nlb) to setup a virtual server which references both. Traffic is directed to the virtual server, and the method you use determines...

Very cool! I hadn't thought of building a statement and then executing it. I was trying to pass the value directly to sp_trace_setstatus and it just didn't like me.

I think...

Thanks for the suggestions. I've seen solutions on this site before which use a select statement to do some complex things (for example: select @output = @output & "," & input from...

Going back to your original question, are you missing anything, I ran into an Active Directory issue when we changed the account the MSSQLSERVER service was running under. You need...

Forgive me for being thick, but this sounds counter-intuitive. I realize that there is no guarantee that the stop and start will happen at exactly the same time no matter...

I'm currently setting up the stored procedures and scheduled jobs to handle it automated. My plan is to setup a stored procedure to define and start the trace to run...

I am a big proponent of flexible policies. I would recommend keeping the non-unicode requirement but putting a provision where if the business case warrants it (and is approved by...

Is there any way to change the file name once the trace has been created, or do I need to do an sp_trace_setstatus @id, 2 and then sp_trace_create?

Thanks,

Nancy

The only problem with waiting is that we're not collecting tons of data. Our main goal is to audit the application vendor and maintenance work, which should generate only minimal...

Try one of the following:

floor (1.2345678 * 100) / 100

round (1.2345678, 2)

With this example they give the same answers, but if you use 8.7654321, the first one will return 8.76...

Have you checked to see if the backup file actually has data in it? If a backup fails or is interrupted then the backup file could still exist with no data...