Could u please tell me how to start the server with traceflag 1400.

Thanks John.

The site you have given is not opening. So

So

Please give me solution.

Thanks for suggestion.

Table definition is like that

CREATE TABLE [dbo].[StateDet](

[StateID] [int] NOT NULL,

[StateDetID] [int] IDENTITY(1,1) NOT NULL,

[ItemTypeID] [int] NULL,

[ToStateID] [int] NULL,

[TaxStructureID] [int] NULL,

CONSTRAINT [PK_StateDet] PRIMARY KEY CLUSTERED

(

[StateDetID] ASC

)WITH (PAD_INDEX =...

Thanks for help.

But If talk about join then common column should be indexed always.

Its right isn't? whether the table contain data or not.

I am wrtting a trigger on emp table

and passing the value in empdet table

I have tried to write as follows but its working...

CREATE TRIGGER LEAVE_TRIGGER

ON EMP

FOR insert,UPDATE

AS

DECLARE @LEAVE INT

DECLARE @EMPID INT

BEGIN

insert into EMPDET values (@empid,@leave)

update emp set emp.leave = emp.leave-@leave

from...

Thanks for reply.

Hi,

No any message written to the SQL Log/ SQL Agent Log.

yes, the SQL Agent running.

...

Could u tell me that how I can set datetime datatype in yyyy-mm-dd format.

I know that query but problem was different.

Hi ,

I am using sql 2005.

Hi

I resolved my problem.............

Thanks