PaulB,

that is interesting approach. So, you are delivering to any customer, irrelevant from his needs, a framework which is based on a predefined “Information Factory"? Wouldn't it lead to a...

In order to agree on definitions...

Does it mean that what you are saying should be translated to: "When I am designing a data warehouse, I am not basing my architecture...

Let's forget about my previous experience of implementing relational reporting warehouses.

Desided to follow your kind advice. Did a brief investigation... I have to disappoint you.

1. Most of the people are...

1. Thank you for the code.

2. It wouldn't be extra to mention that this code will not work in SQL 2000 🙂

In ideal world? Yep. In reality? ...

After all: the design of the DWH will always...

So, according to a Kimbal Group "...the data warehouse is the platform for business intelligence..."

Or, in other words, a "buzz word" is another "buzz word". (Sounds like a Campbell definition);).

I...

If ANSI_DEFAULT are OFF on the server level, ANSI_PADDING in trigger will give you an error message.

Based on origin of your question and some of your remarks, I am assuming that you simply did not add linked server to begin with.

Do you have a linked server...

Why is it "unfortunately"? It is called job security.

Do you have Windows firewall on your local PC?

Can you try simply opening Windows explorer and type there a location of file with \\ networkcomputername\sharename? (and it is a back...

Don't do mapping drives!

Do it in the syntacs I gave you before:

\etworkcomputername\sharenamewitheveryonegrantedrights\filename.mdb

Repeat it for E:\Saminfo.mdb

From BOL:

"When you execute a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query. This four-part name should be in...

So, in the second statement then use

GRANT ALL ON VIEWNAME TO PUBLIC.

Try this:

remote connect to the SQL server machine.

Go to the Query analyzer and execute following code:

use databasename

go

grant execute on sprocnamethatyoucreated to public

Exit from remote console. Return back to your local...