Stewart "Arturius" Campbell (9/30/2016)

---

Nice, easy question to end the week on, thanks Steve.

Just a point of confusion in the options:

a table variable, a table in the table, or a temp...

thanks for the nice question steve.

/*(1)*/ SELECT COUNT(*) FROM #TmpCounts; -- 6 rows

/*(2)*/ SELECT COUNT(1) FROM #TmpCounts; -- 6 rows

/*(3)*/ SELECT COUNT(Column1) FROM #TmpCounts; -- 5 rows

/*(4)*/ SELECT COUNT(ALL Column1) FROM #TmpCounts; -- 5...

+1

webrunner (4/18/2016)

---

How could someone get the question wrong? There is only one choice.

I guess maybe they clicked Submit without clicking the radio button first?

-...

i feel double negatives are confusing.

CREATE SECURITY POLICY rls_CustomerFilter

ADD FILTER PREDICATE dbo.rls_customer_check(customerid)

ON dbo.CustomerAccessList;

GO

the above is not included "WITH (STATE=ON)". I thought security policy is not enabled yet and insert succeeds.

+1

As per my understanding, the site name is coming from #count table only,

So we can avoid the loop by writing the single select statement. to get @deep value try...

learnt something new today. thanks for the question steve.

Interesting question. Thank you.

Thanks for the question.

Never used this parameter before while detaching a Database.

Learnt something new. Thanks for the question.

+1

Recently we have changed the job schedule to run for every 1 hour, so it's been little easy.

Thanks...

HI,

The below given link has very good information, please try if this can help you.

http://sqlserver-help.com/2014/07/08/help-how-to-find-cause-of-login-failed-for-user-error/