May 2010 UG Scheduled
We are ready for May month session. Please go-ahead and register for the same.
Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timings: 10:00 AM to 01:00 PM
Date: 29th May 2010
Session Details Below
10:00 – 10:15 UG Intro
10:15 11:45 Locks and DeadLocks by Deepak
10:45 11:15 Snack Break Time
11:15 12:00 General Discussions
Contact persons:
UG admin cssug@sql-articles.com
<<REGISTRATION CLOSED>>
PS: We will be freezing registration by 28th May 2010 EOD
Tags: chnsqlug, cssug, sqlug, ug
Trackback from your site.
VidhyaSagar
| #
Thanks Ashish, I’ve updated the script.
Ashish
| #
I was just searching some trace related articles and gone through your article. Found one incorrect information,
to disable the trace, the command should be
dbcc traceoff (….)
you might have by mistake mentioned it as traceon for disabling as well.
Ben
| #
I remember having to write a complicated procedure to do the same thing recently. This will be nice to use with a web app to only return a small subset. I think this will improve the speed especially when the entire result set is very large.
namanthakral
| #
got errors after executing this trigger
“SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.”
and was really stucked in this mess but DAC saved my life
C:\Users\Administrator>sqlcmd -S LocalHost -d master -A
1> DROP TRIGGER block_ipaddress ON ALL SERVER
2> go
SQL NET » New Feature in SQL Server 2012
| #
[...] CLICK HERE TO READ THE ARTICLE [...]