DBA team defined the structure and we are not supposed to change it as it is in production..

SELECT @MAX_ID = MAX(PARAM_TYPE_ID) FROM LKP_PARAM_TYPE

IF@MAX_ID IS NULL

...

Msg 2627, Level 14, State 1, Line 10

Violation of PRIMARY KEY constraint 'XPKLKP_PARAM_TYPE'. Cannot insert duplicate key in object 'dbo.LKP_PARAM_TYPE'.

The statement has been terminated.

Thank u so much 🙂

Hi ,

I Dont have .mdf and .ldf files tooo 🙁

I have only Transaction Log file and Data File

Is it possible to restore db ?

Please help me...

To my surprise ,when I select Functions alone all the functions scipt is generated,Sme is the case with SP's.

But when I Generate Script for entire DB or Select both functions...

Functions and SP's whihc are missing in the script are not encrypted one's

they are missing in the script..

Thank u ..

thanks so much

Thanks So much 🙂

Hi ... can any1 pls help . .

HI I HAVE POSTED QUESTION AGIAN.. PLS REPLY

CREATE TABLE [dbo].[TableTemp](

[BASEL_CATEGORY] [varchar](50) NULL,

[EC_DRAWN] [numeric](18, 6) NULL,

[EC_UNDRAWN] [numeric](18, 6) NULL,

[EC_DRAWN_R] [numeric](18, 6) NULL,

[EC_UNDRAWN_R] [numeric](18, 6) NULL,

[EC_DRAWN_S] [numeric](18, 6) NULL,

[METHOD] [varchar](10) NULL

) ON [PRIMARY]

INSERT INTO [dbo].[TableTemp]

...

Hi I have edited the question please reply me its very urgent

Thanks so much . gt it 🙂