getting rid of tasks

[KWade]

Hi
When I issue sp_who I get the following: (titles abbrev.)
spid status login hostname DB Command
59 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND
62 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND
71 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND
78 0 sleeping sa GLITAS04 0 GTest AWAITING COMMAND

I use KILL (spid), and I get command completed successfully but the tasks do not go away.

If I try to do anything to the Database that requires sole access I get an error message.

I CAN detatch it, delete, define and restore a copy of GTest or another Database into GTest but these 4 tasks keep showing up.

What are they and How do I get rid of them? Thanks,
Keith

 

[JayKusch]

Is there a "program name" associated w/ these SPIDs? Also, are they attached to a specific DB?

Thanks

J. Kusch

 

[KWade]

Hi,

When I do the sp_who command that is all the information for each spid that displays.

Isn't GTest (under the dbname column) the database that it is attached to? As for "program name", there isn't anything listed when you issue sp_who. If there is another way to find this information I don't know how to do it. Thanks, Keith

 

[JayKusch]

You can drill down in Enterprise Manager. You start at "Management","Current Activity" then "Process Info". You will see a list of SPIDs. Look at a couple that you listed for the information requested.

Thanks

J. Kusch

 

[KWade]

Thanks Jay,

I was able to find the the information through Enterprise Manager. The application name of 3 of the process are listed as Deltek Vision(default) and 1 process is listed as Deltek Vision(Process Server). I tried to kill the processes but they wouldn't kill. Any other suggestions? Thanks, Keith

 

[JayKusch]

Not sure what Deltek is, so I am unable troubleshoot from the application side of the fence. The Deltek services may be self aware and when you kill them, they are re-establishing themselves. I would have thought that in killing these SPIDs, they would have at least come back, after re-establishing themselves, as a diffrent SPID number. I will continue to dig!

Thanks

J. Kusch

 

[KWade]

Hi Jay,
Thanks for you help. Here is some more info. Vision is a Deltek product for Accounting and Marketing. It's SQL Server 2000 databases with an ASP front end (lucky me! I'm new to both).
The database GTest is a database that I've restored from a different databases's backup from this weekend. I'm not sure how all this works yet but could these processes be hung in the database backup that I'm restoring from? Although I am curious about why the processes are haning around, I'd really like to know how to get rid of them.
Thanks, Keith