Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

TRUNCATE Expand / Collapse
Author
Message
Posted Thursday, February 4, 2010 10:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:31 PM
Points: 132, Visits: 101
Comments posted to this topic are about the item TRUNCATE
Post #860154
Posted Thursday, February 4, 2010 10:41 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2016 5:42 AM
Points: 2,746, Visits: 374
this was a very easy question...
Post #860173
Posted Thursday, February 4, 2010 10:45 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 3:55 PM
Points: 19,959, Visits: 18,195
thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #860175
Posted Friday, February 5, 2010 1:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 1, 2015 6:09 AM
Points: 2,891, Visits: 3,889
I wonder why there is no DDL trigger available to capture this of event...

Best Regards,
Chris Büttner
Post #860219
Posted Friday, February 5, 2010 4:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 5,211, Visits: 6,930
Good spin on what is and is not recorded in the transaction log.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #860312
Posted Friday, February 5, 2010 6:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, January 20, 2016 2:41 PM
Points: 331, Visits: 1,655
Hmmm...I would have thought TRUNCATE could raise a DDL trigger.
Post #860402
Posted Friday, February 5, 2010 6:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 28, 2015 7:52 AM
Points: 1,260, Visits: 3,509
eeeeeeeeeeeeeeeeeeee typing wrong answer this happened that I misunderstand in opposite way



============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #860406
Posted Friday, February 5, 2010 8:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, June 23, 2016 7:26 AM
Points: 3,071, Visits: 1,123
yikes - I knew the answer and selected the wrong button -need more coffee
Post #860510
Posted Friday, February 5, 2010 2:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 28, 2015 7:52 AM
Points: 1,260, Visits: 3,509
barb.wendling (2/5/2010)
yikes - I knew the answer and selected the wrong button -need more coffee

aaaaaaaaaaaaaaaaaah we are in same team buddy, same happened to me too!!! -


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #860860
Posted Saturday, February 6, 2010 7:55 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, January 6, 2016 1:49 PM
Points: 3,925, Visits: 1,619
Back to basics. Most of the time I select wrong answer for basic and simple question. Triggers are for INSERT, UPDATE, or DELETE only.

SQL DBA.
Post #861244
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse