Search results for query: *

Hi, I have few questions about indexes. For example : I have one table with some user data, primary key is on field userID and I do not have any other indexes there. Often I am running some stored procedures where I have something like : select count(username) from members where username=@to...

I tried something similar and it doesn't work :(

Hello, I want to include one asp page in other but in that page which I want to include I already included third page. Can something like that work ? Or better question is how something like that can work because I have problems with it ? Thanks Oliver

Hi, just type : response.write request.form("Blue_Pen") and you will get value of your check box.

Hello, before few days we separate our SQL server from Web server (ASP pages) and now we have two computers. Problem is that often when we try to pick-up data from DB we get error that server can not be recognized or connection is open or something similar. We do not know what is a problem but...

Hello, on my SQL Server I have around 100 connections (users). Almost 60% are sleeping connections ? What are they and how long they will be connected to server before server disconnect them ? Thanks, Oliver

Thanks :) collate Latin1_General_CI_AS solved problem Oliver

Thanks for tips. I will try that what you recommended :) Oliver

I forgot, both databases have same collation : Latin1_General_CI_AS and fields are with same type.

Hello, I have two databases (db1 and db2). In them I have two same tables and I need to make union of them so that I pickup all data. Both select are the same : select db1.dbo.tblUsers.userid, db1.dbo.tblUsers.name, db1.dbo.tblUsers.datum from db1.dbo.tblUsers union select...

Hello, I have server with Windows 2000 Server. After I applied all updates server doesn't want to shutdown. At the end I can see only black screen with blinking cursor and, after that, only way how I can shutdown server is to press button or shutdown electricity. Any idea what can be a problem...

Hi Nick, bandwidth is not a problem because it can go to 100MBs and now is around 1Mbs. With my Dell I am totally confused because site is organised in master folder and subfolder (site is default site on IIS). If I access for example http://localhost it will open default.asp page without any...

Hi, you are not limited with number of web visitors but only with number of "desktop connections". I have Windows 2000 Server with 5 licences but I use that server for web server and in average we have 150-200 concurrent connections without any problems (except hardware limitation)...

Hello, I just bought Dell 2450 (2x733 Xeon) with 512Mb and 4x18Gb discs (I will try to add aditional 512Mb). Currently I have one server and it works like web and database server (Win2K Server & MS SQL Server), but because I have in average 150-200 visitors at same time on site, we need to...