Excellent question and better explanation.

good Question

I exepected funny answer so i got wrong

You guessed correct .I need a recursive cte but am getting dependencies using dynamic management function.

but it is not supporting to write the code for recursive ctes .

for example when...

greated question

Good question.Even tough i got wrong i learned one point today.

Thanks for QOTD

I guessed correct answer but i tried to test the code.then i got error because of this

create table #test(id int identity(1,1),value int);

go

set identity_insert #test on

insert into #test

select 1,2

union all...

I also got wrong and choosed DMV

nice question.

same for me also i got it wrong

For...

If restore the entire database with other name that is difficult its big database contains 360 gb.

so restore entire dtabase is not possible.I want to restore only one table from...

May be full text search is eanble on this database.

good question,learned some thing new.