devxlogo

IsSqlServerDatabasePresent – Checking whether a SQL Server database is present

IsSqlServerDatabasePresent – Checking whether a SQL Server database is present

' Returns whether a SQL Server DB with the specified name is present' The first param must be a valid connection string to the 'master' database' Requires Imports System.Data.SqlClient'' Example:'   Debug.WriteLine(IsSqlServerDatabasePresent( '      "server=(local); ' Database=master; user id=sa; password=;", "CodeBoxLib"))Function IsSqlServerDatabasePresent(ByVal masterConnString As String, _    ByVal dbName As String) As Boolean    Dim cn As New SqlConnection(masterConnString)    ' count the databases with the specified name    Dim cmd As New SqlCommand("SELECT COUNT(*) FROM sysdatabases WHERE " _        & "[name]='" & dbName & "'", cn)    cn.Open()    Dim count As Integer = CType(cmd.ExecuteScalar(), Integer)            cn.Close()    ' return True if a record is found    Return (count > 0)End Function

See also  How to Create and Deploy QR Codes Online: A Comprehensive Guide
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist