Add a NULLIF(patindex, 0).

NULL -1 => NULL

LEFT ('string', NULL) doesn't die on you.

Had that happen to me a lot too.

Unfortunately the only thing that "fixes" it is to close and reload the project.

That being said I can't remember if I went down...

opc.three (10/31/2011)

---

My preference is to have each physical user log in with a different server login. From a troubleshooting perspective I like to be able to trace runaway processes to...

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Just browse to the SSRS web page. You'll have to enter...

SQLRNNR (10/31/2011)

---

Sorry - no chance on that. Besides the app is java - and it has more bugs than .Net when trying to do this.

Not using reportviewer, but we...

tyson.price (10/31/2011)

---

If you don't want to predefine the table you can use something like this:

declare @iParm int

set @iParm = 111249972

declare @sql varchar(1000)

set @sql = 'SELECT a.* into ##tmpAEC FROM OPENROWSET(''SQLNCLI'',''Server=devsql\tpa1;Trusted_Connection=yes;Database=Manhattan'',''exec...

The only real way to do this is to host the applications on your servers and give ZERO access to the server itself. Only you application.

Then you need to...

Any way to get an obfuscated copy of the app?

Are you using reportviewer control to make this trick?? I've had mitigated success with this in the past 9might have...

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Just browse to the SSRS web page. You'll have to enter login info....

We all knew this was coming....

Edit : And here's the kicker... Attachment # 10111. Only 1 bit off of being #1 all across the board :w00t:.

WayneS (10/31/2011)

---

Kiara (10/28/2011)

---

...

I also type extremely quickly. So I find the process of typing on the screen really, really slows me down.

I find it useful for certain types of activities...

Do you mind telling us where your resume is posted? I'd love a few more requests for my services...

The current free version allows you to hold 10 GB of data. So for 500 000 records you'll be more than fine.

In 5 years? Might be even more...

That's out of my expertise.

I'd have to read up on that issue, so your google is just as good as mine.

Denise McMillan (10/31/2011)

---

Yes, I have full backups from before the first error message and transcaction log backups. They have been working. The server adminstrators and our vendor say the...