Search results for query: *

Hi I have a very large SQL Server 2000 database (around 8gb). And within that I have a table where most of this data is stored. I have one table with around 7 million rows. The primary key is stored across four varchar fields. The table has 57 fields. The table is used very heavily for all...

Hi I have a Win2003 domain server with users logging in via TS. I have a group policy defined. With all my users the Administrative Tools in the start menu is not visible except for one user. This user is in the same groups as everyone else, I cannot understand why this is visible? Can anyone...

Hi I have a sql statement similar to this: Select * from table where myNumberField in (1,2,5,10,20) Can anyone convert this to Crystal as IN does not seem to work? Thanks dave

Hi I am returning data from a SQL table with five fields one of them is an IMAGE of about 400kb, this used to return quickly however over the last couple of weeks it now takes over a minute to return, I ran the SQL Profiler and it confirms this, does anyone have any ideas why the same query...

Hi, are there any modems/routers available where yo can prevent users from reseting them? ie. locking down the reset feature in some way? Cheers. Dave

Hi there, I am have a service called ACLIST, the image path is missing and the server keeps trying to start the service every few seconds it writes to the event log saying service failed to start, even when I set the service to disabled and reboot it sets back to automatic, I do not know what...

Hi, i wanted to get a new laptop, but I also for when I am at home would like to work with two monitors, I know u can do this with some desktop video cards, is this possible to do with a laptop(not use the laptop screen at all but two normal monitors)? Thanks! Dave

Hi, I have a script that I execute, which checks whether a database exists, I wish to then only create the views if this DB exists. I have been attempting to use return, like this: if not exists(SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA WHERE CATALOG_NAME='velocity') return and i then have my...

I think I must be a complete idiot as i cannot work this out. All i want to do is have a dropdown box on my form (Winforms) and if the user enters a new item that is not on the list add this to the new database, What is the best method for this? Hope someone can help me. Dave.

Hi, I have a site to site vpn with PIX 501's. The tunnel stays up fine. BUt if i reboot my PC on one end of the tunnel, and try to connect to machines on the other side of the tunnel, it does not work until they ping me first. What could this be?! Thanks alot inadvance. Dave.

Hi, I am looking to scan in users driving licenses (UK) and extract the picture and OCR the text for input into a database. Any one know of how best to do this, my ideal is to have a little business card scanner on the desk and for users to use this to feed in the cards and extract it via an...

Hi, i have a table of logged transactions with a datetime field and a userid, each day can have any number of transactions by a user but with different datetimes, how i can get the last time for each day by user, here is a sample of the data: logid userid datetime 285439 5 2004-10-05...

Hi there, I have a question on routing. I have 2 servers both running terminal services, sitting behind a nat firewall, so they both have internal addresses. I have ordered two IP addresses for my ISP, and would like to forward 1 external IP address to Server A and the 2nd external IP routed to...

Hi there, I have two servers running Windows 2003 and terminal services (one is a DC). We have recently had a problem where one of them went down and it was a nightmare. I am in the process of buying a new server which I want to use as a backup domain controller and also as a backup for if...

Hi, I have a major problem on a Client/Server application I am running thru a firewall site to site Cisco PIX501, it runs very slow, when i add a record on the lan it takes no more than 2 seconds, on the vpn it takes over 15. The transaction size is minimal however. I have messed about with...

Hi, I have a nightmare vpn issue. I am using Cisco 501PIX units on a site to site vpn, they both have Linksys WAG54 modems at each site. My vpn works fine, can login into domain server across it OK, and can FTP at speeds of around 20KB/SEC. But I have an application (an Alarm application called...

Hi, I am using Terminal services 2003, when the users do not touch the screen for around 10 minutes it logs them out and they need to enter their username/password. When you righr click on the desktop to change the setting as a user they are restricted so cannot change the setting themselves...

Hi, i am looking into taking the MCSD, what is the least expensive route? can u just sit an exam somewhere? I have been programming for a few years, so would just like do maybe do some online training and buy a couple of books, and sit the exam (and no doubt fail!!!). I am in the UK. Can anyone...

Hi, I need to move our current Exchange install onto a new server, I need to backup User Accounts & Email and restore this onto the new server, there are only a few users so should not be too much data, what is the easiest method to do this? Thank you for any help. dave

Hi, i have a number of files available to download from my website, is there a way to check if the user downloaded a file succesfully? cheers. dave