I have an SQL server running but i seem to have some sort of problem.
Every time i perform a sql query the memory useage of the sqlservr.exe increases, is this normal ?
I open the Recordset doing the following
dim rs as new ADodb.recordset
and even close it
set rs = nothing
What could i be doing wrong or does the SQL server simply do this ?