::FN_VIRTUALFILESTATS doesn't work in Sql2k critical

Hi everyone,

I perfectly know that this post is bad allocated but it's a critical one. We've a cluster and there it don't get rows.

I'm trying this sentence: SELECT * FROM ::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not?

However from other servers it returns data.

Thanks for your time,

Have you tried examining query execution with SQL Server Profiler?|||That's a good idea.

** critical issue with SSIS ** Please help!

Hi all of you,

This post is related with this one, previously opened:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=620243&SiteID=1

Moreover, this post is related too (IMHO) with

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=430406&SiteID=17

Following with my research I've seen that DTS.DLL is installed on:

1)My root c:

2)%systemroot%\system32

2)c:\archivos de programa\...\90\

3)c:\archivos de programa\...\80\

It seems that BIDS is trying to call, at first, to this COM CCW component.

So that, all has been deleted phsyically from my workstation and unregistered.

Sql Server 2005 full installation again and... the problem lives yet.

I'm desperate

I'm afraid I cannot help, never seen this issue, but if it really is that important I'd strongly recomend you contact MS Support. It will be easier for them to diagnose a problem with you in real-time over forum posts.|||Thanks Darren