SQL Server - 2005 Developers Edition
Asked By Chris Botha
04-Apr-07 12:09 PM
I use 2005 Developers Edition on my XP box. Some times I start getting
time-outs, or it slows down a heck of a lot.
What is the number of connections limitations or other limitations - someone
has a link to a page?
IIS may time-out or Management Studio may time-out and if I close VS or
Management Studio then IIS connects, or iisreset then Management Studio
connects, etc.
Thanks.
AlejandroMes replied...
Chris Botha,
Did you setup server property "max server memory (MB)" in your box?
If you haven't done that, SQL Server can use as much memory as it needs and
this could interfere with the needs for other applications.
See "sp_configure" in BOL.
AMB
is it possible to connect to a database without having given permission to this database SQL Server Hello! I have XP pro with sql server 2005 express. This is about the windows account ASPNET that is used by IIS. If I right click on this computer and select manage and then select local users member in and check that ASPNET does not belong to any group. Now I start SQL Server Management Studio Express for SQL Server 2005. I open up Security-> Logins and check that
How to Login to SQL server in ASP pages? SQL Server I am running SQLServerExpress on my desktop PC having IIS on Windows XP SP3. I want to login to the SQL server through the ASP pages and access the database for displaying the results on ASP pages
About access to Sql Server SQL Server Hello! Assume I use Integrated Security. I have two windows accounts one account Tony that I use when logging in to the machine and the other is ASPNET that IIS is using. Now to my question will these two windows account(Tony and ASPNET) have the same access rights to Sql Server ? I mean that every windows account that you use with Integrated Secirity have full right to Sql Server. If not how can you control these accounts(Tony and ASPNET) in Sql Server
Data returned by SQL Server ODBC driver is not correct SQL Server I have a query which happily returns a full set of data when run in SQL Studio but when I do the same query using IIS with Classic ASP connected via ODBC's SQL Server driver (not the native one) numbers returned to the record set are filled with 0
Wide Area connection to SQL server 2008 Express via broadband SQL Server I have a Vb6 application that connects to SQL server 2008 Express (installed on a Windows XP box connected to a router); currently the application connects to the server and remains connected until the user closes the application (the application disconnects from the server