how about defining @auditCode in your variable options to be @auditcode = (select DISTINCT auditCode from Local_Audits)

and then just change your last line of code to be AND LU.auditCode in...

the last one. The Alternate query.

but it is still giving me some issues. my table variable example was a little simplistic. the actual way I get the 3 column result...

thanks Chris!

btw, I already came up with

;

with CTE as (

select *, ROW_NUMBER() Over(Partition By AccountNumber Order By Distance) [Rank]

from @CustIfno)

select * from CTE where Rank = 1

but it runs to...

my bad. I assumed you were upgrading your enviroment by adding a server.

have you rolled back SP1 yet to see if that allows your app to start working again?

its because the app server (1) is passing credentials to SSRS (2) and then onto the DB (3).

the credentials can only hop 2 times. not 3.

we got around this issue...

paste the contents of your web.config file so we can see if the connection string is correct.

what are you using to detect CPU is at 90%? the alert you create does not appear to have the required component of

@performance_condition=N'Resource Pool Stats|CPU usage %|default|>|90',

also, this...

I have never been able to do that. regardless of MS DTC settings or the sp_configure settings of remote proc trans.....

the way i get around it is using sqlcmd to...

based on what you said, it would seem your linked server is set up to pass authentication.

"Be made using the login's current security context"

you can select "Be made using...

are you using a domain account to run the SQL services on both servers that have needed rights?

Receive Deadlock Info via email[/url]

what are the specs of this server? is it 32 bit or 64 bit? how much memory does the server have?

you give a 80 / 20 settings. so are you...

Answer here

you can't.

you can export 2008 r2 data to 2008 though.