For me,

around here this happens about once every 3...

I don't even know how excitingly appropriate this is.

Yesterday I learned about savepoints. Today a trigger that was invoking a stored procedure that created an inner transaction and rolled...

LUCAB (9/14/2010)

---

I was wrong answer: "Outer transaction is still open....rolling back... ".

I learned that my wrong answer can be obtained with a SAVEPOINT:

SAVE TRAN InnerTranSavePoint --...

Well your dev report server still has connections on it.. so you can point them to the dev database server for this sort of purpose.

I know it's what we use...

not sure if this will help or not...

I'm guessing you're using VB in the reports to do this and so

Just the DateTime part of a DateTimeOffset value

=Fields!MyDatetimeOffset.Value.DateTime

http://technet.microsoft.com/en-us/library/dd255246.aspx

If...

Modify the data source to point at the production server and then save the report to the production report server/sharepoint site.

If you're reporting off of production data, and the structures of the database are being changed on the development SQL server, where can you work to test/update your existing reports/report...

For example, here's a query built in Query designer

<SemanticQuery xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign" xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">

<Hierarchies>

<Hierarchy>

<BaseEntity>

...

Tracked this one down...

Under site permissions, pick permissions levels.

Edit the group as appropirate and give Manage alerts permission to the group.

Nope that works great, and follows the KISS principle.

I was just looking for something cooler... because well... I wanted something nifty.

But this works great.

RalphWilson (9/1/2010)

---

Some time back, I successfully made the case for an organization to have a look up table for countries & states (if the country was the US) based upon...

TRACEFLAG 4136 will be your...

David.Poole (8/31/2010)

---

Why not use sp_ExecuteSQL and build up the query that is needed in T-SQL code. This will cache the execution plan for the query statement.

The other thing I...

LSAdvantage (8/31/2010)

---

Very good point: "So I would be looking for clarification of the requirements, and making it clear that there is a performance issue, if they want to search...

RalphWilson (8/31/2010)

---

mtassin (8/31/2010)

---

RalphWilson (8/30/2010)

---

To put it mildly, that really screws up trying to do any overall input and analysis of the test results because the input process is a specialized...