Posted on: 7/14/2013 2:23:30 AM | Views : 465

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 ...