Read more stories on Hashnode
Articles with this tag
I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...
The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188 This database is not enabled for publication.
List out all the indexes defined on a table and column details.
OBJECT_NAME(i.object_id) AS table_name
This query gets tcp/ip settings of the SQL Server from registry.
SELECT registry_key, value_name, value_data
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...