Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikedcmdva
Starting Member
7 Posts |
 Posted - 2010-03-16 : 14:50:02
|
| I am studying for the MCTS in SQL 2008.This book is ridiculous, it asks at the end of the chapters to perform things the chapter did NOT even discuss!! So I am stuck now, of course.It is asking:Create multiple connections to the database, change the access to RESTRICTED_USER, and specify the ROLLBACK IMMEDIATE option. Observe the effects,I know what those commands and settings mean, but if I use ROLLBACK IMMEDIATE and kick everyone from the database, how will I know if they are kicked?How could I set up a few different connections on my own so I can test kick all of my own connections out and see them kicked?I am fairly new so please take it easy on me with how technical the answers are, and thank you very much for your time!Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-16 : 15:23:22
|
| If you create the connections in SSMS, then just run SELECT 1 on those connections after they have been kicked out. You should get a transport error at this point.Just open up new windows in SSMS and run simple queries using your existing credentials.If you want to observet the effects of RESTSRICTED_USER, then you'll need to create new logins/users that have very little permissions and then connect with those inside SSMS.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
mikedcmdva
Starting Member
7 Posts |
Posted - 2010-03-16 : 17:10:32
|
| Ah! Thanks! Got the transport error...Another one for you Ms. SQL Goddess =)"Change the database state to READ_ONLY and observe the effect on the transaction log file"I did that, but what could I possibly observe with the log file that I should take note of? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Exam Question Help from book, confusing