I have not tried this but almost any data source that has at least an ODBC driver can be reached thru linked server. I seem to recall VSAM being done...

Unfortunately we run the two that can here. But you are right Standard does not support indexed views.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Sounds like an assumption piece programmed into Access.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

No offense, I am a lowsy writer and I know it. In fact I usually have my wife read over important stuff first before I email or put out.

"Don't roll...

Could be virus or a hacker. There is a worm on the net going around in regards to SQL. I suggest you get in touch with the Admin of the...

I also need the tally table. But you big problem will be your subquery. a SET SHOWPLAN_TEXT ON to get the execution plan would be helpfully to give a good...

quote:

---

For our applications we have legal requirements to keep a full audit trail, including data retrieval. Also, we need to be able...

Ok try this. Open Services Control Panel and find the Analysis Services item. Right click and choose properties. There you will find path to executable, open Windows Explorer and drill...

My opinion is apply, even if they don't take you for that posiiton the networking is to your bennefit. Soemtimes they even have unposted positions open that they may look...

How are you retrieving the error returned? What Call are you making?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

First let me thank Andy for a bit of clarity on somethings. I appologize that is not my strong point. Now for

quote:

---

Another...

Just as a affermation. We tested breaking a database into year databases but some reports are based on three years. Each contained at least 50000+ records and we saw no...

If she is pulling a wrong record and you can tell from the data it shouldn't have pulled then the query would have to have been the issue. If the...

%1 is a replacement position. I would suggest try uninstall Analysis Services and reinstall first to see if the install flaked. Then if same problem let us know.

"Don't roll your...

One possible way you could handle this would be a trigger. Just a thought but you could try something like.

CREATE TRIGGER tr_CheckChanges

FOR UPDATE

AS

IF NOT EXISTS (SELECT * FROM inserted i...