Hi all,
I hope that some can help with the following situation.
I have a SQL 2000 server (sp3) on Windows 2000 server (sp4) that has
recently developed a memory leak when running a DTS package. When ever
a package is run the memory max out at 2 gig and doesn't come back
down unless you stop and re-start the SQL server service.

I couldn't see any hot fixes on the Microsoft site.

Has any one come across this before or does any one have any pointers
for the resolution.

Stuart

Is there anything different between the tme you last run the package with no
memory leak and the first time you ran it with the leak?

If reapplying the SP3 + hotfixes does not fix your problem and you can
reproduce on a different box to the current one then I would suggest a PSS
call.


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stuart" <stuart_davies (AT) hotmail (DOT) com> wrote

Unfortunately not, I could understand it more if there had been a
change on the server. Service packs etc have been re-applied and made
no difference.
Without appearing a numpty – who are PSS?
Stuart


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Product Support at MS.

If you can reproduce the exact same problem on different boxes everytime and
cannot see a reason for this then they are the boys and girls to really
help.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stuart" <stuart_davies (AT) hotmail (DOT) com> wrote