2 min read
4
Create login by CMD in SQL Server
Scenario You have got the SQL database engine installed but…
Category: MSSQL
4 min read
0
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database…
2 min read
0
Find all the users for a particular database
Introduction In SQL Server, managing user access and permissions is…
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…
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…