Thanks a lot for your reply.we have implemented regular log backup and restricted that issue now.

Still we want to avoid log full situation if backup log is not working .Here...

Thanks a lot for sharing this script.is there option to consider disk space as well since my production log file growing because of full recovery mode.

Thank you sir.

Right now We have achieved by calling UDF.I want to know whether is it poassible through stored procedure.

Create Function dbo.Result(@TranId int)

Returns @t Table(@col1 varchar(10),@col2 Datetime)

Begin

Insert into @t...

Sorry for the uncleared question.Here I will Call stored procedure 'B' from 'A' by passing one parameter.Based on the parameter value ,the Stored procedure B will retrun data multiple...

Sorry for the wrong answer.

1.

CREATE VIEW [dbo].[Employee]

AS ...

What's the definition of the Employees view?

we have read permission to read all columns in the table belong to EmployeeInfo DB

Which table do you want to index?

TTrtrans Table. I think...

Thanks Gail.please find my query below.In that TrEmployee is view derived from another Database and rest are table belongs to one database.

SELECT ...

Thanks a lot Michael.But problem still exists for my case.I have created view for the table from other database instead of same database.So i need to write query like below.

CREATE...

Once again thanks a lot.

Can you provide some sample for lock in sql server 2005.please...

Thanks you sir.

Yes ,Right now we have followed the second one (Optimistic concurrency) by checking employeeid column i.e if it is...

Thanks a lot. Here i have provided some sample data of my production .Below customer data will be displayed to all users in their front end application(.net grid).Now one user...

Soory for the unclear message of mine .Actually a common queue maintained about customer data displayed in .net(Grid control) environment ,will be accessed by around 50 users .In that scenario,...