Yes, you can set it on the destination for SQL Server in the advanced properties or right on the OLE DB page.

CEWII

You can only access assemblies that are already added to SQL and a couple others, so basically you can't just reach out and access any DLL in the file system...

I'm going to make a guess that your SQL 2005 was 32-bit and your SQL 2008 is 64-bit..

Unfortunately I am not aware of any way around this using the OPENROWSET...

I'm with Gila on that. I have done that many times precisely because it is not part of the transaction. You just have to remember to write it...

What you'll most likely see is enhanced performance, especially in SSRS with large result sets. While SQL 2008 has the major version number of 10 it is really (IMO)...

Yes.

The question I have is how many servers are you monitoring. Most people with more than a couple use SSIS to query WMI. It is also important to...

Not really since both have been rolled into a single tool. But in reality if you have access to Query Analyzer you can do almost everything that Enterprise Manager...

If you are looking at OLAP are we to assume SSAS or equivalent? Are you going to be building that directly from the operational systems?

CEWII

The file could be corrupted. Have you tried opening it with profiler? If it opens there it is unlikely that it is corrupted.

I did notice you are using...

You could use sp_addmessage..

CEWII

You might need to apply Visual Studio SP 1 as well since BIDS is Visual Studio..

CEWII

samsql (11/29/2009)

---

Hi all,

we are useing sqlserver 2008

i have one login dttl has sysadmin rights for which i want to enable audit log for every thing which is done by this...

You either have a corrupted install or insufficient rights. The error is NOT from SQL server it is a .NET error..

CEWII

Yay!!

CEWII

We had a BIG discussion on this recently.

http://www.sqlservercentral.com/articles/IPv4+Addresses/67534/

Be sure to review the discussion..

http://www.sqlservercentral.com/Forums/Topic768952-1617-1.aspx

CEWII