SQL

Today when I was taking backup of a database got below error: Failed to change the status to RESUME for full-text catalog “Test_FullText...

1) Use below procedure to start the Job in SQL Exec msdb.dbo.sp_start_job @job_name = N'Job_Name' Example: Exec msdb.dbo.sp_st...

Today someone has asked me a question "How to clear the Most Recently Used (MRU) server names from the connect screen in SSMS"?  ...

You can use below query to find out the queries that require a memory grant to execute or have acquired a memory grant.  The queries that ...

Use below query to check who are connected to SQL Server SELECT C.Session_ID AS [Session], C.Most_Recent_Session_ID [Recent Session], C.C...