Steve Jones - Editor (4/21/2010)

---

I have spoken with my boss, and in principle he thinks it's a good idea to help out here. Any preferences on what you're like in...

Yes. Make a hidden parameter. Then use a variable to build the sql statement to run, using this parameter as the where clause.

sergei.gorelik (4/21/2010)

---

My security team would like to run SQL traces on one of our database servers. How can I restart a trace after a reboot? Is there any other...

Lowell (4/21/2010)

---

am i reading this wrong?

i thought a server side trace starts when you run the command EXEC sp_trace_setstatus @traceid, 1, and runs continuously. rebooting or stopping/starting the...

Remove the hyphen between the date and time.

Wow. Stubborn as a rock also. I sure hope he hires someone to come in and secure it,...

You don't need to give admin permissions, all you need to do is to grant alter trace permissions. See this entry in BOL for how to do this.

CirquedeSQLeil (4/20/2010)

---

Steve Jones - Editor (4/20/2010)

---

I'll check with Red Gate tomorrow. In terms of sponsorship, I think we can do something. Not sure we want to host it, but maybe...

I also can do a few hours per week. By my count, this should bring it up to 7?

I recently talked w/ Andy Leonard, and he was very interested in...

CirquedeSQLeil (4/20/2010)

---

Lynn Pettis (4/20/2010)

---

Have I gone too far too fast? Just had some intellectual juices flowing and thought I better put it down be fore I forgot things (I...

CirquedeSQLeil (4/20/2010)

---

dma-669038 (4/20/2010)

---

I also suggest we keep the 'journeyman' and replace 'Microsoft Certified' with something else...like a 'SQL Server Journeyman' perhaps..one of the comments i got on the survey was...

Okay, take the code I wrote above.

Change the "year" to "qq" in the two date functions, and the select @min-2/@max to the appropriate table/column. Add some code to calc the...

You don't need wildcards to use replace... it replaces all occurrances.

i.e. select REPLACE('Hello World', 'or', '12') returns 'Hello W12ld'.

So, replace(columnname, 'XVD', 'SVD') would replace all occurrances of XVD w/ SVD.

I didn't know this... just tried it out, and it does work.

Your implicit conversion comment is incorrect -...

The group by clause (in your second nested select) is referencing a column that is in a table not included in the select clause.

You might be able to avoid the...