I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear author?!!...

I strongly agree with SQLRNNR, that`s true UNIQUE constraint does allow inserting multiple values (in a single column) as long as the whole compination of the UNIQUE constraint is not...

Thank you all for the useful info, links and that good free ebook, I already started reading it beside studying from MSDN and I am having real hard times with...

Thanx Gail for the response but unfortunately the same result I got [nothing useful]. Actually the official Microsoft training kit will be published later this year on November 1 other...

Create this Trigger on master db

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [Security]

ON ALL SERVER

FOR DROP_database

AS PRINT 'Database Dropped'

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

ROLLBACK --this will...

I executed the query myself and it returned 1 row with the value of 1, so I guess the answer is wrong!;-)