How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

Many a times we may need to get the Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server. In this article we will see how we can get these parts of the DateTime in Sql Server. You may like to read the other popular articles on Date and Time: How to get… Continue reading How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

SQL Server 2012 Error 15023 : User already exists in current database.

1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login ‘Report’ GO Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Auto_Fix’ attribute will create the user in… Continue reading SQL Server 2012 Error 15023 : User already exists in current database.

How to Shrink LDF File Size using SQL Management Studio

If the transaction log file (.ldf) in Microsoft SQL is too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database to keep the .ldf file under control. To reduce the .ldf file, you must do threethings: Backup the… Continue reading How to Shrink LDF File Size using SQL Management Studio

Unable to install this application because an application with the same identity is already installed.

This kind of error I get trying to edit rdl file by Report Bulider 3.0. After while I figured out that I need do this two steps : 1. Open a command prompt. Enter the following:  rundll32 dfshim CleanOnlineAppCache Press Enter. 2.  Go to the C:\Users\[User Name]\AppData\Local\Apps\2.0 Delete the all temporay files. *You may want… Continue reading Unable to install this application because an application with the same identity is already installed.

Resolving could not open a connection to SQL Server errors

Problem Sometimes you may have issues connecting to SQL Server and you may get messages such as the following: ERROR: (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error:) An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error:… Continue reading Resolving could not open a connection to SQL Server errors

Conditionally Setting Column Visibility in SSRS

In this article I will show you real example of the usage of Column Visibility property in SSRS. Column visibility property is used to show or hide the column in the report. Now in this article, we can use this property to allow the users to select columns what they want to see in a… Continue reading Conditionally Setting Column Visibility in SSRS