Steve -

I'm sure you are giving a "bute" paste (or horse aspirin). Ask your vet for the flavored powder. I find that apple flavored bute powder works well. We...

I'm sure someone at M$ knows why 😀

Let me preface this by stating that I am not an IS expert. My packages are fairly simple.

I prefer the file system with the caveat that it is backed up...

I wouldn't do this in TSQL. Most of the posts have DMO examples but you will need to use SMO since you need it for 2K5. Write it in one...

MS will not produce a 64 bit driver...

Hi Kreecha,

Since the vendor is making...

We use Compliance Managere and it uses a server side trace which is very light weight. It is very rare that it will hit 2% of CPU in Task Manager.

OK - I did this on 3 64 bit servers and they all work.

1 - install the 10g client (.3 version is what I installed)

2 - install the ODAC...

By default, DTS samples the first 8 rows to determine the column size. If you use the Disconnected Edit, you can tell it what the column sizes will be and...

I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The developer said that he needed to use OLE to talk to Oracle so I...

here is a link I found for troubleshooting WMI Security:

http://blogs.technet.com/askperf/archive/2007/08/14/wmi-troubleshooting-permissions.aspx

By default, sysadmins have full access to WMI. I really don't know where to point you if you have sysadmin. Have looked at the MSDN forums?

There is one other thing you can try. It may be a simple case of "refreshing" WMI.

You need to be a sysadmin on the server for this. From the...

I have a problem with WMI Alerts in SQL Server that throws the same error message. I opened a case with MS and it turns out that the sqlwep.dll has...

I just tried it and was able to establish a connections and an Execute SQL Task.

I'm not the best with DTS so I don't know what limitations you may...