thanks Sue, I did make the transactional replication working between SQL 2008R2 publisher with SQL2017 distributor and subscribers. I always uses script other than GUI, that's why I was confused...

Don't know whether is this you looking for. You can always use print to print out the query to check.

DECLARE @sql_str nvarchar(max)

DECLARE @RNum varchar(max)

DECLARE @County varchar(max)

DECLARE @Year varchar(max)

SELECT @sql_str =...

You can't change an existing column to identity, but you can have two options:

1.create a new table with identity column, then insert value from your old table(Table1)

2.create a column in...

Thanks for all your reply.

Probably, I need add a date format field on my template table, and using SET DATEFORMAT at the beginning of the dynamic query and try ISDate()...

Hi Michael,

The project is loading a csv file into a staging table...

Gianluca Sartori (6/5/2012)

---

You could use the parse function in this article[/url] and tweak it to return NULL in case a bad date is found.

However, that would require changing the function...

Can you establish a PPTP connection between the client and the server router? Nowadays, most of serve router can act as a PPTP server, If you can do this, connecting...