This is some standard code I am executing from time to time:

SET IDENTITY_INSERT [Issue] ON
IF EXISTS(SELECT * FROM Test.dbo.Issue)
	 EXEC('INSERT INTO Issue  (
[Date],[Released],[Url],[Numero],[AddUser],[AddDate],[ModUser],[ModDate])
		SELECT [Date],[Released],[Url],[Numero],[AddUser],[AddDate],[ModUser],[ModDate]
                   FROM [Issue] WITH (HOLDLOCK TABLOCKX)')
SET IDENTITY_INSERT [Issue] OFF

If I do:

SELECT * FROM Test.dbo.Issue

I have some records.

If I do:

SELECT * FROM Issue

I have no record, which is normal.

So, the goal here is to populate the table Issue from the one containing records from the Test database. However, when I execute that, there is no error but no record gets inserted. What am I missing?