Alt + Break

http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

1. SSIS/SSAS/SSRS are all part of SQL server

2. If your going to get a new server, and the SQL licences and hardware cost say £100k, on top of that you...

Never tried single user on a 2000 server so cannot comment.

If this server is 2000 then assuming you havn't remove BULTIN\Administrators from the SQL logins or removed that groups SA...

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?