I am currently at a client that is using HP SANs and is using disk mirroring for DR. Mirroring is at the partition level. I performed a DR test...

Question One:

In table Lookup is column Date_Range really one column containing the characters

'01/01/2001 - 12/31/2001' ?

If so, you need to change the lookup table to have 2 columns, Date_Range_Low

and...

It is a SQL Server BUG that is fixed in Service Pack 4

FIX: A parallel query may return unexpected results

http://support.microsoft.com/default.aspx?scid=kb;en-us;814509

SYMPTOMS

When the following conditions are met, a parallel query may return...

Another thought:

Is table (TLog) supposed to be the status of the processing by the procedures ?

If so, try adding a isolation level hint to allows selecting of rows that are...

Let's simplify your problem with this test case. At the end, you will know how to determine blocks and locks that exists in the SQL Server instance.

Open SQL Query Analyzer...

If you do not allow emails from your SQL Servers, then how do you expect Quest's Foglight tool to notify you of problems ?

Have you seen the hardware requirements for...

You can also get these symptons when autogrow is enabled, so that when the file needs to increase in size, everything stops.

See http://support.microsoft.com/kb/305635/EN-US/ for more details on your cause and...

Great article Don.

As the insufficiencies of XML became known, another solution has come forward.

"The Resource Description Framework (RDF), which integrates a variety of applications using XML for syntax and Universal...

If you have a MS exchange server in the same domain as your SQL Servers, then each job can send a status email or a page to a distribution list.

For...

Please be aware that implimenting this requirement via triggers is a very bad idea because if any of the remote databases are not available, the local trigger will not allow...

I had previously been a IBM Mainframer using Cobol, CICS, IDMS and DB2 when I finished a project and was given a new assignment. Turned out to be Unix...

I managed to get my local copy of SQL server to reproduce your problem.

Try the following in SQL Query Analyzer

DECLARE @datevar datetime

SET @datevar = '01/02/2005'

SELECT @datevar

The output should be 2005-01-02...

So you want the condition of null = '' to be true?

I strongly recommend that you fix the data and not try to do this with ISNULL = ISNULL

See below...

Just made a few adjustments that are bracketed by "--CCF-START"

and "--CCF-END"

CREATE PROCEDURE ecomm_addNewCus(

@contact char(40), --First Name & Last Name

@cus_name char(40), -- Company Name

@addr_1 char(40),

@addr_2 char(40),

@city char(26),

@state char(4),

@zip char(10),

@country char(20),

@phone_no char(20),

@phone_ext...

"No Downtime" is not possible since only one of the servers can be up and any one time with the same name, the DNS and server rename are required...