How to run a SQL query using command prompt without SQL SSMS
Introduction How to run a SQL query using command prompt without SQL SSMS Open CMD from Run and run the below command (CMD) to connect with Database engine. sqlcmd -S…
Read FullIntroduction How to run a SQL query using command prompt without SQL SSMS Open CMD from Run and run the below command (CMD) to connect with Database engine. sqlcmd -S…
Read FullFind 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…
Read FullHow 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…
Read FullApply 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…
Read FullScenario 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…
Read FullScenario 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…
Read FullIntroduction 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.…
Read FullIntroduction 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…
Read FullIntroduction 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…
Read FullProblem 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"…
Read Full