GilaMonster (5/21/2013)

Maybe. Means that if the latest full backup is corrupt...

Thanks, IgorMi. It works.

@jeff Moden, this is earth, the most interesting place.

Thanks Abu Dina, Durai, Lowell.

All of your suggestions served my purpose well.

Thank you again, specially to Lowell for GUI help.

@Durai, you are right and your idea worked.

Thank you @Durai and Jack.

Actually the application was developed six years ago and I am working only eight months on it. So it...

In Sql 2000 I could apply these rules on specific tables using GUI mode. Is there any option like that in SQL 2008 R2?

That's a good SSPrank.

You are really SSCrazy. Thank for your help.

Can you please tell me the basic difference between FOR INSERT and INSTEAD OF INSERT Trigger.

I know there are lots of resources on it. But please tell me in...

Eugene Elutin (3/20/2013)

CREATE TRIGGER [dbo].[tr_Product_Discount]

ON [dbo].[Product]

FOR UPDATE

AS

BEGIN

IF EXISTS (SELECT 1 FROM inserted

WHERE...

CREATE TRIGGER [dbo].[Discount]

ON [dbo].[Product]

INSTEAD OF INSERT

AS

Declare @disc int;

Declare @line int;

Declare @pdid as varchar(10);

BEGIN

select @disc = i.DiscPercentage from inserted i

select @line = i.LineNumber from inserted i

select @pdid = i.ProdId from inserted...

Thank you, it helps me. I got the point.

I fixed it up. There was a problem in service accounts. Now its working fine.

Thank you, OPC.THREE

create table T1(

SL int NOT NULL IDENTITY (1, 1),

ISDN varchar(13) NULL,

MSG varchar(50) NULL

)

insert into T1(ISDN,MSG) values ('123','ABC');

insert into T1(ISDN,MSG) values ('123','ABC');

insert into T1(ISDN,MSG) values ('123','XYZ');

insert into T1(ISDN,MSG) values...

Thank you, Gila Monster.

That works

Yes, data type was a fact. I fixed it but still problem arises. So I think to install Microsoft OLE DB Provider for Oracle.

I configured linked server using "Oracle Provider for OLE DB" and tested connection. Everything works fine. When I execute insert command, the problem arises.

System Configuration:

Windows 7 Ultimate 64 bit

SQL Server...