Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Querry regarding SQL Server.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-12 : 09:49:23
Yatin writes "We Have Setup of SQL Server Developer Edition in our Server(Windows 2003 Standard Edtion).In SQL Server we have two instance abc and xyz .We Frequenty get Time out error while connecting to abc instance with alternate user . I may think priblem may be related to server memory, but is ther any setting throught which we can solution.If yes then plz provide with the same.

With Regards,
Yatin B."

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-12 : 10:14:03
v2000 or v2005
You can limit the amount of memory which an instance of sql server uses.
Have a a look at memory under properties.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -