I am trying to create a stored procedure using SQL/400. I need to compare a date that I have converted to a character using the character function: CHAR(YEST2,ISO) (character version of yesterdays date) to an AS400 Date defined as DEC(8,0) also converted to Character. My reference bo...
'cannot access the file' when run as an SQL Agent Job (works when executed from BIDS) 'DECODE' is not a recognized built-in function name. 'DTEXEC.EXE' is not recognized as an internal or external command, 'gacutil' is not recognized as an internal or external command 'http://schem...
One of my Application server has been restarted yesterday, we would like to know how to find the login information and the IP details of the server. Please help me how to get the information who did restarted SQL services!Thanks in advance,DBADBAAll replies (5)Monday, February 13, 2017 1...
“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server [<Name of Missing Index, sysname,>] in non clustered index [Execute SQL Task] Error: The value type (__ComObject) can only be converted to variables of type Object. [ODBC Driver Manager] Data sourc...
Please refer to this case to clear the plan cache, but based on my experience, this will not affect the performance a lot in your scenario: https://stackoverflow.com/questions/1873025/how-can-i-clear-the-sql-server-query-cacheBest Regards,...
'cannot access the file' when run as an SQL Agent Job (works when executed from BIDS) 'DECODE' is not a recognized built-in function name. 'DTEXEC.EXE' is not recognized as an internal or external command, 'gacutil' is not recognized as an internal or external command 'http://schemas...
https://www.mssqltips.com/sqlservertip/2871/troubleshooting-and-fixing-sql-server-page-level-corruption/Thursday, October 27, 2016 9:19 AMHi delenne,As mentioned by Hilary, we can use dbcc checkdb to try to fix it.In your scenario, if you have the full backup in 13th and the ...
'cannot access the file' when run as an SQL Agent Job (works when executed from BIDS) 'DECODE' is not a recognized built-in function name. 'DTEXEC.EXE' is not recognized as an internal or external command, 'gacutil' is not recognized as an internal or external command 'http://schemas...
'cannot access the file' when run as an SQL Agent Job (works when executed from BIDS) 'DECODE' is not a recognized built-in function name. 'DTEXEC.EXE' is not recognized as an internal or external command, 'gacutil' is not recognized as an internal or external command 'http://schemas...
SqlError: Backup and file manipulation... must be serialized Backup Fails - System cannot find the file specified Backup of SQL database in Single user mode ? Backup stuck at 83% Backup suddenly very slow Backup to URL - The file name "http..." is invalid as a backup device name...