I Goggled about "sp_getapplock"

This approach has some downsides

1) Other users can’t SELECT from the table.

2) If you rebuild indexes on the table with the “online=on” option, it...

Thanks Tom and Gila for your valuable suggestions 🙂

Then what's good approach to do resolve this issue in sql server 2005?

suggestion pls.

As per your opinion which approach should be use to resolve this issue ?

That will be not create problems in future.

Can you tell as above option effect on SOL performance ?

Below script will work in this case or not

CREATE TABLE TEST_UQ (COL1 INT IDENTITY(1,1) PRIMARY KEY, COL2 VARCHAR(10) NULL,COL3 AS (CASE WHEN COL2 IS NULL THEN CAST(COL1 AS VARCHAR(10)) ELSE...

Can you mention a example or a dummy script which create a indexed computed column?

Can you explain it as in sql form as below

CREATE TABLE dbo.Example

(

col1 varchar(100) NULL,

);

GO

CREATE VIEW dbo.ExampleUnique

WITH SCHEMABINDING AS

SELECT e.col1

FROM dbo.Example AS e

WHERE e.col1 IS NOT NULL;

GO

CREATE UNIQUE CLUSTERED INDEX cuq

ON...

Can you please share other approach to do this easiest way in sql server 2005?

Your suggestion works for me

Thanks Tom

Previous section is works fine when 'col1 int NULL'

I am creating CLUSTERED INDEX by running below query on sql server 2005

CREATE TABLE dbo.Example

(

col1 varchar(Max) NULL,

);

GO

CREATE VIEW dbo.ExampleUnique

WITH SCHEMABINDING AS

SELECT e.col1

FROM...

Can i apply this approach for column which is varchar type?

How can i do it with sql server 2005

Yes i need this thanks for your help