have you tried deploying a report to it ?

I would say that if you have connectivity and the catalog is empty, then it is worth creating a new RS database.

It sounds like someone has messed with the existing...

I asked if it was new, because if it is new, I would recommend running through the Report Server Database Configuration Wizard from the Database section of the Reporting Services...

Is this a new installation?

Hi, sorry to butt in like this, but can I make a couple of suggestions?

First, try to keep your dynamic code formatted nicely - it's so much easier to maintain...

Just to make sure you get the correct URL, open IIS Administrator, navigate the treeview to your Reports web application , right click on the Reports node and choose Browse...see...

Hi Lutz,

I personally think your if clause is not covering all the bases...I would do it like this:

SELECT 'Begin' -- this sets the intial rowcount to 1

WHILE @@ROWCOUNT>0

UPDATE XMLTest

SET [XML].modify('

replace...

Thanks, and...

The problem is that "replace value of" can only operate on one node at a time, so you need to either look at FLWOR http://msdn.microsoft.com/en-us/library/ms190945.aspx to rebuild the xml (ugh!)...

And Brad Schulz wrote an interesting blog post http://bradsruminations.blogspot.com/2011/04/index-tuning-detective.html

It does delve into the query cache and although I cannot attest to it's usefulness as I haven't tried it yet,...

JKSQL (7/21/2011)

---

M.Maggoo - That is an unbelievable query but the results are the same as my loop. Where if I am looking for BCD 414 I get

search_keyidthenamevalue

BCD 4141bcd...

Jeff, just what I was thinking...here is a starter for 10...

--= Ranked search - requires table GetMatchingData to exist =--

--= create some test searches to look for in GetMatchingData =--

IF...

pharmboy4u (7/19/2011)

---

@mister.magoo- TY sir, this style query worked well for my current needs and is simple enough for me to wrap my head around after thinking about what it is...

SQLkiwi (7/18/2011)

---

You can avoid performing the complex calculation more than once:

DECLARE

@A INTEGER = NULL,

@b-2 INTEGER = -351,

@C INTEGER = 45,

@d INTEGER = 999;

SELECT

Calculation.result * ((SIGN(Calculation.result) + 1) / 2)

FROM...

SQLkiwi (7/19/2011)

---

mister.magoo (7/19/2011)

---

The recursive part of the CTE returns no extra data, but coerces sql into storing the results (it will plop the results in tempdb once there are enough...