Thanks, that just what i needed:-)

/A

Hi

For monitoring/management I use db watch from http://www.dbwatchsoftware.com so I have a solution in place.

My question is more practical for day to day operations.

To you log in to...

Log Space used is 50%.

/Andy

The application that uses the database in developed in house, and the database only has 4 columns. But 8 million rows.

So is shouldn't be any issues with supporting 10.

/Andy.l

Hi

Name would be a good start, just to see which ones been deleted, time would be beneficial as well.

/Andy

Hi

Nope, no SSIS packages.

/Andy.l

Hi thanks for your answer

It doesn't look like they're just running. It's more like they're hanging. And since the SP's are keeping the transactions open the version store keeps running,...

So I should do it like that, even though the views query the DMV in the systemdatabases?

/Andy.l

Hi, I came to the same conclusion. But it is possible to add the account through the GUI, just choose local machine and specify "nt service\" as prefix when you...