GilaMonster (10/19/2008)

---

Now you can create that function in SQL with a nvarchar(4000) parameter (I don't think it'll take varchar(MAX), though if you have directory trees more than 4000 characters wide,...

I can provide you a number of theories about what may or may not be causing this. The best way to determine for certain why you are getting the...

There are a couple of ways for you to go about creating this linked server. The first thing you have to do though is ensure that the SQL Express...

Create a Linked Server between the two and call the stored procedure over the link. I would expect that you will have some performance issues with this since it...

GilaMonster (10/11/2008)

---

but the performance improvements of stored procedures (which are minimal in 2005 and higher) aren't due parsing. Stored procs have to be parsed, bound and optimised just like ad-hoc...

I'd recommend that you read up on ANSI standards for SQL. I might be hardheaded, but I understand what I am talking about. You also might pickup Kalen...

If you are having this kind of issue, then you have something that is not thread safe in your implementation, which we can't see in the little bit of code...

It is obvious from your post that you have no idea how the Query Engine in SQL Server works. The fact that CLR Integration was added to SQL Server...

The database engine understands TSQL. It doesn't build a expression tree from the TSQL, it creates an optimized execution plan so that the database engine knows how best to...

Describe what you mean inverse query. If you simply mean to get the opposite set of rows for the two queries then use NOT LIKE and or !=. ...

What version of SQL Server is this for? How do you want the contents of the table sent, as a CSV attachment, inline to the body of the message,...

It might take a few days but I will follow up on this and post a conclusion here when I do.

That would be my thoughts on this exactly, but I...

I would have to play with this to know. I don't register unapproved assemblies in my servers, so I have never encountered this. I'll have to play with...

Since the BCL consists of signed assemblies, you can still do it without Trustworthy:

CREATE ASYMMETRIC KEY SYSTEM_DRAWING_KEY

FROM EXECUTABLE FILE = 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\system.drawing.dll'

GO

CREATE LOGIN SYSTEM_DRAWING_Login FROM ASYMMETRIC KEY SYSTEM_DRAWING_KEY

GO

GRANT UNSAFE ASSEMBLY...