Have you tried using the MSDAORA provider instead of MSDASQL?

Here is a tutorial from 2006 that should still be relevant for SQL 2008.

Ground Game

A related, recent post:

http://www.sqlservercentral.com/Forums/Topic1375169-364-1.aspx#bm1375221

I think SSDT 2012 (built on VS2010 Shell) is still only available as a 32-bit app so if using an Oracle ODBC driver you'll need to create...

When compiling a statement, if table referenced in the statement exists then SQL Server will validate the columns in that table, else it will employ 'deferred name resolution.' You are...

Jeff Moden (11/2/2012)

---

+1000 Orlando. Very bad use of xp_CmdShell in this case. And, if someone kills the spid that makes the call, it can't be killed unless you...

WMI tends to be a bit trickier to get working than some other methods due to security and the syntax of the WQL.

This method, which uses a .NET class, is...

I know you checked, but all I can offer for the error is that the times I or myself have experienced the 'Invalid Parameter' issue it has been related to...

ACTION ITEM

I'll throw one other technique out there that I use quite a bit. It may not handle things like verifying someone can see something in Object Explorer that they think...

OK, I think I arrived at a possible explanation of what is going on:

Chances are the Server Proxy is not involved. I think we can attach a remote file when...

I had to try it for myself so here is your code ported to C#. It worked as advertised for me:

[font="Courier New"]using System;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

    [Microsoft.SqlServer.Server.SqlFunction]

    public...

The written word...

I cannot recreate the issue on 2008R2. I'll try it on 2012 later, but to make sure, what build # are you on?

bcp -v

should tell you

And when you say "below...

sunny.tjk (11/1/2012)

---

opc.three (10/31/2012)

---

sunny.tjk (10/31/2012)

---

I can think of DENY SELECT but not sure how to implement it. I'd like to accomplish DENY SELECT to everyone except to the members of the...

steve.laforge (11/1/2012)

---

I thought you had it until I tried to add it to a function. Then I get the error 'Invalid use of a side-effection operator 'INSERT EXEC' within...