I did read those posts from BOL, and they seem to support my findings that you cannot solve my problem with the EXECUTE AS. Please consider the following scenario:

LOGIN1...

You are correct about the SA access within a sproc...I only used it as an example as I didn't want to have to explain the whole security model I was...

Basically from what I gather from your SP is that you are wanting to pass an array of intergers, and to do it, you are placing them into a string....

Not sure what you meant by "Hmm, question is how do you take a string and put it in the where clause against 'int' not too sure. "

You can compare...

Thanks!

The last post read my html tags. Any way, you can try adding the break html tag as a string.

If your email is set to decipher html tags, to get the carriage return you may also try adding:

'
' + '
'

To get the carriage return try a couple things:

try char(10) + char(10) --Wierd, but sometimes adding two carriage returns = 1 carriage return in an email body

try char(13) + char(13)

You...

When I want to retrun multiple rows into one string variable, I always use the coalesce function. In fact, I do this in several instances dealing with email as...

We got around this issue by deleting the records in slices:

DECLARE @DeleteIncrament INT

SET @DeleteIncrament = 10000

WHILE 1 = 1 ...

I really like this article on nulls:

http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

Thanks Jonathan for this very timely article! Can you advise whether this CLR function will work for UNC paths?

Thanks,

Carleton

You weren't terribly clear in the query you are working with, but if the columns you are trying to get a distinct list span multiple tables, you could do something...

Thanks Jack, that helps.

Thanks Nathan, however, my database is already in the simple recovery mode. The simple mode does not eliminate or reduce logging (which is the goal in my case).