Viewing 15 posts - 2,341 through 2,355 (of 7,504 total)
1) are the spaces ( after % and before the second % ) in your patindex needed ?
2) I would use datalength(pattern) in stead of len.
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...
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...
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
Viewing 15 posts - 2,341 through 2,355 (of 7,504 total)