I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.
The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...
Log reader agent has failed with an error
Login failed for user 'sql-user-account'.
Right click on the publication name and open...
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188
This database is not enabled for publication.
I have used the below...
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
You can execute the below query to get the list of SQL Server agents jobs and when it was last executed and time it took to complete the job and when...