Ahhhhh ... it that case it worked for me too.

However, my understanding is that the watermark_value in the watermarktable should change if there is any updates to the the fields...

I welcome any additional thoughts on this question.

Please let me know if I need to provide any additional information for you to help me? Or if I haven't phrased the...

Do you mean to say, you entered the update and then executed:

ALTER PROCEDURE dbo.usp_write_watermark @LastModifiedtime DATETIME, @TableName VARCHAR(50)

AS

BEGIN

UPDATE [watermarktable]

SET [watermark_value] = @LastModifiedtime

WHERE [table_name] = @TableName

END;

GO

And it worked for you?

What do you mean, it worked for you?

However, when I execute my SP I get the following

But then no changes to to the watermark_value

When I run your code, I am asked to enter a date

I then enter 8/17/2022

And I get the following

The stored procedure is as follows:

CREATE PROCEDURE dbo.usp_write_watermark @LastModifiedtime datetime, @TableName varchar(50)
AS
BEGIN

UPDATE [watermarktable]
SET [watermark_value] = @LastModifiedtime
WHERE [table_name] = @TableName

END;
GO

Can I get your thoughts on this? I think the issue is with the stored procedure

ok, I executed usp_write_watermark, and still no change

Sorry, I meant to say it should do an update on store_customer, but as you can see it didn't update

Hi All,

I have also enlisted the help of the good people at Stack Overflow for help... I hope you're not affended.

https://stackoverflow.com/questions/73124553/cannot-resolve-the-collation-conflict-between-latin1-general-100-bin2-utf8-and?noredirect=1#comment129152730_73124553

I just figured out what line I was getting the error on:

Msg 468, Level 16, State 9, Line 244 Cannot resolve the collation conflict between "Latin1_General_100_BIN2_UTF8" and "SQL_Latin1_General_CP1_CI_AS" in the...

I tried this but I got the following err

FUNCTION 'OBJECT_SCHEMA_NAME' is not supported.

Hi David,

The person tha crafted the script checked out the tempdb, and it different to the database. However, when he changed COLLATE to match the database it still failed.

We are...

Hi Jeff,

Thanks for getting in touch.

I will take a look at the link, however I think I'm going to struggle as to where to apply the COLLATE clause