DECLARE @T TABLE ( NAME VARCHAR(20), PWD VARCHAR(20))

INSERT INTO @T

SELECT 'Mary' ,'At connect'

select CAST(datalength(name) AS VARCHAR) + left (pwd,4) from @T

USe

above your code

First of all, what kind of and why you want to create index to track update/insert operation ?

and to answer your query , there is an dmv might help...

first you need to check the connectivity with

select * from [linkedserver].[databasename].[databaseoowner name].tablename

Additionally, did you get any error when u executed your Sp ?

marerose888 (8/24/2010)

---

Boy I am with you on that one. I have been researching for several hours all over the internet and I can't find a sql plan that works....

Correct "ON clause" columns as per requirement

ALTER TRIGGER [dbo].[ApptTranTrig5]

ON [dbo].[Appointment]

AFTER UPDATE

AS

IF UPDATE(AppointmentStatusUID)

BEGIN

SET NOCOUNT ON;

INSERT INTO dbo.AppointmentStatusTransactions

(

AppointmentUID,

AppointmentStatusUID,

PatientUID,

ServiceSiteUID,

StatusStartTime,

StatusModifiedBy

)

SELECT

i.AppointmentUID,

i.AppointmentStatusUID,

i.PatientUid,

i.ServiceSiteUID,

i.LastModifiedDate,

i.LastModifiedByUID

FROM INSERTED i INNER JOIN

[dbo].[Appointment] A ON

A.AppointmentUID = I.AppointmentUID

Try this

declare @RICLST varchar(8000)

set @RICLST ='XS0256312264=MSXL,XS0473293701=MSXL,USP5880CAA82=MSXL,XS0442190855=MSXL'

select '''' + replace (@RICLST , ',', ''',''') + ''''

PRINT @RICLST

i dont think there is any linkage between these two . any specific reason or requirement ? or your are taking about "REPAIR_REBUILD"

which does minor repairs and also rebuilds...

Duplicate post

Reply on http://www.sqlservercentral.com/Forums/Topic973194-146-1.aspx

Jim McLeod (8/22/2010)

---

Bhuvnesh (8/22/2010)

---

Jim McLeod (8/22/2010)

---

a 5 GB non-clustered index normally requires an extra 5 GB of space in the data file to rebuild it because it doesn't drop the...

Jim McLeod (8/22/2010)

---

a 5 GB non-clustered index normally requires an extra 5 GB of space in the data file to rebuild it because it doesn't drop the index until the...

removed

Thanks Rohit, Well i don't think changing sequence avoided this deadlock.

Stefan_G (8/20/2010)

---

i will take...

Rohit few things .....

First,

how ? as you told...