Viewing 15 posts - 436 through 450 (of 458 total)
Stephanie Giovannini (4/12/2012)
Try adding SET NOCOUNT ON in the top of the trigger body.http://stackoverflow.com/questions/4982403/sql-server-update-trigger-not-unique-insert-issue
That did it (bowing and scraping in admiration) - of course, now I feel like an idiot,...
April 12, 2012 at 1:55 pm
Lowell (4/12/2012)
the trigger has no WHERE statement, and never references inserted or joins to the remote table...does that remote table only have one row?
Yes, sorry, I should have noted that....
April 12, 2012 at 12:36 pm
Lynn Pettis (4/12/2012)
Any triggers on the other table? If so, could you post it also?
No, the only trigger is the one I posted. It updates the DateLastChanged (DatumPosledniZmeny) field...
April 12, 2012 at 11:39 am
Lynn Pettis (4/12/2012)
Any error messages? If so, the complete error message(s) would be helpful.
Yes, that was in my initial post:
"The row value(s) updated or deleted either do not make...
April 12, 2012 at 11:34 am
Lynn Pettis (4/12/2012)
Yes, post the definitions. We can't answer your question(s) when we can't see what you see.
Okay, here they are.
The trigger in A:USE [PaleoDataProPokusy]
GO
/****** Object: Trigger [dbo].[tr_DatumZmenyPaleontologie]...
April 12, 2012 at 10:51 am
SQLRNNR (2/28/2012)
InOverYourHeadBase
Boy, do I have the corner on those.
February 29, 2012 at 1:32 pm
Interesting idea. What all parameters of these constructs should be part of the descriptive vocabulary? Size, speed, complexity, efficiency, stability, level of automation, time in service, scalability, maintainability, hardware environment,...
February 25, 2012 at 1:06 pm
homebrew01 (2/10/2012)You can quickly & easily set up maintenance plans to do frequent full and transaction log backups. That will get you out of the "manual" business and give...
February 11, 2012 at 5:21 am
GilaMonster (2/10/2012)
The one I posted is not an article, it's a full-blown 340 page book.
Yes, it is a book, and I just download the PDF version of it from the...
February 10, 2012 at 12:58 pm
Grant, Gail, thank you for the links. I spend a great deal of time on this site, reading as much as I can absorb, but there is so much. It...
February 10, 2012 at 11:35 am
Grant Fritchey (2/10/2012)
I just started working on an article on the backup header, ...
Yay! I'm almost completely out to lunch on the subject of backups. I've been doing a full...
February 10, 2012 at 8:51 am
My two cents worth: there really isn't any need to have the word 'Column' in your column definitions. It just clutters up your SQL.
January 31, 2012 at 3:51 am
Elliott Whitlow (1/27/2012)
pdanes (1/27/2012)
Are you planning to have any Teaming done with your NICs?
Sorry, I have no idea what that means.:ermm:
NIC Teaming is where at least a pair of NIC...
January 27, 2012 at 10:04 am
Roy Ernest (1/27/2012)
January 27, 2012 at 8:07 am
Roy Ernest (1/27/2012)
How many IO channels do you have in the server that you have? Do you have any additional IO card?
I'm not sure - how do I find out?...
January 27, 2012 at 6:38 am
Viewing 15 posts - 436 through 450 (of 458 total)