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…
Year: 2019
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…
1 min read
0
Rename a Database in SQL Server
Introduction We can rename a user-defined database in SQL Server by using SQL Server Management Studio or Transact-SQL. System databases…
5 min read
0
Shrinking the Large Log File in SQL Server
Scenario We recently came across a situation where one of the drives in the production server is almost full. There…
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. It is not a good practice to keep your database…
2 min read
2
Database-Level Roles in SQL Server
Introduction There are two types of database-level roles: Fixed-database roles db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA,Granted with Grant option…
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 of statistics as SQL database engine Query optimizer uses statistics…