That means max server memory is NOT set.

Please set max server memory to appropriate value.

Welcome. Happy to know that your problem is solved. Thanks for updating.

I don't think there is any relationship...

Please post the error message.

use <database>

go

select * from sys.sql_modules

where definition like '%abc%'

Why do want to decrease SQL Server memory? Do you have any other application on the machine which is having memory issue?

Have you set Max Server memory?

Unique Clustered Index does not allow duplicate values.

Single NULL value...

Try this:

UPDATE a

SET masuk = b.datang

from @FirstTable a

inner join

(select userid,convert(date,CHECKTIME,103) tgl,convert(VARCHAR(5),min(CHECKTIME),14) datang,convert(VARCHAR(5),MAX(CHECKTIME),14) selesai from CHECKINOUT

WHERE convert(date,CHECKTIME,103) >= @sdate and convert(date,CHECKTIME,103) <= @edate

group by userid,convert(date,CHECKTIME,103)) as b

on a.userid...

Yes.

Because when i was tried in a sample table without primary key. and cluster index it was creating and...

Is the existing instance a default instance?

Is the new instance a named instance?

BOL:

When specified, this option causes the Database Engine to disable automatic statistics rebuilding.

No VLFs would be truncated.

select log_reuse_wait_desc from sys.databases where name = '<dbname>'

would return "ACTIVE_TRANSACTION"

Granting SELECT permission on a table

The following example grants SELECT permission to user RosaQdM on table Person.Address in the AdventureWorks database.

USE AdventureWorks;

GRANT SELECT ON OBJECT::Person.Address TO RosaQdM;

GO

Denying SELECT permission on...

Yes. You can restrict aceess to individual tables with GRANT/DENY command.

It means, in the subscriber, there is already a row with primary key value.

You need to fix that row.

After that replication should continue without any issue.

The reason is query 'exec master..xp_FileReadStart @PARAM_FILENAME, @nHandle output' would be executed under a new session.

The variable @PARAM_FILENAME is not visible in this new session.