Viewing 15 posts - 2,341 through 2,355 (of 7,498 total)
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
jeff.mason (2/7/2011)
ALZDBA (2/7/2011)
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
Dear Lord, I HOPE...
February 7, 2011 at 12:48 pm
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
February 7, 2011 at 8:11 am
some more info regarding compatibility mode can be found at http://technet.microsoft.com/en-us/library/bb510680.aspx
February 7, 2011 at 6:16 am
Viewing 15 posts - 2,341 through 2,355 (of 7,498 total)