Viewing 15 posts - 1,396 through 1,410 (of 2,462 total)
USe
set ansi_warnings off
above your code
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 12:15 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 24, 2010 at 11:38 pm
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 24, 2010 at 11:23 pm
marerose888 (8/24/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 24, 2010 at 9:55 pm
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 23, 2010 at 4:27 am
Try this
declare @RICLST varchar(8000)
set @RICLST ='XS0256312264=MSXL,XS0473293701=MSXL,USP5880CAA82=MSXL,XS0442190855=MSXL'
select '''' + replace (@RICLST , ',', ''',''') + ''''
PRINT @RICLST
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 23, 2010 at 4:12 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 23, 2010 at 2:07 am
Duplicate post
Reply on http://www.sqlservercentral.com/Forums/Topic973194-146-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 23, 2010 at 2:02 am
Jim McLeod (8/22/2010)
Bhuvnesh (8/22/2010)
Jim McLeod (8/22/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 22, 2010 at 10:49 pm
Jim McLeod (8/22/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 22, 2010 at 9:53 pm
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 22, 2010 at 12:52 am
Thanks Rohit, Well i don't think changing sequence avoided this deadlock.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2010 at 3:39 am
Stefan_G (8/20/2010)
I have made some tests and for some of my large tables creating a second identical index is 3 times faster than creating the original index.
i will take...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2010 at 1:55 am
Rohit few things .....
First,
Ramji29 (8/20/2010)
I asked them to update the parent first and then insert into child (Although these two records are not related)
how ? as you told...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2010 at 1:52 am
90% of databases are inactive mode :w00t: ? i am also curiuos ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2010 at 1:28 am
Viewing 15 posts - 1,396 through 1,410 (of 2,462 total)