Lowell (3/3/2011)

---

ok, still not an issue; read the file from the database, and recreate the view as needed:

--we want the current trace folder

...

Lowell (3/3/2011)

---

what i would suggest do is on the server itself, create a VIEW that selects the data from the trace; the view would run under the context of the...

You are correct sir!! I was using old syntax. Thanks!

Thanks for the article. We plan to ETL the CDC data on a nightly basis. Nevertheless, I'm put off by the fact that we can't add columns to...

Nope, no fear of abuse....

We uninstalled all SQL components and reinstalled via the GUI. Worked like a charm.

Weird.

I tried it using both trusted connections(as a sysadmin) and with the sa login/password. Both ways result in the same error.

I saved off the query in a trace, and...

I'm running into this issue as well. What are the settings that would cause the query to parse and run, but err out in the DTA.