Can it be related to this?

http://support.microsoft.com/default.aspx?scid=kb;en-us;310882&sd=tech

Thanks for replying Jeet,

a) there's nothing in the event viewer

b) It fails on the "EXEC @rc = sp_OAMethod @lFolder, 'Size', @lFolderSize OUT" line.

c) The path...

You can do it with something like:

INSERT INTO #Author

SELECT a.*

FROM OPENROWSET('SQLOLEDB','localhost';'sa';'abominable',

   'SET FMTONLY OFF; exec pubs.dbo.xml_test;') AS a

But it will end up in binary because XML AUTO returns a...

Take a look at the SQL2K ressource kit. There used to be an ODBC Ping utility in there (or something similar).

Eric

Thanks Brian!

I knew they were only in master but were usable in each db (aka sp_ procedures) but your idea with OPENQUERY...

Hi Midan,

I've seen a sp do this with sp_OA procedures. It's ugly and the end result is a Word document, not RTF. You better do this with an external application...

If you don't mind some overhead, make an external call that can't be enrolled in the transaction. Some examples that come to mind are:

- a DTS package

- a direct call...

>the only difference ...

That's what I meant. I also tried accessing views owned by other users (not DBO and not INFORMATION_SCHEMA) and it works. Also tried upgrading MDAC on both...

I reproduced the problem and I think it's a good candidate for a SQL (or MDAC) bug report.

Steps to reproduce:

a) I used an already...

Have you tried using DTS instead? You can keep using your vb script and you can execute a DTS package from a SP. I used this once to collect info...

Thanks Ed,

>about 2 hours to re-sync even though only a few MB of data has changed. 

Oops. We also have a few dbs but also about 1.3 million files to keep...

It depends on what you are doing with the data you are reading. If it's only for display (e.g. a monitoring tool) it's not too bad. Don't base an action...

There are multiple ways to do this. You could have SQL post to a web service for example. But I would recommend MSMQ:

- trigger calls a DTS package

- DTS package...

quote:

---

quote:

---

Was surprised not to see any question about SPN and kerberos authentification.

---

I enjoyed the test.

Was surprised not to see any question about SPN and kerberos authentification. This is one of the more confusing aspect of sequel security.