Nothing in windows event logs nor sql logs nor sql agents...

Everything is "A-OK" but the job never finished untill we did a forced shutdown... which then the agent stopped...

Luke L (5/11/2010)

---

Just out of curiosity and forgive me for asking the is it plugged in type of question, but did you make any changes to the report?

On...

Any workaround or bug on the connect site I can be reffered to?

Or plan D, any shortcut to delete all reports and redeploying everything at once?

Google and connect are not helping.

SSRS 2008 with VS 2008 FULL version...

Deploy won't overwrite rdl even with overwrite datasource to yes.

Yes I've tried that but that setting is only for the datasource and has [no apparent] effect on the rdl itself..

Oh and I almost forgot.

GO HABS GO

:w00t::-D:hehe:

matt stockham (5/10/2010)

---

Ninja's_RGR'us (5/10/2010)

---

Is it safe for me to enable the transaction level on the db (without changing any code)?

(Yes I'll test on preprod server to confirm)..., but are there...

Chad Crawford (5/10/2010)

---

We replayed traces back when we were upgrading from 2K to 2K5 - If I remember right we got around the issues by loading the trace up...

Roy Ernest (5/10/2010)

---

As far as I know, there is no need to change any code. This is set in the Database level. Also keep in mind that the Isolation levels...

LMGT4U 🙂

http://www.databasejournal.com/features/mssql/article.php/10894_1479971_3/Using-SQL-Server-Profiler.htm

Apparently I'm screwed since 99.9% of the queries are run with windows authentication... so much for load testing.

Is it safe for me to enable the transaction level on...

GilaMonster (5/10/2010)

---

Ninja's_RGR'us (5/10/2010)

---

Is it possible to take a backup from production, then start a trace on prod. Then a couple hours later do a restore to test server and...

Roy Ernest (5/10/2010)

---

You have stated that you have SQL 2008 with OS 2008. Here is something for you think about if it will solve the issue. Row Level Version. If...

GilaMonster (5/10/2010)

---

No and no. Not an area that I've dived deeply into yet.

What impact can I expect for...

Thanks Gail. I'll read up on the subject and see if I can set the isolation level for my code.

Do you have any articles to recommend? Written one...

I did shut them out (after taking screenshots of the damage and...