Hi, Consider a particular scenario where sa account gets disabled (by any reason) and windows authentication doesn’t have the rights to connect to the database server; basically windows authentication is not available. In such a case, you will not be able to do much from Sql server management studio to enable sa account again because to […]
Category: SQL Server
Selecting all unique rows from duplicate rows in table in SQL Server
Hi, This post will show how you can write a select query to select only unique rows from a table that has many duplicate rows. In other words, this post will show the query to select distinct rows from a table that has duplicate rows. Let’s say we have a table duplicated_table that has the […]
[Question – Help required] SQL Server 2008 R2 installation missing “Integration Services” Shared feature in features selection step
Hi, I’m installing SQL Server 2008 R2 Enterprise Edition in my system. The installation process is working perfectly except that in one of the steps where we are supposed to select the features, I observe that “Integration Services” shared feature IS MISSING in the features list. Please check the screenshots below. The first screenshot is […]
[Error-Resolved]Could not find the database engine startup handle – SQL Server 2008 R2 installation
Hi, This post describes how to resolve the error that one might encounter while installing SQL Server 2008 R2 from an ISO. I had the setup for SQL Server 2008 R2 in an ISO file. I assumed that extracting the ISO using WinZip/Winrar and installing the setup would work and so followed the same procedure. […]
Retrieving column values as a comma separated string in SQLServer
Hi, This post is quite the opposite of the previous post. That is, in the previous post, We inserted a comma separated string into separate rows. Here we will return a single comma separated string by concatenating values from separate rows. The query for this is very simple. Say, our table has two columns, UserId and […]
Adding items in comma-separated string into separate rows in SQLServer
Hi, In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. after inserting into the table, the output should be like: I have written a stored procedure which will […]