Hi Paul, thanks for the reply.

Answering to your questions, the transaction log of tempdb is set on a different physical device as the tempdb data and both are set to...

We turned on the row level versioning on our database. It's on for almost 15 days. But this morning the tempdb transaction log got full.

My question is if the...

Anyone?

Any ideas?

That's what I'm thinking. Since it's inside a stored procedure, it might being blocked by a previous transaction. The problem is, how can I get the exact statement that is...

Thanks for the reply!

I already ran that script, but, as I said, the information returned is not reliable.

Example: in my blocked process report, it shows that the table A is...

How reliable is the information generated in the blocked process report?

I'm asking that because we let the report on for several days and when we parsed the information, we had...

Thanks, guys! Great advices!

Another question: Do you know if I might have issues to set the row level versioning on even if the compatibility level is set to 80 (SQL...

No one?

I'm monitoring the whole SQL Server environment with the blocked process report.

I'm running this process in background as a job to get the informations.

The problem is that it generated a...

Great answer! That's exactly what I need to know.

Thanks, Paul

I don't have an account on sqlmag website... :blush:

Ok, but the concept of the schemabind view is different from the regular view, right? Because, as far as I know, SQL Server materialize the schemabind view, if I'm not...

No one?

Anyone?