Well, there's not a lot that I can tell without the erro Message, however, it's an odds-on bet that you are getting data-type errors. In particular, that whatever is...

As I recall, you can be pretty specific about which local logins get mapped to which remote users. And you can set the default to deny access unless a...

What is the error that you are getting?

What version of VB & Visual Studio? You also might try declaring the datatype of your variables and parameters.

Grant Fritchey (3/17/2008)

---

"Killin' sheep was kinder more fun - but d'ye know, 'twan't quite satisfyin'. Queer haow a cravin' gits a holt on ye - As ye love the Almighty,...

Not disagreeing either, but what aspects would you say were the "glaring hole" parts?

Oops, I didn't realize that we had already piled on that one. 😀

tuseau (3/17/2008)

---

Thanks for the suggestion - I was hoping for a system function which would return the table name but I guss it doesn't exist.

However, I wrote the following function...

And the most important tip for using Linked Servers: SQL Logins are a whole lot easier to get working than NT Logins.

Wow Ken! Did you really color those in yourself, or is there a way to cut & paste from a QA window that preserves the highlighting?

Hey I just noticed it in my Shortcuts box! That's amazing turnaround!

Thanks...

As far as I know case functions are allowed in embedded dts queries. What is the error that you are receiving?

Well, I have to confess, I have not written a CLR UDF yet (I am hoping to write my first this week).

However, I have written a lot of SMO. ...

Where is the "Resources Section"? I don't see anything like that on the page?

You write one stored procedure that does everything that you want to do in this transaction, including the transaction itself. Then you run the stored procedure from your client...

In and of itself 95% memory utilization is not a bad thing, unless you have excessive Fault IO or you have problems with SQL's response time.