This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 各位，怎样才能增加SQL Server允许的连接数？（也就是用sp_who 看到的logins）记得好象用啥系统的存储过程来设？多谢了
-xiaozhu(zhutou);
2001-11-1
(#245753@0)
-
Which version are you using? In SQL Server 7. from Enterprise Manager, right click the server you're dealing with---->Propertities---->Connections tab, you'll see it there.
-cyt(cyt);
2001-11-2
(#246641@0)
-
Tks, I use Sybase 12
-xiaozhu(zhutou);
2001-11-2
(#246918@0)
-
change the parameter in configuration file , restart the database server.
-ca010406(shasha);
2001-11-2
(#246941@0)
-
The sisters here are so technically strong. Just curious.
-pyramid(金字塔);
2001-11-2
(#246959@0)
-
Do you mean change values in sql.ini? Thank you.
-xiaozhu(zhutou);
2001-11-2
(#247003@0)
-
find the directory where sybase server located, find a file named like XXX.cfg, it is an txt file actually, there is a user connection parameter for your sybase dataserver.
-ca010406(shasha);
2001-11-2
(#247006@0)
-
Coolness, it helps.
-xiaozhu(zhutou);
2001-11-5
(#249831@0)
-
Pls use the following store procedure on isql:
sp_configure,"number of user connections",this is a static parameter.
you can use "select @@max_connections" to view the max connections
-hank12345(土老坎);
2001-11-5
(#249845@0)