Yes, both are installed on the same drive.
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x79138096.[Email address protected]
Sent: Friday, February 29, 2008 9:59 AM
To: LazyDBA Discussion
Subject: RE: RE SQL Server Truncate Table
Hey Maria,
Oh my! Phew! Can anyone win "the COKE"? hehe. Ahhhhhhh, yes! Let
me see! Hehe. Maria, I am running SQL Server 2005 Developer Edition
SP2 and DB2 version 9.1, Enterprise Edition on a Windows XP pc. I have
not experienced any problems with SQL Server 2005 or DB2 version 9.1.
Are your SQL Server 2005 and your DB2 Personal Edition software
installed on the same drive?
-----Original Message-----
From: Cortez Maria E.
[mailto:mssqldba-ezmlmshield-x73731241.[Email address protected]
Sent: Friday, February 29, 2008 11:40 AM
To: LazyDBA Discussion
Subject: RE: RE SQL Server Truncate Table
Hey Ed,
How about offering a coke to anyone who can help me with my problem I
posted yesterday? Read below...
I've had SQL Server 2005 Developer Edition SP2 installed on my local
machine for a while without any problems.
Recently, someone installed DB2 UDB for Windows Personal Edition on my
local machine. I needed both in order to do some database conversions.
Ever since DB2 was installed I am getting this error when I try to run
an import or export:
"The .Net Frame work Data Providers require Microsoft Data Access
Components (MDAC). Please install MDAC version 2.6 or
later.(System.Data)
Retrieving the COM class factory for component with CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following
error: 80040154. (mscorlib)"
I verified that MDAC 2.6 is installed on my machine. I don't want to
re-install SQL Server if I can avoid it. Does anyone know if SQL Server
and DB2 UDB can run side by side?
Maria
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x48634993.[Email address protected]
Sent: Friday, February 29, 2008 8:18 AM
To: LazyDBA Discussion
Subject: RE: RE SQL Server Truncate Table
Oh my! Phew! I forgot to share my "original proof"! Red Stripe!
Hehe.
SET IMPLICIT_TRANSACTIONS ON
USE test_edwarde
GO
TRUNCATE TABLE EMP3
ROLLBACK
SELECT * FROM EMP3
Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Dr. Eric J. Smith is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Damiani Paul
[mailto:mssqldba-ezmlmshield-x26387158.[Email address protected]
Sent: Friday, February 29, 2008 11:00 AM
To: LazyDBA Discussion
Subject: RE: RE SQL Server Truncate Table
I'm new here and maybe I'm oversimplifying, but isn't wrapping a
truncate up in a transaction just a bit of SQL "sleight of hand"?
Would one be able to rollback a truncate in a session with
implicit_transactions set?
Paolo Damiani
International Specialty Products
-----Original Message-----
From: Jeremy Greaves
[mailto:mssqldba-ezmlmshield-x63588365.[Email address protected]
Sent: Friday, February 29, 2008 10:48 AM
To: LazyDBA Discussion
Subject: RE SQL Server Truncate Table
Truncate is not supposed to be able to be rolled back, as it deallocates
the data files and makes their extents available for writing over. The
actual deallocation is logged in the transaction log however, but
technically TRUNCATE statements are not available for rollback. However
if you put the truncate statement within a BEGIN TRAN - (ROLLBACK TRAN)
COMMIT TRAN block, then of course that sessions activity is capable of
rollback. However, if you FUBAR by the use of TRUNCATE and have a
backup.... Is this a trick question?
Jeremy Greaves
Fenris Software Consulting, Inc
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page