Yes, that's my idea. 95% of my customers are SQL Server, but I can't ignore the 5% that uses only Oracle, because they are important customers, and they do not...

Isn't the Reporting Services Runtime free to use and distribute? I won't use the Reporting Services portal that comes with SQL Server, nor will the customer develop reports. I would...

I'll look into it! Tks so much for your time and attention!

Well, good point there. We need row locks for several critical tables updated by our application server, to serialize access to them, and avoid deadlocks due to some denormalized columns...

I can tap into the Entity Framework to get the connection, and then use "real sql" with query hints to enforce the row lock, but that kinna beats the purpose...

Ok. I was worried there for a second.

Tks for the tips!

I did disable xp_cmdshell after my test.

And I posted back the solution I received from the other forum... Is this what you mean by closing the topic?

The file name was missing... stupid mistake... focusing on the complex things, and missed the simple things...

I had the same problem, but in my case, the URL to the Report Server was wrong, without the instance portion of it. After I corrected the URL, the prompt...

To share the results of my tests, I developed one view, VWRetentiv that has the CASEs directly into it, and a VWRetentiv2 that calls the functions that has the CASEs....

Hello Michelle,

Not in my case, since the rows that need change would have to be updated every second. A small example of the function that I'm generating for my benchmarks:

ALTER...

Lynn,

First of all, I'm sorry for not posting all the table contents, but it's a 100 column table, so the view and the functions are pretty huge. I just wanted...

What information should I see on the execution plan? CPU and IO times?