You dont need two db's for merge, you could create a linked server and run a merge between production and warehouse via the linked server to save loading the table...

You have datatype mismatches all over that proc.

COD_TP_CLASSIFICACAO is an INT but your passing in a BIGINT

FICHEIRO is VARCHAR(255) and your passing in a VARCHAR(500)

Also you will need to delcare...

RIGHT('0000'+STORE,4)

Or you could look at the Stuff function.

you seem to have additional ' which dont seem to be required, try this instead

SET @STRSQL ='INSERT INTO '+@DB+'.DBO.SINCRONISMO VALUES('+@DATA4+','+@DATA5+',I,'+@CLASSIFICACAO+','+@user+',NULL,'+@NOMEFICHEIRO+','+@CODRF+',NULL,'+@FIM+',0)'

No remote errors display in the webpage of SSRS. So instead of it saying Error cannot connect, it gives more details as to why it cannot connect for example.

Blank...

would need to see the definition of SGCTCentral.DBO.SINCRONISMO

This is one way

SELECT

Store+

RIGHT('0'+CAST(DATEPART(DAY,GETDATE()) AS varchar),2)+

RIGHT('0'+CAST(DATEPART(MONTH,GETDATE()) AS varchar),2)+

RIGHT(DATEPART(YEAR,GETDATE()),1)

FROM

sometable

Now what happens when you get to year 2022? As you will get the same invoice number again.

Any particular error messages? What exactly is not working for B that is working for A? Do you have remote errors enabled on the SSRS server to get...

Why not leave the front end in Access and just upscale the data into SQL, saves re-developing the front end.

Something blocking you from updating the metadata perhaps.

Try modifying a proc, and when it is waiting run sp_who2 or query sys.dm_exec_sessions & sys.dm_exec_requests for the spid your altering the proc...

Sounds like something has changed the authentication mode of the server from mixed to Windows only and forced a reboot of the service which wont allow you back in over...

How is the filename generated?

Out of interest, did you use services.msc or SSCM to change the service accounts?

If services.msc, remove the user from the admin group and use SSCM to change the service account...

You would have to set the fileattachments property of the send mail task to an expression which takes in the dynamic filename.

Is the filename generated already within the SSIS package...

Service packs are version specific but not edition specific

So, you can get SQL 2008 SP2 and this will apply to SQL 2008 Standard, Enterprise, Express etc

But if you got SQL...