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…
Author: OTI
Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
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…
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…