I don't see create linked server in BOL under the list of events that DDL triggers can fire for.

RedGate (link at top right of this page) has a product called Refactor that can help with that.

Look up Apply, specifically Cross Apply, in Books Online. That should do what you need.

With that, you can use a value in the main query/table as an input parameter...

riix (8/12/2008)

---

Grant you seem more stressed than Gail; the point of discussion was Gail earlier stmt:

"Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones...

rbarryyoung (8/12/2008)

---

Wow. This obtuse defense of cursors and RBAR has more hand-waving than a Michael Jackson concert. Practically every other post here has statements to the the effect...

Tom Garth (8/12/2008)

---

GSquared - You are right about not leaving loose ends. I was referring to scripts that were on their way to being procs. I use the GOTOs to...

Yep... I agree... will usually cause a recompile even if all the DDL is at the beginning... the goal is, if you're gonna have one, just have one... moving all...

In my tests, the exact same select written as a CTE and a view performs identically for both. Which makes sense.

vlad (8/12/2008)

---

Nope. Implicit conversion can be a problem on just about any data type. Elimination of implicit conversion would be the only way to handle that, and implicit...

The first ten years of my adult life were spent in a company with very tight security standards. Since I was one of the people who was enforcing those...

You can also escape the wildcard characters with square-brackets.

where col like '[_]'

or

where col like '[%]'

Haven't run into WSquared. No clue who that would be.

I have run into another DBA who likes to use GSquared. And in high school, I knew a guy...

He mentioned late...

Jeffrey Williams (8/11/2008)

---

GSquared (8/11/2008)

---

I just ran my unmodified code on my machine, and got Jan 31, Feb 29 and Mar 31.

The difference is probably where your Numbers table starts. ...

Jeff Moden (8/11/2008)

---

...The biggest problem I've seen with Temp Tables is where people do a CREATE or SELECT/INTO in the middle of a query. If you look at some...