I would imagine that it wouldn't lock those tables, except during the read to keep acid principles intact. That said it all depends on what you're doing with the...

Have you granted browser or higher security (within the report manager site) to the users whom are using this report?

Thanks,

-Luke.

Yeah if only they'd...

What credentials is it asking you for, those to access the page/IIS or those to access your datasource? Could it be that your datasource did not specify credentials and...

Glad to help, but just know you really need to test in your environment, YMMV etc...

-Luke.

I have no experience in using it, but I know there are a few projects out on codeplex and codeproject that are basically stand alone SQL Agents... They may be...

What was the "abuse"?

Alot of this depends on what exactly is happening in your transaction, but in it's simplest form no.

It you open 2 query windows both with connections to Tempdb you can...

try the code="sql" tag instead. The first tab will still be screwed up but successive ones should be ok.

SELECT

col1,

col2,

col3,

col4

FROM mytbl

To help us help you, it'd really be a lot easier if we could get some sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Thanks,

-Luke.

Jan Van der Eecken (7/14/2009)

---

Luke L (7/14/2009)

---

GSquared (7/14/2009)

---

Jan Van der Eecken (7/14/2009)

---

Guys and Gals, you are freaking me out! I've been out of the office for not even six hours...

GSquared (7/14/2009)

---

Jan Van der Eecken (7/14/2009)

---

Guys and Gals, you are freaking me out! I've been out of the office for not even six hours and there are already 38 new...

Lynn Pettis (7/10/2009)

---

I have to ask, please try the following queries:

SELECT

*

FROM

Tab2 t2

INNER JOIN Tab3 t3

...

Lynn, I'll have to give them I try on Monday when I get back to the office. I'll let you know though.

Thanks,

-Luke.

Sorry, unfortunately, I can't give you the graphical plans 'cause it doesn't allow me to remove "any and all references to our data" as specified by my boss. I...