maddogs (12/17/2008)

---

I have nothing related to the technical aspects of this article that haven't already been said, but I too have to take exception 😛 on the art of fletching...

The best way I can think of is to use the sqlcmd.exe. That allows you to format the output pretty much any way you want.

1) I think you're in it.

2) I'm pretty sure Steve makes them up as he goes along. You'll notice that 800 and 8000 both say Crazy Eights or something like...

Well, actually, I prefer C#, but I also think that there's a critical mass behind it now that wasn't there until the last year or two. But now, yeah, that's...

Matt Miller (12/17/2008)

---

Grant Fritchey (12/17/2008)

---

Google & BOL aside, they've managed to find their way to this site, navigate to the forums, type their question.... Didn't even a one of them...

It's in keeping with what I'm seeing. Our company has started switching over to C#. The newest project starting development is going with C# (and nHibernate, but that's a different...

Try changing the exeucte to

EXEC sp_executesql @backupString

and using an NVARCHAR on the backupstring. I tested your code several times that way. It worked finel.

Jack Corbett (12/17/2008)

---

GilaMonster (12/17/2008)

---

Grant Fritchey (12/17/2008)

---

It was my understanding (and I couldn't find what it was based on if you paid me) that when running a server side trace...

Jonathan Kehayias (12/17/2008)

---

Grant Fritchey (12/17/2008)

---

Google & BOL aside, they've managed to find their way to this site, navigate to the forums, type their question.... Didn't even a one of them...

Jeff Moden (12/17/2008)

---

GilaMonster (12/17/2008)

---

I suspect that some do, or think that we work for SSC. I recall someone apologising...

For the very little it's worth, that's pretty much in line with my understanding of the process.

The only point I'm not sure about is the buffer when you're using...

Ha! At this point I don't see a need for it for anything except resume padding.

I don't have a good resource for it yet. I've been floundering my way through...

Can you generate and post a couple of execution plans? That will help show what's happening under the covers on your system, with your data.

This will help if you haven't...

Personally, C#. It's what all the cool kids seem to be doing these days, so it's more likely to allow you get jobs and/or recruit people into the jobs you...

Fraggle (12/17/2008)

---

Thank you both for the reply.

Gail, are there any articles you would recommend on using server side traces?

Grant, you are correct. I did fail to mention...