Category: Microsoft SQL server

The MS SQL script below can be used to update records in a table row-by-row by using a cursor.

You can use the below query snippet to list objects in a database that use dependencies which are missing. For example stored procedures that require a certain table/view which doesn’t exist (anymore). This script can help you to clean up old/deprecated/obsolete database objects.

If you have just installed Microsoft SQL server 2019 and are having issues connecting to it from other machines, read here for a possible solution. If you see the following error, read on: 1. Problem Usually, when installing SQL server, not everything is configured for remote access out-of-the-box. This means you need to make a… Continue reading A network-related or instance-specific error occured SQL server 2019