Viewing 15 posts - 16 through 30 (of 79 total)
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:
June 10, 2015 at 6:11 am
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
June 4, 2015 at 6:41 am
Back to the basics with a nice question.
Happy Memorial Day!! Salute to the martyrs!!
May 25, 2015 at 12:30 am
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...
April 20, 2015 at 12:17 am
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...
April 1, 2015 at 6:47 am
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?
April 1, 2015 at 4:24 am
Oh k..Thanks again, Gail. Can you please elaborate it or show some proof... Just to make myself clear.
April 1, 2015 at 4:02 am
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/[/url]
However I will look at SQL Audit as you mentioned as I feel it will help in this case.
April 1, 2015 at 3:46 am
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...
March 5, 2015 at 12:00 am
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
January 21, 2015 at 6:39 am
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....
January 21, 2015 at 6:18 am
Stewart "Arturius" Campbell (11/24/2014)
karthik babu (11/24/2014)
November 24, 2014 at 9:53 pm
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...
November 24, 2014 at 5:06 am
Hi All,
I got the below error while attempting to run a distributed transaction. The two servers are in different workgroup. We dont have a domain. Please let me know the...
November 13, 2014 at 3:51 am
Viewing 15 posts - 16 through 30 (of 79 total)