Is it possible to not log when executing a stored procedure?
I need to run a stored procedure that eats logfile space. Is it possible to add transact SQL to tell the server not to write to a logfile for this procedure?
Not that it helps a great deal, but just because everyone will ask for it.. here is the SP (it deals with 2 milion records) It works fine, but the log just explodes when I run it
Insert into [TWPLAK\JONG037].[NP00_tab
el] ( [aanwezigheids indicator], [Time stamp], [DSLAM id], [dslam-VCID],
[acces info], [ADSL profile], [Customer id], [Cross connection count], NT_VPI_1, NT_VCI_1, LT_VPI_1, LT_VCI_1, CSV,
lijnid, Debiteur, [Order], geann, product, Kopstatus, profiel, [vorige profiel], VCID, [rte-eind], PC, huisnummer,
[huisnummer-toevoeging], telefoon, ordersrt, Ucode, ISP, DSLproduct, xDSLproductType, KlantTypeBaan, [C-start], [C-eind] )
SELECT
len(
Case
When [ADSL access info] Is Not Null THEN '100'
Else '200'
End
)
AS [aanwezigheids indicator], [Time stamp], len([DSLAM id]),
len(
Case
When [Cross connection count]='0' Then Left([dslam-VCID],(Charind
ex([dslam-
VCID],'.0'
,5))) +
Case
When Len([VCID])=3 Then '0' + [VCID]
Else [VCID]
end
else [dslam-VCID]
end
)
AS dslam_VCID
, len([acces info]), len([BAAN profiel naam]), len( [Customer id]), len( [Cross connection count]), len(NT_VPI_1), len(NT_VCI_1), len( LT_VPI_1), len(LT_VCI_1), len(CSV), len(lijnid), len(Debiteur), len([Order]), len(geann), len(product), len(Kopstatus), len(profiel), len([vorige profiel]), len(VCID), [rte-eind], len(PC), len(huisnummer), len([huisnummer-toevoeging
]), len(telefoon), len(ordersrt), len(Ucode), len(ISP), len(DSLproduct), len(xDSLproductType), len(KlantTypeBaan), [C-start], [C-eind]
FROM dbo.NP00 LEFT JOIN [TWPLAK\JONG037].[9a - adsl_vt_profiel] ON [ADSL profile] = [adsl profiel naam]
Start Free Trial