1 min read
0
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…
Month: October 2019
2 min read
2
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…
2 min read
0
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…
4 min read
2
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)…
2 min read
0
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…
2 min read
1
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…
3 min read
0
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…
5 min read
0
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…
4 min read
0
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.…
2 min read
0
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…