Tag Archives: SQL Server

Find Primary Key and Foreign Key Dependencies of Database Table in MS SQL

Posted on April 20, 2024 by chanmingman

This blog article shows you how to find dependencies of Database Table in MS SQL. If you get the SQL statement correct, then it is quite straightforward. The SQL statement below will give you the dependencies. SELECT                FK_Table = … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | Tagged , , , , | Leave a comment

A ‘R’ script error occurred during execution of ‘sp_execute_external_script’ with HRESULT 0x80004004. SQL Server

Posted on June 20, 2020 by chanmingman

This post shows you one of the possibilities to fix the above error when you are running R script. Back then I have tested the script runs in SQL Server 2017 when I have posted this https://chanmingman.wordpress.com/2019/03/17/machine-learning-service-in-sql-server-2017/. Somehow I bumped … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , , , | Leave a comment