SQL error -Index was outside the bounds of the array. (Microsoft.SqlServer.Express.Smo) in SQL Server

Hi friends, when i was trying to create/restore database to SQL Server 2014 ,i got an error “Index was outside the bounds of the array”. So i decided to find a solution for the error. I connected SQL Server 2014 with SQL Server Management Studio Express (SSMSE). As per Microsoft documentation,SSMSE is used for  SQL […]

Instance Failure.(system.data) Error in SQL Server 2014

Hi, One day when i started to connect SQL Server 2014 instance using SQL Server Management Studio ,i got an error message “Instance Failure.(system.data) “.So i planned to fix the error by checking the system. So first I checked how many SQL Server instances are running in my system .I found two SQL Server instances […]

SQL error: 40 – Could not open a connection to SQL Server fixed

” A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 – Could not open a connection to SQL Server) […]

SQL error ” Specified cast is not valid (SqlManagerUI) ” in SQL Server 2014 Database Restore

Hi friends,One day, one of my friend gave me a database backup for restoring. He was facing issue in restoring that database backup.he gets error ” Specified cast is not valid (SqlManagerUI) ” .So i tried to restore it in my SQL Server 2008 instance as shown below Step 1 Step 2 Step 3 Step […]

SQL Database Mail not sending error ” The mail could not be sent to the recipients because of the mail server failure.Cannot send mails to mail server”

Hi friends, One day morning I was configuring SQL Database Mail in SQL Server 2014 installed on my laptop.I tried to send SQL test mail but when i login into my gmail account and checked inbox ,i couldn’t find any mail.So i checked Database Mail log to find error message. ” The mail could not […]

SQL Database Mail Configuration in SQL Server 2008 Step by Step

Hi ,Today i am going to teach you How to enable SQL Database Mail in your SQL Server .I have enabled SQL Database Mail in Microsoft SQL Server 2008 R2 installed on my computer.In all SQL version -SQL Server 2008,SQL Server 2008 R2,SQL Server 2012,SQL Server 2014 ,SQL Server 2016,SQL Server 2017,SQL Database Mail configuration […]

Select @@version How to find SQL Server version installed on my Computer

Hi friends, One day I was planning to install SQL 2014 version in my laptop ,but i found that another version of SQL Server is already running in my laptop.So i decided to check what version of SQL Server is running on my Computer now using SQL Query.That investigation leads me to a beautiful SQL […]

What is Primary Key in SQL

Hi ,today we are going to understand about SQL PRIMARY KEY. Primary Key is a column(s) in SQL Database table. It is SQL constraint which can not be NULL values .Primary Key uniquely identify each row in SQL database table. It must contain unique values . Two rows in a table can not have same […]

SQL Server Configuration Manager not showing in Start Menu

One day,I planned to change SQL Server port number using SQL Server Configuration Manager So i tried to open SQL Server Configuration Manager from Start Menu but i could not find it in Start Menu .it is missing from my laptop’s start menu.So i decided to open it using command prompt. In order to open […]

How To Execute SQL Query in SQL Server Management Studio(SSMS)

Today we will study to run SQL Script in SQL Server Management Studio.So we will open SQL Server Management Studio (SSMS) installed in our computer.I will explain How To Open SSMS. You can type SQL Server Management Studio in your computer search box and click on SQL Server Management Studio option as shown in below […]