-
stored procedure
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
-
do a
checkpoint
backup log with no_log
dbcc shrinkfile
-
yes , I do this every day.
What do you think about add this 2 lines at store procedure end?
thanks for all
-
You can't run a DBCC command from stored procedure.
-
you can run if you have the right access.
create proc xtr as
dbcc shrinkfile (SNAR_Data,10)
exec xtr
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|