Viewing 15 posts - 1,981 through 1,995 (of 2,894 total)
We would like to help, but please help us first to clear understand your question and get us going. Here is an article about how to do it on this...
March 8, 2012 at 3:47 am
That is how you should present this sort of question:
I have a Table as per:
create table #tbl_Duplicates
(pk_ResId int not null,
i_Number int,
ReservationId int)
-- sample data
insert #tbl_Duplicates select...
March 8, 2012 at 3:43 am
Could you please follow directions described in "The One":
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 8, 2012 at 3:36 am
Beginner_2008 (3/7/2012)
...Ya
I need to send an email to the customer whenever update occurs.
Thanks
Again, don't do it in a trigger.
Do you have to report update which happen via some...
March 8, 2012 at 3:20 am
It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to call xp_sendmail from a trigger...
March 7, 2012 at 3:11 pm
Lisa Slater Nicholls (3/7/2012)
jcb (3/7/2012)
Sometimes bizarre or non trivial requirements arrive at my desk and sometimes they are valid.
And sometimes they are just misunderstood.
[..]
a) Check if is feasible to drop...
March 7, 2012 at 3:00 pm
just an idea:
select *, (row_number() over (order by [object_id],[column_id]) - 1) /99 as FileNo
from sys.columns
As you can see, data in the table will be given incrementing FileNo for the froup...
March 7, 2012 at 10:53 am
You can check if your database ever was backed-up:
SELECT Database_Name,
CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup
FROM MSDB.dbo.BackupSet
WHERE Type = 'd'
GROUP BY Database_Name
ORDER BY Database_Name
March 7, 2012 at 10:42 am
Shree-903371 (3/7/2012)
March 7, 2012 at 10:02 am
Well done!
--1. you need some thing to uniquely identify each record and enforce the order
-- in which running total can be calculatedm based on your example,...
March 7, 2012 at 9:24 am
Having a SQL trigger sending email when data is changed is not a good idea.
However, you may still want to get email ASAP, faster than periodic job...
You can follow...
March 7, 2012 at 9:02 am
Thanks for posting DDL and data samples, only one thing is missing:
expected results. What exactly do you want to see based on your setup
March 7, 2012 at 8:54 am
Sean Lange (3/7/2012)
Eugene Elutin (3/7/2012)
Sean Lange (3/7/2012)
Eugene Elutin (3/7/2012)
You will need to drop your table before doing so.
The next...
March 7, 2012 at 8:52 am
Yep that is right, transactional replication will not work.
Snapshot and merge replications will still work just fine.
Just was working on setting up one...
March 7, 2012 at 8:49 am
Sean Lange (3/7/2012)
Eugene Elutin (3/7/2012)
You will need to drop your table before doing so.
The next option is to batch...
March 7, 2012 at 8:43 am
Viewing 15 posts - 1,981 through 1,995 (of 2,894 total)