CirquedeSQLeil (12/9/2009)

---

RBarryYoung (3/15/2008)

---

Does anyone check these things?

It is really disturbing how many wrong answers there are. It also makes me wonder how the folks with over 90% right ar...

Oh definitely, but ASP code is just as editable...

Steve: (RE: SSC new site features/wishlist)

This is a perfect example of a thread or post that I would like to be able to tag or remember somehow....

vk-kirov (12/4/2009)

---

Something about this can be found in BOL, topic "Precision, Scale, and Length (Transact-SQL)": http://technet.microsoft.com/en-us/library/ms190476.aspx

We have two numbers of...

Oops, I completely missed that this is the SQL Sever 2008 forum! You can just pas the value as a table-valued parameter. That is by far the best...

For list-type parameters with multiple values in a single parameter, you're generally better off either passing them as an XML parameter or else using a #temp table instead.

There is no spoon.

Gianluca Sartori (12/9/2009)

---

Wow! Thanks Gail, I'm trying immediately on my production server. :hehe:

Would you also recommend (as a fellow expert) turning on these switches?

exec...

Are there any parameters on the real stored procedure? If so, could you show that to us?

Things to check:

1) use Task Manager "Processes" tab w/ Username & "Show processes from all Users" to see if it is *really* running under that username.

2) Look in the SQL...

What DEFAULT database did you assign to them and did you grant them access to that also?

Oops, never mind...:blush:

Jeremiah Peschka (12/9/2009)

---

I can tell you that PASS now supports non-PASS branded events. The person to talk to at HQ is Blythe Morrow, she's the community coordinator. There's been discussion...

Jack Corbett (12/9/2009)

---

Who are dealing with at PASS? I know Andy Warren (Lead for SQLSaturday and on the PASS BoD) well so I have an in there. I...

No it wouldn't. Users can use strikeout now, and there are...

For an example of an asynchronous trigger using Service Broker, see the demo code included in the ZIP file for my presentation, "The Top Ten Reasons Your Aren't Already Using...