SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Isolation Levels
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/20/2013 :  07:38:15  Show Profile  Reply with Quote
I am learning the isolation levels from eBook "SQL_Server_Concurrency" by K Delaney.

As part of that, i have created a database which consist of only one table.
When i tried to change the isolation level of the database to
READ_COMMITTED_SNAPSHOT using the below query, i am not able to get any result.

ALTER DATABASE IsolationDB SET READ_COMMITTED_SNAPSHOT ON ;

I waited for 1 hour for the query execution. Then i stopped the process.
Requesting for help.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

djj55
Constraint Violating Yak Guru

USA
308 Posts

Posted - 12/20/2013 :  08:33:01  Show Profile  Reply with Quote
Try putting the database into single user mode.

djj
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 12/20/2013 :  08:42:55  Show Profile  Reply with Quote
Or Disconnecting all connections to that Database. (sp_who2)
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/20/2013 :  09:04:40  Show Profile  Reply with Quote
quote:
Originally posted by denis_the_thief

Or Disconnecting all connections to that Database. (sp_who2)



No connection to the server is open when i am trying to change the isolation level.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/20/2013 :  09:09:38  Show Profile  Reply with Quote
quote:
Originally posted by djj55

Try putting the database into single user mode.

djj



Even i took a back up of that database, then deleted that database and restored it again. But i faced the same problem.

Still, do i need to put my database in single user mode?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

Edited by - sgondesi on 12/20/2013 09:13:58
Go to Top of Page

djj55
Constraint Violating Yak Guru

USA
308 Posts

Posted - 12/20/2013 :  09:41:29  Show Profile  Reply with Quote
I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 12/20/2013 :  10:22:44  Show Profile  Reply with Quote
Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/22/2013 :  04:32:51  Show Profile  Reply with Quote
quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj



Its ok.. Thanks for your concern..

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/22/2013 :  04:35:38  Show Profile  Reply with Quote
quote:
Originally posted by denis_the_thief

Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON



ok i will try..
actually i cannot access my system now. Once i get access, i will do that and get back to u.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

Edited by - sgondesi on 12/22/2013 04:38:17
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/26/2013 :  04:02:03  Show Profile  Reply with Quote
quote:
Originally posted by denis_the_thief

Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON



This command is executed in a flash..
but the earlier command is still not getting executed.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/26/2013 :  04:26:31  Show Profile  Reply with Quote
quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj



And actually i wanted to keep my database in single user mode as you said.
But the thing is, i am facing a problem with my configuration manager.
So i could not able to do that.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/27/2013 :  03:45:52  Show Profile  Reply with Quote
quote:
Originally posted by sgondesi

quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj



And actually i wanted to keep my database in single user mode as you said.
But the thing is, i am facing a problem with my configuration manager.
So i could not able to do that.

And i posted the problem which i am facing with Configuration Manager in a new thread.



--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000