stored procedure

[christianc]

Hi,

I have a stored procedure (job) that take data from several tables, and put then in another one (control panel table).
This job runs every day at night, and makes transaction log grows too much, and never shrink.

any idea?

thanks

[MAK]

do a
checkpoint
backup log with no_log
dbcc shrinkfile

[christianc]

yes , I do this every day.
What do you think about add this 2 lines at store procedure end?

thanks for all

[skhanal]

You can't run a DBCC command from stored procedure.

[MAK]

you can run if you have the right access.


create proc xtr as
dbcc shrinkfile (SNAR_Data,10)


exec xtr

[christianc]

Thanks