3,481 Topics
 | |
| | PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table … |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
| | My IE is being Hijacked.... Whenever I open IE mu CPU uasge goes through the roof... and using TCPVIEW I found that it accessed the following IP address: 216.143.70.77 Below is my Hijackthis Log Anyone know whats going on with my system and how to fix it? Any ideas, help, …  |
| | Hi, I have 1.25 gig of ram and svchost.exe starts hogging my ram sometimes utilizing up to 98% of cpu. I dont have any viruses or worms, etc that I know of. I run Adware, SDspybot, Spyware Blaster, MS Antispyware, and Mcafee regularly... Below is my hijackthis log.... Please Help!!! … |
| | Hi, I'm having trouble logging into certain sites that require a password (hotmail, bank, etc) and the screen automatically goes to "page cannot be displayed". My Norton is outdated and I've recently tried to uninstall it...but it won't let me completely uninstall it. Any suggestions? I ran a HJT log: … |
| | I have included my HiJackThis File below. Anyone have any ideas or see something wrong? Thanks for your help. Logfile of HijackThis v1.99.1 Scan saved at 11:07:59 AM, on 11/22/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe …  |
| | hi all i wanna to use sql server 2005 but i never use it or any sql server before can any one help me what steps i should follow to learn it i will use jsp . as i used it before but with access thank u |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
| | I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS … |
| | Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o  |
| | I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] … |
| | hello i m using MSDE version with the web site i have developed for ASP but i m unable to create guest user for internet access, which is defult builtin account by windows plz help me this is very urgent issue for me take care bye |
| | I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks … |
| | how can i access microsoft sql using php. |
| | Could anyone help? My pc is- Hewlett-Packard Pavilion AMD Athlon(tm) XP 1700+ 1.4 GHz 256MB of RAM Microsoft Windows XP Home Edition I think my pc has picked up a virus or something there seems to be numerous 'iexplore.exe' running, there may be other unwanted 'exe' programs running. My homepage … |
| | hi there. have come across this site many times in google results over the years and decided to sign up - it seems a really friendly board. a bit about me.. i'm currently a developer in the clinical sector, although im moving jobs in 3 weeks to be a (mssql) …  |
| | Hello, I've got the qoolaid trojan downloader and can't get rid of it. Norton and Ewido etc. find it and can't delete it. I go through safe mode and still can't delete them manually. Here is my hijackthis log. Any help would be great. My systems are the identification of … |
| | Hello to anyone that can help. I've caught something and I don't know what it is. I accidentally clicked a pop up and now they won't stop. My computer is running very slow and freezing up regularly, any help would be appreciated! Logfile of HijackThis v1.99.1 Scan saved at 8:43:33 … |
 | Logfile of HijackThis v1.99.1 Scan saved at 2:16:07 PM, on 10/31/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\System32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Norton Internet Security\ISSVC.exe C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe C:\Program … |
| | This is about a stored procedure I'm working on. I have a field which gives me a value of datetime type. I need to display the 6 months starting from the month in the field. E.g. field gives me Feb, I have to display Feb, Mar,April, May, June, July seperately. … |
 | I'm trying to populate a table from a sub-query. [CODE] CREATE TABLE test ( ID int ) INSERT INTO test VALUES (SELECT [Customer Id] FROM [Customers]) [/CODE] QUESTION: I know you can do this in ORACLE but Is something like this possible in T-SQL. I can also write something like … |
| | How would you calculate the difference between two dates? |
| | can someone please help me? I have been invaded by popups. Thanks! Logfile of HijackThis v1.99.1 Scan saved at 11:57:41 AM, on 20/10/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\TGTSoft\StyleXP\StyleXPService.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program … |
| | CAN SOMEONE PLEASE HELP I HAVE BEEN INFECTED WITH THE TROJAN.CACHECACHE.KIT VIRUS AND CANT GET RID OF IT MY NORTON 05 KEEPS DETECTING IT IN WINDOWS\SYSTEM32\RDRIV.SYS HERE IS MY HIJACK LOG Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe … |
| | Hi I m a final yr comp Engg student. I m working on .NET,i m usin mssql with ASP.NET,VB.NET for creatin online banking site.I hv a problem: Hw i can [B]record the transaction made [/B]by client for report generation. shal i use database for [B]report generation[/B]?if yes then hw? otherwise … |
| | Hi I have been through all spyware and HJT and still having problems loading IE and windows explorer in XP. I am using firefox now but still having to wait 2 mins for IE or Explorer (my computer) to open please see my HJT log file below. Any advise would … |
| | Logfile of HijackThis v1.99.1 Scan saved at 7:16:01 PM, on 9/25/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccProxy.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Norton Internet Security\ISSVC.exe C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe C:\Program Files\Common Files\Symantec … |
| | [First I have to apologize because I am posting this in two different forums on this site -- in hopes of finding someone who might be able to help.] I am building a system to mimic the NT user and group system. It works fine, but because of the way … |
| | [First I have to apologize because I am posting this in two different forums on this site.] I am building a system to mimic the NT user and group system. It works fine, but because of the way I am storing and querying the data (from MSSQL), it takes forever! … |
| | Logfile of HijackThis v1.99.1 Scan saved at 1:41:46 PM, on 9/22/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\csrss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\S24EvMon.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\ZCfgSvc.exe … |
| | I have developed some webpages using asp and they work fine on my computer with Access 2003 (using iis as a local server). However, I am aware that SQL 2000 is a better db to use, but I am not sure in which ways. Since I intend to put my … |
| | i decided to switch over to ms access (thinking it would be easier) from mssql but i am having the same problem that i had with ms sql: "SQL Server does not exist or access denied" i have put the ms access db into the web server from the web … |
| | w-find.com/index.htm is always coming back as my IE start page! Also, networking is sporadic on this machine now. Here's the HijackThis log that i have seen requested for fixing. Logfile of HijackThis v1.98.2 Scan saved at 12:26:07 AM, on 9/10/2005 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 … |
| | I think I may have picked up something that causes everything to run super slow. Task manager shows 100% CPU usage even when I am not running any programs. It started a few days ago and has recently gotten worse. It may be a hardware probelem, but I suspect some … |
 | A friend of mine had been having problems with his computer, I had him run ad awear spybot and ewido, and he fixed all those problems. So now im posting this log to see it there is anything he missed. Logfile of HijackThis v1.99.1 Scan saved at 11:33:57 PM, on … |
| | Hi, everyone. I'm Milton, from Brazil, and I am impressed by the quality and friendlyness of your site/forum. To be honest, however, I just joined 'cause I need help, sort of desperately. Hope you don´t mind. My browser (IE6) has been hijacked - see HiJackThis log posted below. Panda Platinum … |
| | hello!! this is my hijackthis log: Logfile of HijackThis v1.99.1 Scan saved at 14:09:52, on 22.8.2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Sygate\SPF\smc.exe C:\WINDOWS\system32\spoolsv.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe C:\Program Files\Common Files\LightScribe\LSSrvc.exe C:\Program Files\Common Files\Microsoft Shared\VS7Debug\mdm.exe C:\Program Files\Microsoft … |
| | I have made created a databse MSSQL and want to upload it to my web space how do i go about it.  |
 | Whenn i try to ypdate windows i get the error message saying that critical update files have been deletes and need to be redownloade and registered. So i clik redownload. but it never works evryt ime i try again i get the same thing. So i scanned with hijackthis. any … |
| | Not sure if it's a virus or a problem with my disk, but it does sound similar to some previous problems in the forum (no desktop, no start menu, explorer and iexplore wont load) I can run programs via task mananger / run and cmd, etc, disk doe churn quite … |
| | Not sure what the problem is, but many webpages I used to visit (hotmail.com, yahoo.com, etc.) will no longer load; I only get a page cannot be found error... I've downloaded and run HJT, this is what I've come up with: Logfile of HijackThis v1.99.1 Scan saved at 7:59:36 AM, … |
| | ok, here is the script I ran to create the stored procedure [code] SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE [insertFunction] (@Id [int], @class [nvarchar], @type [nvarchar], @name [nvarchar]) AS declare @classID [int] select @classID = tblClass.ID from tblClass where tblClass.Name = @class INSERT INTO tblFunction ([ID],[Name],[ReturnType],[Class]) … |
| | Hi, I have a dts package that I created which uses an odbc connection to go and copy a dbf file using visual fox pro drivers. The package runs fine when I execute it. But whenever I try to use the sql server agent to run it as a job … |
| | The MS SQL 7.0 Server is installed on a Windows server, not placed in my home. I want to make a SQL query from my home, using java JDBC, but I get an error: java.sql.SQLException: Network error IOException: Connection timed out: connect - This error I don´t get if I´m … |
| | I have major lag on my computer, espeially when im playing online games. It would be very helpful if somenone could have a look at it for me. Logfile of HijackThis v1.98.2 Scan saved at 21:43:41, on 22/07/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) … |
| | Hi, I am in the process of deciding the database and application language. We have exising MS SQL server running on windows OS, to save the company's product data, right now I need to build another seperate system for intranet use, as I am more familiar with PHP+Mysql, I want … |
| | I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem. |
 | Can someone enlighten me on this issue ? I have data source A - with a stored procedure in which I'd like to select records from tables in a different data source, B. |
| | SELECT NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 AS WeekStarting, sum(score)/7 from myTable where (NZDate between '2005-01-01' and '2005-01-21') and name IN ('John','Bob','Harry') group by NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 order by weekstarting Hi, I have a query (above) that given any start date … |
| | Current app runs a stored procedure which runs 16 nested procedures and takes from 3 to 10 min depending on how must data needs download from the as400. The problem is that there are some other web apps on the web serverr that use old com objects that have memory … |
The End.