Steve Jones - SSC Editor (2/22/2011)

---

On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not...

Okay since we got this cricket thing on twitter, Venzann, posted this link, http://il.youtube.com/watch?v=C9STtcwo0xE, which helped me understand a little bit more about cricket.

There is no way that I know of to capture the triggering SQL Statement within a trigger.

I'm pretty sure you'd need to have a server-side trace running or perhaps use...

Interesting. I was going to posit that it was being called by another job or process.

george sibbald (2/18/2011)

...

Before a game can be over for the day the side that is not 'in', has to bowl a minimum no. of overs. The game lasts up to...

george sibbald (2/17/2011)

---

Koen Verbeeck (2/16/2011)

---

Jeff Moden (2/16/2011)

---

CirquedeSQLeil (2/16/2011)

---

For the execution of Wayne:

--get spid of code requestor

sp_whorequestedcodeIntheThread 'Wayne'

--use returned spids to verify the request

dbcc inputbuffer(61)

--output

'Wayne definitely requested code on...

I don't know!

No. SQLCompact 3.5 is a set of DLL's that do not require IIS. Once you have SQLCompact installed you can use any .NET language and type of project...

You should be a DBA :-D.

I agree with you that direct table access is evil. Most developers I have worked with or interact with now, will tell you that...

I had assumed that which is why I answered with 2005+ features. ...

I don't have the answer for the OP and I'm guessing she got it since the thread is from 2008, but you can get some of the index usage from...

GSquared (2/9/2011)

---

Jack Corbett (2/9/2011)

---

I probably wouldn't use a view because I like to use SP's for all data access so the query would just go in the SP as is,...

jcrawf02 (2/9/2011)

---

Anybody have suggestions (blog/thread/article/advice) for me on how to find whether a value in one column contains a value in a different table's column?

Currently I'm doing this, but...

It isn't clear to me in the earlier posts if you have attempted to issue an explicit CHECKPOINT command?

I might get crucified for suggesting this because I have no experience...

I probably wouldn't use a view because I like to use SP's for all data access so the query would just go in the SP as is, but I know...