anthony.green (5/8/2012)

---

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2 denotes...

Another thing would be the mixing of AND & OR in the WHERE clause - is that being evaluated correctly for desired criteria?

Queue, not cue, surely?

(Sorry :-D)

A combination of @@PROCID & OBJECT_NAME()?

http://msdn.microsoft.com/en-us/library/ms174408(v=sql.105).aspx

Yes, just do:

SELECT CASE WHEN EXISTS(subquery) THEN...

There are some situations you can't use it (e.g. in a group by clause IIRC), but SQL should tell you quite clearly in that...

Yep, looks like you're hitting the double hop problem.

Jimbo's links should have the information you need to solve it.

Thanks

Lynn Pettis (4/27/2012)

---

SQLRNNR (4/27/2012)

---

Lynn Pettis (4/27/2012)

---

L' Eomot Inversé (4/27/2012)

---

GilaMonster (4/27/2012)

---

Yup.

On the plus side, SQL's smart enough not...

On the security page of the linked server properties, are any impersonated logins setup, and which option is selected in the 'For logins not defined in the list above, connections...

SQLCrazyCertified (5/3/2012)

---

Gazareth (5/3/2012)

---

I'm trying to work this out as well.

I can understand the problem with a production outage if the DR site goes offline, but if the mirror's at the...

I'm trying to work this out as well.

I can understand the problem with a production outage if the DR site goes offline, but if the mirror's at the principle location...

Crikey that's a script! 😀

Don't have a query to hand, but there's sys.database_permissions, any use?

Your mileage may vary, but I've seen impressive results from adding the RECOMPILE option mentioned in Gail's article.

Wasn't exactly the same scenario, but similar enough that you might get some...

Agreed.

Not sure you really need custom code for this?

The other thing I can think of is:

Are you accessing it via http://computername/reports or http://localhost/reports ?

Try the Run as admin with both.

Other than that, there's loads to look at on...