2 min read
2
Category: MSSQL
2 min read
0
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…
1 min read
0
Rename a Database in SQL Server
Introduction We can rename a user-defined database in SQL Server…