uuuugggggghhhh!! (Funny though)

How is remote connection configured on the SQL 2008 instance?

If it's Express edition, keep in mind that the default is shared memory connections only, and you have to turn on...

Bing had some good answers on that one, if you want details. I assume Google would too.

Basically, it's part of data modeling.

Jeff Moden (11/10/2010)

---

As I said on that post... now I know what a feeding...

Add "('Email')" after "RAW" to Wayne's code and it'll put that tag in there where you want it.

Adam Gardner (11/10/2010)

---

Ever been to Seattle or Houston? They can add lanes to a highway without land acquisition costs (double deckers).

Land acquisition cost in the Denver area is one of...

What precisely is a "temp column"? A column in a temp table?

Allow Null/Blank simply allows those. If you don't want to use one of them, I believe you need to set a default value for it.

I don't know, but I know MS SQL won't allow remote object creation like that. I seriously doubt Oracle would. That would be a huge security hole potentially.

Default trace...

To be fair to the owners of this forum (Red Gate), they have a comparable product too.

I've used it and the Apex tool, and both will get the job done...

Adam Gardner (11/10/2010)

---

Steve - Ever try to ride your bike to work via Bus/Train in Denver? I have many times. It's a nightmare. Arrive at work sweaty - no place...

If you need to return zeroes for combinations that don't show up in the measure, you need to write it as an inline sub-query.

They look like this:

select a, b,

...

Stefan Krzywicki (11/10/2010)

---

If everything on the...

Do you need the line number of the code (the query), or of the data (the results of the query)?