There is no correct answer for this question listed in the possible answer selections as they are all valid "Actions" and or "Parameters" to the actions of the SCM utility.

I...

I agree, Answer 2 is correct because of the above stated reasons and this from BOL.

"Executing sp_changedbowner with only the login parameter changes database ownership to login and maps the...

I think this is another example of an unclear question.

I took standard transactional replication to mean without immediate or queued updating options set. Therefore the answer I chose was...

Not entirely true about the create table defaulting to not allowing nulls if not indicated on the create statement. It all depends on the database settings, session settings, tool your...

Amit,

If you read all the posts in this thread, both your points have been discussed already.

I would like to make the suggestion that everyone read the enitre thread of...

Melvyn, No where in the question does it indicate what order the records were inserted in. If you look, there is an order by on the selects from both tables....

This questions answer should have explained why SQL came up with that answer.

Mind you, us programming types got it right, because order of operations applies to any programming language in...

Detail..Detail...Detail....must pay attention to detail...

I liked going through IBM 3090 Mainframe core dumps back in the day (as they say) too...

I know, most of your are saying IBM Core dumps???

The correct asnwer is not entirely correct as stated, but given the choices it is correct. Problem being if you execute these statements you will see that after the column...

No one either agrees or disagrees with me?

Am I that far off in left field?

Perhaps I misunderstood the question...

I have an SQL server that has Analysis enabled, I have cubes created and when setup SQL profiler to monitor the login event, I see my...

I would think that in the case...

From the BOL:

An update transaction is similar to a delete operation followed by an insert operation; the old rows are copied to the deleted table first, and then the new...

I guess this is anoter example of why we should always READ the question and then READ it again

I got this wrong, but I know why.

In my testing I created a 'TestUser' account on SQL and gave it a datareader role. I then went to my employee table...