Same here...also got the question wrong. Thought it would set-up but not start.

Always good to learn something new 🙂

John Mitchell-245523 (12/11/2012)

---

No. The query that you posted above, run it every five minutes and insert the results into your audit table. Bear in mind that if a...

Thanks Gail!

The other thing that you might be able to do is put down an extended events session, probably with a ring buffer that you poll or with a bucketiser...

John Mitchell-245523 (12/11/2012)

---

Try dumping the results of your query into an audit table every five minutes. You'll want to test and plan carefully so that you don't end up...

Correct!

Is there some way Logon Trigger be used to ascertain this information. I know Logon trigger operate on sever level, still checking if that can be tweaked in some...

Thank you for another good question Ron!

NULL value will also be returned in the below two conditions:

-- When starting position is negative

SELECT STUFF(@str, -1,5,@stx)

-- When starting position is greater than...

What would happen, if the current user is mapped to any one of the two schema's by default? Last statement would always throw an error!!

As this option was not one...

Well said! This seems to...

An easy one for today. Thanks for posting!

Nice question Raghu! Thanks for posting 🙂

Good Question Ron. Thanks for posting. Its always good to revise our basics 🙂

Create a new Database diagram from the database under verification using SSMS. Try to compare the visual diagrams thereafter.

An interesting question. Put in a lot of thinking before attempting it and got it wrong in the end 🙂

karthik M (11/29/2012)

---

I want to achieve this without disabling FK.

is there any other way to do this?

Phil method looks ok.

Beside this, is it a good practice to design...

+1

I...