Have you tried using the HOST_NAME () function to identify the connecting workstation?

> Did the change come from a stored procedure, or was it manually (or Enterprise Manager) changed?

I don't...

Sometimes developers raise the objection that, since C++ runs a gazillion times faster than T-SQL, that's where the data manipulation ought to take place.  The viewpoint is that T-SQL is fine for...

So you can't change the code of your procedure?

I guess I don't understand why you need to use the IN <list> approach to get what you want.  The method I...

I notice in the example that each value contained in the parm is delimited by a single-quote.  Could this work for you?

SELECT *

FROM dbo.MyTable

WHERE...

My personal experience with Idaho predates my experience with computers.  I was, once upon a time, a trombone player in an Air Force band and we spent a weekend at...

It was defense-related.  Speaking from personal experience, defense contracting firms tend to have a corporate culture that enshrines cravenness, and this attitude trickles down to the techie level.  Sometimes, I'm...

Well, okay, you asked for it.

There was, e.g., the time my boss asked me into his office to discuss a new database we were designing for our customer.  My boss,...

It's a great place for music, though.  How about those Back Street Boise?  🙂

> Nice quote... can I print it and use it next time I get this "problem"

Absolutely.  My copyright has expired.  🙂

Usually, I also add: "The real complexity is in the...

> Why should they tell you how to code the app?

Why?  WHY!!?????!!?????

<cool jets><calm down><breathe normally><check pulse>

It's because of rule 1 about databases:  everybody thinks he's an expert.  It would...

> I am being sarcastic but I haven't heard one good reason arguing in favor of case-insensitivty. Every complaint has been seemingly out of SHEER LAZINESS....

That seems like a perspective...

> There's a certain HR package that I've grown to loathe that requires case sensitivity. Grrr!

I'm guessing that I could name that HR package.  🙂

Maybe I'm wrong about this,...

This post is a year old, but I'm still going to respond, as I think the points I want to make are still relevant.

> Scorpion_66:  I have worked extensively in...

Thanks for the response, t.!  Also for the VB script.  I downloaded something from Microsoft called 'Component Checker', and if it can be trusted, I now have things under control.  (Your...

Thanks for the response, Steve!

> Steve:  "To get your (parent-child) dimension working as per the tutorial, go to the Properties of the dimension (in dimension editor), make sure that 'Write...