Can you preview the report in BIDS successfully?

Can you RDP to the report server and run the report there so you can get the full error message and post that?

Interesting that the added index was not used as it still did an CI Scan.

I have a couple more questions:

How many rows are in the table?

Does the CONTENU...

I believe the DATETIME datatype corresponds to TIMESTAMP in Access. You can then use one of the Date/Time functions to create a DEFAULT CONSTRAINT on the column.

Gaps in a column with the identity property set usually means 1 of 2 things:

1. Deletes

2. Failed inserts

So I'd check how many deletes are being done and how...

THe harder part of returning multiple result sets is for your application to be aware of the multiple result sets.

Can you create a workflow item using SSMS instead of the UI? I don't think you are getting an accurate error message back from the UI.

It sounds to me...

There's always DBCC OPENTRAN() as well, but I'd use the script Bob provided.

Based on the documentation it looks like you have added the user to the necessary roles.

What happens if you do this:

USE msdb

GO

Execute AS USER = 'low_privileged_user'

SELECT * FROM dbo.sysjobs...

You should also look at sys.dm_db_tran_locks to see what the blocking session is locking

Can you post the code? It will be a lot easier to provide some help if we can see the code or at least a reasonable facsimile of it.

What does...

Lynn Pettis (4/11/2012)

---

jfogel (4/11/2012)

---

I'm surprised there isn't a huge amount of complaining about smoke breaks. Myself and nearly every other DBA I've know smoke. There has never been a shortage...

rmechaber (4/10/2012)

---

Jack Corbett (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha"...

I definitely spend time on distractions. Some days it does hurt my productivity, but most days it is a quick break to refresh myself from the mental grind which...

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity. The word...

Sometimes a database taking a ling time to run crash recovery means you need to work on the transaction log because you have too many VLF's. Check out this...