Content copied from Microsoft email: SQL Server 2019 is now available to preview. Take advantage of built-in advanced analytics and data lake capabilities and easily integrate data from multiple sources, including Oracle, MongoDB, and Teradata—without moving your data via extraction, transformation, and load (ETL). Learn more about this latest SQL …
Read More »
I received above errors during initial Data Mart Integration. Errors are appear in the Data Mart Integration log and Event viewer. To resolve the above error, we have to enable TCP/IP connection in ‘SQL Server Configuration Manager’. Please see highlighted text in the below screen. “Yours, Ravi Theja Madisetty …
Read More »
Most of my blog posts on which I confronted in my daily routine job. Our development team has reported an error they are getting an error screen while preview the SSRS reports from visual studio 2013. Error: Unable to preview the report, install the Microsoft SQL Server Data Tools – …
Read More »
Resolution: If you want to access development environment user must have proper rights on SQL server. Please refer TechNet Blog for more information. Follow below steps to assign rights for a user id to access Navision Development Environment: Open SQL management studio with SQL administrator ID. Expand the Security node, right-click Logins, and choose New Login. …
Read More »
select * from BATCHJOB; update BATCHJOB set status = 0 where status = 1; Or select * from BATCHJOB; update BATCHJOB set status = 0 where status in (1,2,3,4) “Yours – Ravi Theja Madisetty”
Read More »