Hello Michael,

same problem with personal edition...

Carl

Ok I found my error... Here is the correct order to use row versioning with read committed isolation level:

alter

database test_carl SET

Also: My database compatibilty level is 90 and I want to use the READ_COMMITTED_SNAPSHOT isolation level with row versioning.

Carl

Hello Vinod,

Here is what I try to do:

alter

database test_carl SET READ_COMMITTED_SNAPSHOT ON

SET

TRANSACTION ISOLATION...

The answer is yes. But I was a little confuse about locking compatibility and locking granularity.

I found all answers to all my questions in the "End-to-End Solution Book" called: "Hands-On SQL Server...

You could also try to uninstall Framework 1.1 before intalling SQL 2005 (including framework 2.0)

Carl

Thank you.

Thank you Yelena...

I'll look at it.

Best regards,

Carl

The problem was that we didn't set the Timeout  property of the SqlCommand object.

Solved.

Regards,

Carl

Allen,

I've visited this site and made many research but find nothing specific related to my previous questions on SQL Server 2005.

Regards,

Carl

I'm aggree with you.

But its one thing to be able to see private informations and degrade performances and another thing to be able to:

- create tables

- create databases

- configure the...

It seems to be sysadmin fixed server role.

But why do we need this level of security to be able to run the profiler?

In my own opinion, another role should be...

Ok thanks a lot Allen.

Hello Konstantine,

I never played a lot with SQL Job, but I did a test with fc and it worked.

In the general tab of the Edit Job step Window (where you...

Hello,

you can take a look in BOL (books online). Search for the document named : Maximum Capacity Specifications. You will have some answers there.

But for Cluster configuration I am...