Grant Fritchey (1/12/2012)

---

David Burrows (1/12/2012)

---

DeanORenO (1/12/2012)

---

I like all the interpretations of my question but still no answer. I imagine if I asked the question what is 2 + 2, I...

David Burrows (1/12/2012)

---

DeanORenO (1/12/2012)

---

I like all the interpretations of my question but still no answer. I imagine if I asked the question what is 2 + 2, I would get...

GilaMonster (1/12/2012)

---

GSquared (1/12/2012)

---

I was actually looking at the discussions on my audit trails articles just yesterday. Posted those articles in '08. Wow! They definitely needed a lot...

It's not what you do but how you do it.

This might clear your mind : http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Re-reading this after the fact I could have used more tact here. Nothing wrong with asking questions to stuff you don't know.

Please continue to do so and I'll adjust...

Because a lot of the right answers are actually wrong or incomplete.

I always hated those super beginner questions.

Ah, 2 years old thread.

There's another answer, in the subscription use @TIMESTAMP to output the date and time of the file. It's perfect but it's pretty good and answers...

mw112009 (1/10/2012)

---

Both of you are heading in the wrong track. The owner of this topic wants to know whether a file delivered via SSRS can have a dynamic file name...

SQLRNNR (1/10/2012)

---

Ninja's_RGR'us (1/10/2012)

---

Hey guys, what ressource can you recommend for worldwide list of countries, provinces, zip code, etc. The more the better. We ship to over 100 countries...

Hey guys, what ressource can you recommend for worldwide list of countries, provinces, zip code, etc. The more the better. We ship to over 100 countries so the...

That's what the activity monitor runs. It has some decent info that (might) complement sp_whoisactive.

--Borrowed from the activity monitor

SELECT

[Session ID] = s.session_id,

...

kwoznica (1/10/2012)

---

🙂 Ok ok....I'll read through it. I can see the benefit of it after running it and I'll dive into it when I have more free time today. I'd...

Yes.

I think Gail as already covered this.

SELECT path from sys.traces

--C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_671.trc

If you don't see it on the folder maybe you don't have permissions?!!? I can't think of...

GilaMonster (1/10/2012)

---

Yours are just in serious need of a scientific adviser. Mine are...