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...

[set beginner lvl on]

What?

[set beginner lvl off]

I've read about transaction isolations but I don't know what you're asking.

Lynn Pettis (5/10/2010)

---

My question is why are they debugging in production? If there is a problem, they should have a test environment in which to test and debug issues...

Lynn Pettis (5/10/2010)

---

My question is why are they debugging in production? If there is a problem, they should have a test environment in which to test and debug issues...