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...

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...

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...

Is the alert configured on both servers to run the script?

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.

tas2k2 (4/28/2010)

---

I have set up SQL Server 2005 mirroring(with principal, mirror and witness) and have configured for automatic failover, but before the mirror can be used as the principal I...

alen teplitsky (4/28/2010)

---

Lynn Pettis (4/28/2010)

---

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if...

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The...

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...

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.

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...

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...

KT8177 (4/27/2010)

---

I ran into this recently when I was troubleshooting some queries. This is a simple example but I don't understand why the error is occuring.

The following query will...

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)

...

Like this:

select

UniqueId,

max(case when ParameterName = 'Parameter Name1' then ParameterValue else null end) as 'Paramater Name1',

max(case when ParameterName =...