Thank You All for your help.

I am able to achieve what I was looking with few changes to the script.

I am sorry following is the right query.

SELECT * FROM tblNew a LEFT JOIN tblOld b

ON a.empId=b.empId WHERE a.deptId<>b.deptId

OR b.deptId is null

Thanks to both of you.

It worked perfectly for me.

Yes, I am declaring variables and then put the DELETEd table record(s) into the variables and then use them to record them to the deleted table.

CREATE TRIGGER [dbo].[DeptItemdelete]

...

Thank you.

I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

Thanks.

I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I can...

I have one more question. say we restore the DB on new server at 1 PM based on 1 PM full backup from Old Server on Monday and if the...

Thanks guys for your help.

I have replication and log shipping setup. So I am planning to create them back on new server as in the existing server.

Thanks.

I already have some publications on the server1. I am trying to create a new publication and new subscriber for a new set of replication.

After creating publication the snapshot agent...

When I run the following query I got the result 0 which means AlwaysOn Avaialability groups is disabled.

SELECT SERVERPROPERTY ('IsHadrEnabled');

Does that mean restoring on one Node is good enough?

Thanks.

Yes.

I tried the following and it worked.

GRANT CONNECT SQL TO [Testuser]

GRANT CONNECT ON ENDPOINT::"TSQL Default TCP" TO [TestUser]

Following is the error message is error log.

Login failed for user 'UserTest'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors.

Thanks.

Yes.I checked all of the above.I can see the logins work from rdp session,but not from the ssms from the local machine.