#dba
Read more stories on Hashnode
Articles with this tag
Problem: I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...
Error: The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...
Error 1: Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188 This database is not enabled for publication. Error 2: Msg...
List out all the indexes defined on a table and column details. USE test_db; GO SELECT OBJECT_NAME(i.object_id) AS table_name ,i.type_desc AS...
This query gets tcp/ip settings of the SQL Server from registry. SELECT registry_key, value_name, value_data FROM sys.dm_server_registry WHERE...
Problem Unable to rename the database in SQL Server. Msg 5030, Level 16, State 2, Line 17 The database could not be exclusively locked to perform...
