Thanks Dave! It works, much quicker than using all the scripting tasks.

Thank you.

Hey guys

I realized that there was a job to clean up the distribution database, the job however has been failing for the last couple of months.

Thanks!

The server has some free space left but not alot, also replication seems to be working fine, no errors

there is a maintenance plan that runs every night on the user db's to reorganize all indexes, there are 15 user db's on the server, 3 of which heavily get...

Thats great, thanks Danie!

Hey Danie

Yes there is 25Gb free on that drive, which is more than enough, i have also stopped and started the SQL service, but the the size remains the same.

ok, thanks, but in SQL 2008 there is no option to configure the memory to be allocated dynamically.

Hi

I found your topic very interesting, being a dba myself, i got layed off beginning of March and will stay at my current job untill the 5th of April....