#sqlhelper

List all SQL Instances on a local machine in C#

This is just another SQL C# articles which let you learn how to make a list of names of SQL instance available on your Microsoft SQL Server using C# code.

This is made possible using Registry entries.

private IEnumerable ListLocalSqlInstances(RegistryKey hive) { const string keyName = @"Software\Microsoft\Microsoft SQL Server"; const string valueName = "InstalledInstances"; const string…

How to Check for a database on SQL Server using C#

This is just another SQL C# articles which let you learn how to check for a database existence on SQL Server.

All you have to do query names in sys.databases table and make sure it is available to use. You can create a function for the purpose.

public static bool IsDBExist(string server, string db) { List list = new List(); // Open connection to the database string conString = null;…