I am fairly new to SQL Server. Am running SQL Server 2008 R2 Express. There is a process that keeps showing up (can see either using sp_who2 or in SS Mgmt Studio). The Application lists as .Net SQLClient Data Provider
and the database shows as one of my application databases. I have a VB6 application that uses the databases, but it is closed. Having this process running (even sleeping) against my database prevents me from being able to put it in single_user
mode. If I kill the process, in about a minute, it automatically starts up again. I don't think there are any agents running - as SS Config manager shows all agents stopped - and I didn't create any anyway.
If I click on Details on the process in SQL Server Mgmt Studio, the session details indicate this as the last t-SQL command batch:
Select cat.name as [Name] FROM sys.fulltext_catalogs AS cat ORDER BY [Name] Asc< ...
Go to the complete details ...