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…
Month: October 2019
2 min read
2
2 min read
0
Find user activity without any Auditing
How to find out user activity on database without any…
4 min read
2
2 min read
0
Find SQL Server/Instance details using SQL query
Scenario Sometimes you need to gather the SQL instance details…
2 min read
1
Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user 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…
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…
4 min read
0
Install SQL Server 2008R2 on Windows 2012R2
Introduction Installing lower version SQL Server on a higher version…
2 min read
0
Unable to begin a Distributed Transaction
Problem When your application uses the distribution transaction then you…