Viewing 15 posts - 15,736 through 15,750 (of 26,486 total)
I did set up an alert once for a test on something totally unrelated, and iirc, there was a delay between the event and the alert firing. I can't...
April 28, 2010 at 1:55 pm
The problem with truncating the t-logs is that it breaks the log chain. What other processes are running on the servers? If you are running t-log backups, they...
April 28, 2010 at 1:48 pm
I'm not too sure if I can be of much more help. I didn't use alerts to handle the failover between my principal and mirror databases, I chose to...
April 28, 2010 at 1:44 pm
Is the alert configured on both servers to run the script?
April 28, 2010 at 1:21 pm
Why are you truncating the t-log's? You should be running periodic t-log backups to manage the size of the t-log files.
April 28, 2010 at 1:07 pm
tas2k2 (4/28/2010)
April 28, 2010 at 12:10 pm
alen teplitsky (4/28/2010)
Lynn Pettis (4/28/2010)
Brandie Tarvin (4/27/2010)
April 28, 2010 at 8:30 am
Brandie Tarvin (4/27/2010)
April 28, 2010 at 8:18 am
In SQL Server 2008, just as with the DATE data type, this is also true of datetimeoffset and datetime2. If you have SQL Server 2008 available, try those data...
April 28, 2010 at 8:06 am
Going out a limb here, but I think it would continue working. The best thing to do is test this in a test environment and see what happens.
April 27, 2010 at 4:29 pm
It is based on the 0.0 in the comparision. If you change it to 0.00 it becomes numeric(2,2). Adding a second 0 before the decimal (00.00) doesn't change...
April 27, 2010 at 4:22 pm
It is attempting to do an IMPLICIT data conversion to numeric(1,1) and 1.5 would need to be defined as numeric(2,1). You need to use an explicit data conversion for...
April 27, 2010 at 4:12 pm
KT8177 (4/27/2010)
The following query will...
April 27, 2010 at 3:47 pm
Is this what you are looking for?
DECLARE @tier1 TABLE
(
T1ID INT,
T1Name NVARCHAR (255),
ButtonLoc INT,
live INT
)
INSERT INTO @tier1 (T1ID,T1Name,ButtonLoc,live)
...
April 27, 2010 at 3:40 pm
Like this:
select
UniqueId,
max(case when ParameterName = 'Parameter Name1' then ParameterValue else null end) as 'Paramater Name1',
max(case when ParameterName =...
April 27, 2010 at 2:12 pm
Viewing 15 posts - 15,736 through 15,750 (of 26,486 total)