Haha - I was wondering who...

Revenant (2/19/2014)

---

Greg Edwards-268690 (2/19/2014)

---

Sounds like DBCC TimeWarp is starting to...

Greg Edwards-268690 (2/19/2014)

---

Sounds like DBCC TimeWarp is starting to warm...

Thanks

Maybe in 10yrs I can reach the SSC-Forever guild like Gail.

Alan.B (2/19/2014)

---

SQLRNNR (2/19/2014)

---

Great article. Very useful information.

One question I think could be answered and would be very useful to those noobs to CLR.

How do you get the varbinary representation...

Yay - I'm finally insane!!! :hehe::w00t:

While I recommend getting SP1 installed, I have been successful in working around this error by creating the maintenance plans from another machine that has SSMS installed. Just use...

To get a dynamic where clause you would need to use dynamic sql and execute that sql string.

Or you could have both queries and an if else statement. Based...

I don't know if they are hilarious or not, but I have...

Great article. Very useful information.

One question I think could be answered and would be very useful to those noobs to CLR.

How do you get the varbinary representation for the...

From the author of the book recommended by Gail, here is an article that talks about the formula and such.

http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

Best piece of advice there is this nugget

Don’t use the value...

drilling

What kind of task are you calling the proc from? Is it an execute sql...

caippers (2/19/2014)

---

All these answers worked so I thank you all. As to why I was doing the cross join... I'm new at SQL and that was the approach I...

As a follow up to Koen's question, is this occurring when you are running the package from BIDS?