The options could have been more clear. Anyways I got my point after careful analysis. Good information though. 🙂

Thanks for your response. I applied the same settings as in other server and was fine.

Not sure if this set of code behaves same in all of the 2005+ versions.. Steve has to confirm what went wrong!!!! 😀

My points please!!! :hehe:

Great Catch!! One of the wonder of SQL Server I guess. If there's some explanation for this it would be great.

Nice Question though. Thank you

Back to the basics with a nice question.

Happy Memorial Day!! Salute to the martyrs!!

Nice Question.. Index remains same irrespective of altering the table by adding a constraint and then by adding an unique clustered index.. I believe the index should have been dropped...

The SQL Audit worked just perfect. But couldn't create audit for more than one table though it allows you to select more tables. Can we select multiple tables in a...

Oh.. yeah.. Its interesting and didn't know until now. Thanks for the information, interesting though.

So what's the best way to achieve my goal?

Oh k..Thanks again, Gail. Can you please elaborate it or show some proof... Just to make myself clear.

Thanks Gail. Actually, the below site helped to get the connection source..

http://thesqldude.com/2012/04/07/how-to-prevent-users-from-accessing-sql-server-from-any-application-or-any-login-expect-your-main-application-its-login/%5B/url%5D

However I will look at SQL Audit as you mentioned as I feel it will help in this case.

Got Lucky as I chose (d) where no other possible option is left!! 😀

Thanks for the question.. Often I use the similar queries in our pre-production environment to generate new...

I have created the trigger in master. I suppose the trigger should be executed from master database only.

Please let me know if I have to alter the database

I am aware that this one is a very old thread!!

But have need to clear my doubt and have no other go.

The script works perfect and sends alerts....

Stewart "Arturius" Campbell (11/24/2014)

---

karthik babu (11/24/2014)

---

I still wonder, the results of 2 and 3. One is scan and the other is seek on the same non-clustered index. Is there any...

I still wonder, the results of 2 and 3. One is scan and the other is seek on the same non-clustered index. Is there any explanation for this SQL behaviour?

[font="Courier...