yes it shows red dot but it does not stop on that

thanks

thanks ,but that was the scenario for sql7.0 but now plz suggest how should i proceed the scnerio is

it is not showing any new diagram made by some developers...

no that was mistake but it is giving same error

thanks

Thanks Prasad,but here i am looking for performance issue not syntax

Thanks

Thanks Amit

but what i understand this extended property will be on column base ,Can i apply this for table level also?

This is not schema and db is same but you can say table spaces,bcz i only need the identifications of tables,which is transactional,customizationa etc .plz suggest

Actually i am integration GP with .Net thats why i have to go this ,one way could be like i generate the script and run the script at client end...

Thanks Markus i was looking for the name of MS03-031  8.00.818

Frank Don't u have any solution for this....

Thanks

Frank ur right to use c2 auditing but what i know is that in c2 auditing we can not instruct sql server to auditing for particular objects ,this facility is...

thanks MrSQL but actually this is not only disaster recovery ,i provided the total scenerio and expecting the proper way to handle the situation given above ,plz suggest if you...

but it will be taking more memory so performance issue could be at client side ,even if i want to see only the modification on my db ,it will be...

Thanks WZ700 it works

Situation is

if insert successfull it returns false

other wise returns 4 values

Frank should i do in this way(select statement)?

CREATE PROC CM_SP_InsCommonMaster

@CMD_V_CODE varchar(15),

@CMD_V_DESC varchar(50),

@CMD_C_INACTIVE char(1),

@CMD_D_INACDATE datetime,

@CMD_V_WONO varchar(6)--optional

as

declare @err int

insert into ZCM_CMD_COMMONMASTER(CMD_V_CODE ,

CMD_V_DESC,

CMD_C_INACTIVE,

CMD_D_INACDATE,

CMD_V_WONO )

values(@CMD_V_CODE ,

@CMD_V_DESC ,

@CMD_C_INACTIVE ,

@CMD_D_INACDATE,

@CMD_V_WONO )

set @err =@@error

if...