We made change in SP like this and tested in two locations 1st location with 15 - 20 user and 2nd location with 50- 60 user.

1st location we not...

As mentioned i made changes like this in sproc

CREATE PROCEDURE [dbo].[FetchDocumentID]

(@i_UserId int,

@i_ProjectId int)

AS ...

Can anyone tell me how to post attachment files.

Earlier we processed some testing and we deleted old data from that table.We never run update statistics after DB creation. Is it required to update table statistics.

First i updated Statistics of DataMaster table then try to execute the script that time getting error

Getting this error while execute the script

Msg 207, Level 16, State 1, Line 24

Invalid column name 'last_rows'.

Here is the Execution Plan

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.6000.34" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

...