2 min read
1
Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user is not able…
Category: MSSQL
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…
5 min read
0
Shrinking the Large Log File in SQL Server
Scenario We recently came across a situation where one of…
2 min read
0
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases.…
2 min read
2
Database-Level Roles in SQL Server
Introduction There are two types of database-level roles: Fixed-database roles…
2 min read
1
How to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because…