The solution provided by MS for SQL 2016 SP1 Standard Edition running on Windows Server 2012 R2 Enterprise Edition was

Make the following changes on both the principal and mirror server,...

It does break the chain if differential backups are being performed. Using the COPY_ONLY option is a good idea.

the condition could read as

where isnull(col_1,'1900-01-01 00:00:00') = isnull(@DateSubmitted,'1900-01-01 00:00:00')

I only see an issue where you have this date as default/a part of the data.

AM

try this:

DECLARE @DateSubmitted DATETIME

SET @DateSubmitted = NULL

SELECT * FROM TBL_A

 WHERE Col_1 = isnull(@DateSubmitted,col_1)

The count(*) will always give unique id's but the row data will have a dynamic id and not a static id. For a given row the id will be changing...

I'm making two assumptions here:

1. Table_B and Table_C have the same structure

2. These tables are not huge

DECLARE @I INT

SET @I = 1

SELECT *

FROM TABLE_A A,

     (select *,1 tblno from...

Run DBCC SQLPERF(LOGSPACE) before and after the "backup log ...." command to check if it has really been cleared or not. The percentage utilization of the log file for the "db"name...

you can also keep a copy of the msdb.dbo.sysdtspackages

1. copy msdb.dbo.sysdtspackages to another table say northwind..alldtspackages

2. copy the table across to the other server

on the destination server

3....

You have lot more locks than the server can handle.

Start SQL Query Analyzer, run a query that gives you the list of processes locking each other and kill the one...

Can you try the following and see if it returns the expected result set

SELECT T1.*, T11.PROPERTY_ID

FROM PSSL_T_REVISION_HISTORY T1

, PSSL_RESERVE_ENTITY T11

WHERE T1.PROJECT_ID =...

Can you try the following and see if it returns the expected result set

SELECT T1.*, T11.PROPERTY_ID

FROM PSSL_T_REVISION_HISTORY T1

, PSSL_RESERVE_ENTITY T11

WHERE T1.PROJECT_ID =...