It should be noted that Postgres releases their own native ODBC driver to connect, you don't have to use CData's driver.

It can be found on their official release page here:

I hope you managed to keep & maintain the Briefcase feature (with Tags) in the new version. I rely on that feature the most.

I'd recommend renaming the article to either "Output DBCC CHECKDB to a table" or "DBCC CHECKDB Output to a table", the title confused me into thinking it was something else...

Perhaps you could add to your article a query that finds untrusted FK's, also maybe even to dynamically generate the WITH CHECK statements?

In our environment, for our Type 2 Dimensions, we use [CurrentRowFlag] as a SMALLINT.

We use 1 for current row, 0 for inactive, and -1 for deleted (from Source).

This allows us...

Duplicate of:

http://www.sqlservercentral.com/scripts/Stored+Procedures/101475/

sgnewman (9/5/2012)

---

You need to change the provider when the job runs. It's running under the sqlserver:/ provider. Just do a cd c: at the top of your script...