<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ninja's_RGR'us
»
Truncate rollback
88 posts, Page 2 of 9
««
1
2
3
4
5
»
»»
Truncate rollback
Rate Topic
Display Mode
Topic Options
Author
Message
Sree Arjun Div
Sree Arjun Div
Posted Thursday, April 22, 2010 12:55 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173,
Visits: 1,350
Its Getting Error Or ?
Post #908351
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, April 22, 2010 1:10 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,526,
Visits: 3,620
Depending on your settings, the error can also be a valid answer:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'a'.
Best Regards,
Chris Büttner
Post #908354
Koen Verbeeck
Koen Verbeeck
Posted Thursday, April 22, 2010 1:33 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
Christian Buettner-167247 (4/22/2010)
Depending on your settings, the error can also be a valid answer:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'a'.
I'm curious, what settings give this behaviour?
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #908363
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, April 22, 2010 1:50 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,526,
Visits: 3,620
The following setting will cause the error:
SET IMPLICIT_TRANSACTIONS ON
If this is turned on, the create table statement will also be rolled back, causing the error.
Best Regards,
Chris Büttner
Post #908368
Koen Verbeeck
Koen Verbeeck
Posted Thursday, April 22, 2010 2:01 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
Hopla, learned something new today
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #908377
kaspencer
kaspencer
Posted Thursday, April 22, 2010 2:24 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 10:36 AM
Points: 1,405,
Visits: 253
The insert statement has a syntax that is unacceptable to SQL Server 2005. So why wasn't it stated as being compatible with SQL Server 2008 and later only?
We should get our points back.
Kenneth Spencer
Post #908390
Abrar Ahmad_
Abrar Ahmad_
Posted Thursday, April 22, 2010 3:10 AM
SSC Veteran
Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:49 AM
Points: 202,
Visits: 1,043
kaspencer (4/22/2010)
The insert statement has a syntax that is unnacptable to SQL Server 2005. So why wasn't it stated as being compatible with SQL Server 2008 and later only?
We should get our points back.
Kenneth Spencer
Digesting loss of points, is if not Very Tough but at least, it is Tough, I think.
It’s frequent in case QODs, so be brave, as me lost last day’s points.
Post #908405
Cath Trimble
Cath Trimble
Posted Thursday, April 22, 2010 3:11 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, January 24, 2013 3:51 AM
Points: 787,
Visits: 1,192
I got this right, but only because the question was on ROLLBACK and I gambled on the INSERT statement being an mistake/typo. I didn't know that it would run OK as is on SQL Server 2008, so I did learn something. It should have been stated which version this applied to.
Regards,
Cath
"Hang on lads, I've got a great idea. "
Michael Caine (Charlie Croker) The Italian Job
Post #908406
sachin.mahtole
sachin.mahtole
Posted Thursday, April 22, 2010 3:18 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, February 14, 2013 5:23 AM
Points: 15,
Visits: 27
My answer is ERROR
as insert query given me error. moreover yes Rollback can rollback pages truncated by TRUNCATE.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.
Thanks
Post #908411
rcavill
rcavill
Posted Thursday, April 22, 2010 3:34 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, April 01, 2013 11:51 PM
Points: 292,
Visits: 794
So I learnt about a new feature of the INSERT statement in SQL 2008.
Definitely use feature that when systems finally upgraded to SQL 2008.
Perhaps I should have paid closer attention at the title of the QOD to give me a hint, rather than the obvious syntax error based on current SQL version I generally use.
------
Robert
Post #908420
« Prev Topic
|
Next Topic »
88 posts, Page 2 of 9
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
