what do you mean by "after power cut.". is it connected to proper backup supplies?.

what is the sql error log and windows logs says, post that as well.

yes, i have even tried it with the sp with parameters and checked the sp which is calling this also.

i cant find any issue as most of them works fine...

No, for some empcode and date combination the output is right for some it is wrong.

thanks, will check

just a doubt this will have to slow down my query why my output has to vary?

ALTER PROCEDURE SP_Name

( @empCode VARCHAR(10), @date DATETIME )

with encryption

AS

BEGIN

open symmetrickey code part

SELECT dbo.Decrypt(EmpCode), dbo.Decrypt(EmpName),

CASE LeaveType WHEN 'ON DUTY' THEN 'OD'

WHEN 'Paternity' THEN 'CL'

WHEN...

Nolock is not used.

we havent used inbuilt function also.

there is date conversion and comparison between a table column and input parameters.

i forgot to mention it is compared with a encypted...

try truncate table option after your necessary records backup

Can you post "Disk usage by top tables " top 5 tables complete data from the report.

Try shrinking the...

dhechle (11/8/2012)

---

Hi Markus,

I have rebuilt all indexes on msdb database and still no change. symail_mailitems is still telling me it is the largest table at 6,439,200 KB the next...

It is a 32 bit system, thanks for your input gail.

yes, my miss.

why not put it on forum for others to see.

sanket kokane (10/31/2012)

---

you can restrict the tempdb log file size ,so that it will stop growing and log file will get reuse .

and then you can try to shrink .

also...

check if this helps

exec msdb.dbo.sp_help_job

try using inserted or deleted table within the trigger to populate the neccesary flow