This error doesn't occur when I remote into SSRS server but only when trying to browse thru reports or folders from another machine and it is sporadic.

While browsing folders or trying to create new folder.

Refresh didn't work

Yes it would need to update multiple files in the table.

Are you implying that I import the file received from third party to a table and then update each table...

I used this and it worked great, thanks for the help.

CREATE Trigger [dbo].[Test_UpdateTrigger_1] ON [dbo].[Department] FOR UPDATE AS

IF EXISTS (

SELECT i.ID

FROM Inserted i

JOIN Deleted d ON D.ID = I.ID...

Yes, got that part:

But how do I send out email ?

CREATE Trigger [dbo].[Test_UpdateTrigger_1] ON [dbo].[Department] FOR UPDATE AS

BEGIN

SET NOCOUNT ON

INSERT into Department_Audit(

[ID]

,[Department]

,

,Actionname,RowType)

(

SELECT

D.[ID]

,D.[Department]

,'Updated','Old'

FROM

...

But, wouldn't the T-log on new path will be attached to new full backup on new path?

Thank you for the reply.

What I did was stopped the T-log backup,changed the path of full backup to new path, executed it and then changed and ran the T-log to...

This is new implementation that we would be working on, the demo has data stored in database but the final product would store images on filesystem.

So, I was concern was...

Fixed it, log backup was not taken before.

Additional Information, log file have fixed size to grow e.g :10 GB

Ok that makes sense, because initially it had key lookup and after creating nonclustered index the cost came upto 100%

Is it ok to have 100% cost for in clustered index lolling at the execution plan ?

Or do you recommend anything else ?

Here's the one with create, insert and merge

So, during merge I would need "Last_update_file_DT " either in insert or update to be date 2 days before (for today's e.g: 08142016...

Will this help?

CREATE TABLE [dbo].[PP](

[PP_NUMBER] [varchar](10) NOT NULL,

[PP_CAR] [varchar](2) NOT NULL,

[PP_Tran] [varchar](1) NULL,

...