ok i thought trunc meant that it truncated the characters or data in a cell to something, but what is going on here?
UPDATE primary_mst set box_name_change = TRUNC(box_name_change);
site: http://www.deweydesigns.com
blog: http://www.deweydesigns.com/blog
myspace:
http://www.myspace.com/esotericstigma
First time poster...
Alright this is what I got...I am running MSSQL server 2000.
I have already restored a copy of the production db to our test sql server.
What I need to do is run some update scripts (from 3rd party vendor, going to newer version of their product). The database is about 60Gb and I filled up the transaction log (causing later updates to fail) while running one of their scripts that executed 194 routines of:
alter table Table_Name add New_Column int
GO
EXEC sp_bindefault mg_zero_dflt, [Table_Name.New_Column]
GO
update Table_Name set New_Column=1
GO
Will "sp_dboption 'dbname' 'trunc. log on chkpt' 'TRUE' " automatically truncate the transaction log when approaching the transaction log file limit while running these update scripts. Then when the updates are complete go ahead and "sp_dboption 'dbname' 'trunc. log on chkpt' 'FALSE' "
I'm not worried about logging the transactions during this process, I just don't want to have the transaction log fill up while running these scripts causing it to error out.
Or is there a way to make those changes using bcp?
HI ALL,
Please show me how to set the trunc. log on chkpt. database option to TRUE .
thanks so much
Hi....
I am new to SQL Server. I primarily use Oracle which allows me to trunc(date) to removed the timestamp from a date.
Can anyone tell me the equivalent in SQL Server?
Thanks!
Christine
I got the following message
"DUMP TRANsaction is not allowed while the trunc. log on chkpt. option is enabled: use DUMP DATABASE, or disable the option with sp_dboption. (Message 4208)"
on the scheduled task as follow
DUMP TRANSACTION TASS_DATA TO tass_log_dump WITH NOUNLOAD , STATS = 10, INIT , NOSKIP
Please help me ASAP!
Many Thanks!
hi
I just created a DB , & ran sp_dboption , it showed me that the trunc. log on chkpt. is true .....
What if i set the recovery model of this DB to full , would I be able to recover the DB to a specific point in time ,
or since trunc. log on chkpt. is true.. I would not be able to collec the transaction log backups ???
Cant understand this concept , need some link to read this stuff ....
Thanks
How to trunc (truncate) a table using enterprise manager?.
no trunc like toad in enterprise manager?.....
Can someone confirm that setting a db to use the simple recovery model in sql server 2000 is the same as setting a db to user trunc. log on checkpt. and select into/bulk copy on sql server 7?
View 3 Replies View RelatedHi all,
I've just started using SQL Server and I'm having problems trying to trunc dates. In my application I have a table with information about calls and I need to group them by hour, day, month and year, and I would like to do it exactly in the same way that PostgreSQL or Oracle do, for example:
trunc(to_date('22-AUG-03'), 'YEAR') would return '01-JAN-03'
trunc(to_date('22-AUG-03'), 'MONTH') would return '01-AUG-03'
I need to store that grouped information in another table, so I'm trying to get for example:
22-AUG-03 01:00:00,
22-AUG-03 02:00:00 for hours,
22-AUG-03 00:00:00
23-AUG-03 00:00:00 for days and so on...
I'm trying to use convert function but I cant get the information in the way I need it.
Any kind of help will be apreciated. Thank you very much in advance.
hi,
how can I trunc an shring a db transaction log?
thanks for reply....
My goal is to select values from the same date range for a month on month view to compare values month over month. I've tried using the date trunc function but I'm not sure what the best way to attack this is. My thoughts are I need to somehow select first day of every month + interval 'x days' (but I don't know the syntax).In other words, I want to see
Select
Jan 1- 23rd
feb 1-23rd
march 1-23rd
april 1-23rd
,value
from
table