Viewing 15 posts - 2,341 through 2,355 (of 7,502 total)
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...
February 11, 2011 at 2:21 pm
did someone mention cheap USB-dr.... :slap:
but .. but .. :slap-again-harder-and-harder:
😉
February 11, 2011 at 6:45 am
Craig Farrell (2/11/2011)
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
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...
February 10, 2011 at 2:11 pm
ah, indeed, that is essential.
thank you for the feedback.
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...
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 ?
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 --...
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.
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,...
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...
February 9, 2011 at 8:19 am
aslamnepanagar (2/8/2011)
I have also observed the 4 instances(multi instance server) , sqlserver.exe using around 1.7 GB memory.
They are never crossing 2 GB.
As mentioned above we are using a 32...
February 9, 2011 at 12:08 am
Every job can be done in a primitive way.
Just not as fast, smooth, reliable, agile, ...
Why I like sqlagent ?
- managebility
- security
- job history (no need to log...
February 8, 2011 at 2:03 pm
maybe this SSC art can get you started with dbmail http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/
February 8, 2011 at 12:17 am
Viewing 15 posts - 2,341 through 2,355 (of 7,502 total)