3,481 Topics
 | |
| | Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g …  |
| | I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I … |
| | |
| | hi everyone! Nell here ...im actually quite new to the IT world :) so ... well, i just hope that anybody out there that can advice me on converting the mssql to mysql...maybe u got some useful software for this that u can share with me? :) thanx!!  |
| | Hello Here is my hijack this log file. My computer isn´t working propertly in some areas. For example when I turn on my computer the wireless zero configuration service doesn´t start though it´s set as automatic. I always have to start the computer automatically. Also when I leave my computer … |
| | I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one … |
| | |
| | Hello, I installed PHP 5 on my Server 2003 machine with IIS and got that working properly. I want to connect to my school's MS-SQL student database, but PHP balks when it hits "mssql_connect" (or whatever the statement is). How can I set this up so I can actually connect … |
| | I have a brand new Dell Inspiron E1505 and the pre-installed McAfee VirusScan keeps popping up saying that file C:\WINDOWS\system32\appalc.dll is infected by the Downloader-AWX trojan and cannot be cleaned. I have attempted to delete the file but it is already in use by another program. Here is the HJT … |
 | I'd like to know if I have to change security settings or something on my SQL Server in order to applications like ASP or VB to return a recordset. When my applications in VB or ASP return a recordset from a VIEW, I have not problems at all, but when …  |
| | Hi, I 'm new to using Hijackthis and I believe I have something wrong with my server. I'm getting a DCOM error logging in the system log and it points to Quicksilver class entry in the registry, is it bad? Any help would be greatly appreciated. Logfile of HijackThis v1.99.1 … |
| | Hi, Please anybody help me.. Now I cann't shut down my window XP (I am using IBM laptop). It's always giveing me the message that rundll32.exe is not respoding. I tried to solve the problem the same ways as the previous adivces but it was not working. Following is my … |
| | Hi, I have a general question about MS SQL SERVER. We had sql 2005 express and got to the limit of 4GB. We then installed MS SQL SERVER 2000 and obviously have now a problem with transfering the database from 2005 express to 2000. Any advice? Thanks. |
| | Upon startup I get a message saying "bridge.dll cannot be found" I know it is spyware, but im not sure on how to fix it. Here is my Hijack this log: Logfile of HijackThis v1.99.1 Scan saved at 3:32:55 PM, on 6/6/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet …  |
| | |
| | My page displays the info in the text boxes, but when we run the click sub for the update button it returns the info that it has been updated sucessfully. Here is the page code and below that is the stored procedure it uses, but not update in the database. … |
| | my default homepage cannot be change.the current default homepage is [URL="http://www.securityuptodate.net/"]http://www.securityuptodate.net/[/URL] which i dun wan to have it as my default homepage.in the internet properties it is written as <about:blank>. So can anyone teach me how to allow me to change the default homepage to my liking? this is my … |
| | Ok, my computer is now really f*cked. I'fe red so much threats about this, but none of them helped me. Oki, the problem is; The explorer.exe wont run, my pictogrammes wont appear, i cant start up in safe mode, and i only can enter my computer by the Cntrl+alt+delete -.-'. … |
| | Does anyone know of any way to select only a certain number of records to appear on one page - say, like 30? - then having links to other pages of records if the number of records exceeds 30? |
| | I have an app that performs scans and returns information like what windows updates it has, services running, programs installed, browsesr history, etc. Scans will be performed once a week and sent to a server. The server will only save the most recent scan and store the rest in a … |
| | HELP - Invalid object error related to sqlole null bug in MSSQL 2000? We had a contract programmer come in last year to write a set of scripts in VB6 that select records from a MSSQL 2000 Enterprise Edition datbase table for display on a web site. Everything was going … |
| | Hi All, I have a problem with a table level constraint i want to create. i have 3 tables: products categories product_categories - use to connect product to categories since a product can be added to more then one category. my problem is i want to create a contraint in … |
| | Hi, I have a slight problem. I am trying to create a mail service for a new game which I have started creating recently. Each user that registers also creates a table for their mail. As the usernames are variable and the table name is the username, I need to … |
| | I have a table to store the answers of users of our sweepstake. The table that consists of 3 fields: the userid, the questionid and the answervalue. Now I need to find the users with the most identical answers as a certain user. For example I may have values like … |
| | In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any answer. |
| | I have a table in MS SQL Server 7.0 Like this: Id Cat_Name Definition Image 101 A1 --------------- ************* 102 B1 ----------- ************* 101 A2 ------------------ ************* 103 C1 ----------------- ************* 101 A3 --------------- ************* 101 A4 ------------------ ************* 102 B2 -------------------- ************* 101 A5 -------------- ************* 101 A6 ----------------- … |
| | Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = … |
 | Hi all. New to the site, and it looks grand. I ran across it searching for suggestions on clearing out the AntiSpyLab parasite/hijacker for a family member. Looks like I'm in the right place. It also seems like the first step is to post a HijackThis log. Here goes: Logfile …  |
| | I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1. Any idea why? P.S. I think the installation process is asinine. |
| | Again, thank you for taking the time. I seem to have fallen into someone else's thread, but am so glad i did. this is the 1st place I have got any real help, & haven't even comunicated with any body yet! I came in looking for help on the FakeMSNBeta, … |
| | Over the last several weeks my Internet Browsing has slowed to a crawl. Please help me find out why... Logfile of HijackThis v1.99.1 Scan saved at 09:14:00 PM, on 04/26/2006 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 there, I was trying to get a [B]Scheduled Job[/B] (in SQL Server 2000) to [B]run every second[/B] or two. I had three T-Sql blocks I needed to execute every two seconds, and you know you can just schedule recurring times to every minute. I started out by introducing multiple … |
| | Hi I have 3 tables that I need to display in a report TableA idxA valueA 1, a 2, b 3, c TableB idxB bidxA valueB 1, 1, aa 2, 1, bb 3, 1, cc 4, 2, aa 5, 2, cc TableC idxC bidcA valueC 1, 1, dd 2, 1, … |
| | Hi, I have to connect sometimes to MSSQL and sometimes to MySql depending on the customer. I am experimenting with the php adodb library that claims to make database connection possible to either vendor using the same syntax. First the background at home I have: Rig1: windows XP professional PHP … |
| | How can I create a Formula to figure out a Golf Handicap IN MS SQL Step 1 (Score - Course Rating) x 113 / Slope Rating For example, let's say the score is 85, the course rating 72.2, the slope 131 The formula would be (85 - 72.2) x 113 … |
 | [B]Hi all The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each group can contains multi-user by [U]Group_Id[/U] which is foreign key in [COLOR=Green]user_tbl[/COLOR] . [/list] [list]I am now about creating a trigger that happens … |
| | hey all i need help i am developing web project with ms sql db. i want to know how i can insert a text in db after i changed its font or color or align, i have html editor in one of the web pages, ex: [B]xxxx[/B] the insert statement … |
| | The table I'm searching is varchar. The entries I'm interested in are only numeric. But for some reason there's mixed string/int entries. How can I chose only the numeric values? |
| | I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql … |
| | Hi Guys! I am newbie to MS-SQL Server and I’ve run into a very very serious trouble. My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is: MEMORY Out of my stupidity I upgraded our server’s memory to 4 GIG and to our … |
| | I have a MS SQL DB where I need to add a constraint to a filed of a table. This table is manipulated through an application... in a particular field, the integer (field data type) is subtracted from 5 to 4 or 3 whatever, sometimes a user does an error … |
| | I am developing a system where: - Users can go to a website, sign up for classes, and pay for classes - Or they can come to the store and sign up in person I was wondering if someone could walk me through the steps from the beginning of making … |
| | I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI =============================================================== 1000|31/12/2005 | Sales | -8,000.00 | 12 | 2005 =============================================================== 1000|06/01/2006 | Sales | -6,000.00 | 01 | 2006 =============================================================== 1000|20/01/2006 | Sales | 2,000.00 | 01 | 2006 =============================================================== 1000|28/01/2006 | Sales | -4,000.00 … |
| | I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005 =================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005 =================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005 =================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005 the fields above have the … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 ================================================== 1001| Hardware| 10,000.00 | 02 | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales | -20,000.00 | 01 | 2005 =================================================== 1000| Sales | -10,000.00 | 02 | 2005 =================================================== 1001| Cost | 5,000.00 | 01 | 2005 =================================================== 1001| Cost | 5,000.00 | 02 | 2005 the fields above … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI =================================================== 1000|liability | -10,000.00 | 08 | 2005 =================================================== 1001| asset | 20,000.00 | 08 | 2005 =================================================== 1000|liability | -9,000.00 | 09 | 2005 the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer … |
| | I don't know if this is possible but would appreciate any help. RefDes table: ------------------------------------------ ID RefDes ------------------------------------------ 123 VR1 123 C1 124 C2 123 C2 123 R1 125 R2 ------------------------------------------ Is it possible to write a SELECT statement that will produce the following? ------------------------------------------- ID AllRefDes ------------------------------------------- 123 VR1, … |
The End.