Find IP and Port using SQL SSMS
Find IP and Port using SQL SSMS Find IP and Port of a SQL Server from a client machine. The script will not provide all the information if you are connected to the host/local machine of the SQL server. It…
Category: MSSQL
Read More →
Find user activity without any Auditing
How to find out user activity on database without any particular Auditing Sometime you may need to find out who ran some script or who is accessing the database or who made some modification or deleted some data or updated…
Latest service pack to SQL Server
Apply latest service pack to standalone SQL Server We have given a Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600:) and We need to apply the latest SP…
Find SQL Server/Instance details using SQL query
Scenario Sometimes you need to gather the SQL instance details in a proper format such as Server Name, Instance, Service account name. Today I am sharing a script that will give you the SQL instance details in Single query. Query…
Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user is not able to connect to SQL server or Application is not able to connect to SQL for some reason. There might be any of the below reasons for which the user/application is…
Error : FILESTREAM feature is disable
Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup from a test server provided to DBA team and asked to restore it on a pre-production SQL Server. Backup was from a SQL Server 2008 version & the…
Run a Job on few specific dates of every month in SQL Server
Introduction As per business requirements, a report needs to generate four times every month. The report will generated by a Stored Procedure. So the DBA’s task is to execute the specific Stored Procedure on a few specific dates of every…
Install SQL Server 2008R2 on Windows 2012R2
Introduction Installing lower version SQL Server on a higher version of Windows Server may be problematic at times of installation. Recently we have faced such a scenario. We are sharing installation steps to overcome the problem. At the initial phase…
Unable to begin a Distributed Transaction
Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name” was unable to begin a distribution transaction. [SQLSTATE 42000] (Error…
Rename a Database in SQL Server
Introduction We can rename a user-defined database in SQL Server by using SQL Server Management Studio or Transact-SQL. System databases cannot be renamed. The database name cannot be changed while it is online and other users are accessing the database.…