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

deifinetely but why dont you give a try and post what exactly are you expecting in terms of...

try running sqlwb.exe in run command or search in

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE

if it is not available try installing client components from SQLserver instalation CD.