I'm relatively new to SQL Server. What do you mean with 'kill all active threads flush caches to free up memory inside the SQL Server memory space'?

I think I know what the problem is. The program that uses the database on the SQL Server is build using data bound controls. They don't work always the way...

Because the SQL Server process took over 120 mb from my system memory. At the location our customer is working, they have only a server available with 384 mb of memory. Besides...

Ok, I figured it out already, Actually it is:

net stop sqlserveragent

net stop mssqlserver

net start mssqlserver

net start sqlserveragent

Otherwise it will not work automatically, and net stop will ask to stop the...