Have you checked 'task manager' to see what process is eating the memory

Have you manually configured the 'minimum memory' setting on the sql server (properties, memory tab - i think)

Could you get away with using 'derived tables' instead in your query?

You may be able to use the Microsoft Network Security Hotfix Checker (Hfnetchk.exe) Tool (Microsoft Q number - Q303215)

You wouldn'y by any chance be running it on something like 2000 Server Service Pack 1?

(The last line tells you the operating system and service pack)

Thanks for the info. I've stuck to SP2 and upgrade to 2000. Hence haven't really needed to look into sp3 much.

Yes you can. and you even get some extra features eg Taskpad view.

But remember if you save DTS packages using a sql 2000 EM you won't be able to view...

Its runs against all version of SQL 7, but you need to remember that if you save something like a DTS package from a higher version of EM, you cannot...

If you are going to do this, ensure the standard safeguards are taken eg. the sa password is not blank. As that sql virus last week exploted that default option.

...

You could open up the firewall between the two named servers over port 1433 (if you use tcp-ip as your netlib).

If you are going to do this make sure you...

Fine if you are just manageing the application and data but if you are doing any administration work on sql 6.5, you may need a copy somewhere to get used...

Both versions can be installed on the same box, but only one can be active. There is a utility called 'sql switch' which swaps between the two.

Better to have...

Silly question, but your sql server is not set to NT security only instead of mixed mode?

Did you stop and start sql after changing the passwords? If not it will continue running under the previous one.

I presume you have changed the password on the service again,...

UDL - In around MDAC 2.1SP2 a new feature was added (UDL). It basically is a quick way of creating a connection string with a gui front end.

Create a file...