Viewing 15 posts - 2,341 through 2,355 (of 7,502 total)
a trigger is declared on an object and objects don't share triggers (afaik).
So you'll end up creating the trigger ( same or different content ) as n triggers, at...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 12, 2011 at 11:18 pm
1) are the spaces ( after % and before the second % ) in your patindex needed ?
2) I would use datalength(pattern) in stead of len.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 12, 2011 at 12:02 pm
This is my ref url for mirroring:
http://support.microsoft.com/kb/2001270
monitoring state changes
http://msdn.microsoft.com/en-us/library/cc966392.aspx
Follow up is based on these scripts:
/*
* DB Mirroring : followup
*
*/
/* show mirrored databases and their mirror-state */
Select db_name(database_id) as...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 12, 2011 at 11:59 am
Like Sean stated, many of us have been bitten by the "single row situation"-design of many triggers.
You should ( and I don't like to use "always" nor "never") in all...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2011 at 2:21 pm
did someone mention cheap USB-dr.... :slap:
but .. but .. :slap-again-harder-and-harder:
😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2011 at 6:45 am
Craig Farrell (2/11/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2011 at 4:08 am
Why all that hassling with varriables ?
CREATE TRIGGER Trg_CustomerCommand
ON Customer
AFTER INSERT
AS
BEGIN
/* please add comment here */
Insert into Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled],[SentDate],[ACKDate],[ResponseDate],[TimeoutDate],[SecurityUserID],[InterfaceHardwareIdentifierUsed])
Select DTCreated,'5',TreaterID + LocalID,'0','0','False',NULL,NULL,NULL,NULL,NULL,NULL
from inserted
WHERE CloudID IS NULL
END
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2011 at 1:48 am
Keep in mind "inserted" and "deleted" objects only live _in_ the trigger.
Meaning, you cannot use that in "regular" tsql.
objects "inserted" and "deleted" have the same layout as the object you...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2011 at 2:11 pm
ah, indeed, that is essential.
thank you for the feedback.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2011 at 8:29 am
I'm not at the office today, but I'll check it tomorrow.
It has been a setting where you'd have to add users to a windows db2 group ( it created that...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2011 at 8:26 am
ChazMan has a good point.
- Can you post the sproc ddl ?
- did you schema qualify all objects addressed withing the sproc ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2011 at 1:26 pm
double check your sql server errorlog file !
I use these scripts to troubleshoot dbmail:
use msdb
go
/* is dbmail config activated ? */
Select *
from sys.configurations
where [name] = 'Database Mail XPs'
go
exec sysmail_help_queue_sp --...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2011 at 12:53 pm
that auth remark rings a bell.
If I recall correct our DB2 (udb gateway for z/os) admins granted read on the IBM folder (and subsequent folders) to authenticated users.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2011 at 12:16 pm
GilaMonster (2/9/2011)
ALZDBA (2/9/2011)
GilaMonster (2/9/2011)
To put things in context, my desktop (which I'll be using for this) blue screened this morning then, on reboot failed POST repeatedly.
Am hoping it's a once-off,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2011 at 12:06 pm
GilaMonster (2/9/2011)
To put things in context, my desktop (which I'll be using for this) blue screened this morning then, on reboot failed POST repeatedly.
Am hoping it's a once-off, or easy...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2011 at 8:19 am
Viewing 15 posts - 2,341 through 2,355 (of 7,502 total)