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.
| 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 v2005You 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. |
 |
|
|
|
|
|