35 servers, 42 instances on those 35 servers, 84 database on those 42 instances.

All servers are on virtual environment (vmware)

all backups store in SAN drive (LUN) D:\drive for all of...

it works

this should help

https://www.simple-talk.com/sql/learn-sql-server/sql-server-sequence-basics/

How big is the transaction log? How often do you perform transaction log backups? did you check if you see anything in error logs or event viewer ? check whether...

Below query gives error message: Incorrect Syntax near 'NULL' on Last line of the code

SELECT

DISTINCT IsNull(Employee.[Emp_no], Class.[Emp_no])

FROM

Employee

FULL OUTER JOIN

Class

ON

IsNull(Employee.[Emp_no], '') = IsNull(Class.[Emp_no], '')

ANDIsNull(Employee.Org_Code, '') = IsNull(Class.Org_Code, '')

ANDIsNull(Employee.Org_Num,...

so both of this query works:

;WITH

CTE1 AS (

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT

SELECT [Emp_no.], Org_Code, Org_Num FROM #Class

), CTE2 AS (

SELECT [Emp_no.], Org_Code, Org_Num FROM #Class

EXCEPT

SELECT...

I think i understood that part where i have to setup permission on both the domains. My challenge is what permission i am setting and where exactly i am setting...

thought it should be fairly simple to display one result with two queries or combining two queries

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT

SELECT [Emp_no.], Org_Code, ISNULL(Org_Num,0) FROM #Class

-- get rows which...

don't know anything about CTE's

i tried this query after reading some articles but it does not work

;WITH CTE1 AS SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT

SELECT [Emp_no.], Org_Code, Org_Num FROM...

Looks like this query displays the correct result but it display on separate window. i want one query which will show me one result:

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT

SELECT...

below query gives me wrong result , it seem to list all the values

SELECT

*

FROM

#Employee Employee

FULL OUTER JOIN

#Class Class

ON

IsNull(Employee.[Emp_no.], '') = IsNull(Class.[Emp_no.], '')

ANDIsNull(Employee.Org_Code, '') = IsNull(Class.Org_Code, '')

ANDIsNull(Employee.Org_Num, '')...

wish this can be done easily with single query :

actually this query provided by previous user does work:

SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Employee]

EXCEPT

SELECT Emp_no, Org_Code, Org_Num FROM [dbo].[Class]

-- get...

Chris i believe your solution will work with except between two queries. One major problem with 3rd column comparision. In first table value of 3rd column is 0 but in...

it is on same server but the 3 columns we are comparing have different names in both tables, not sure if that can be the issue

Chris, Looks like you solution might work. Only point i forgot to mention was that both the views(tables) are in different database