3,481 Topics
 | |
| | OK. I'm an idiot. I've managed to get my laptop hijacked... though I'm still not entirely sure how. I don't recall having gone to any websites that I haven't been to before, but... when I went to look at history everything had been cleared. About a week ago I installed … |
| | Hi Everybody How can I use 2 update stmts in a single SP? I want to update two tables, with different data, but with the same, where clause Is there any way to do that? thanks  |
| | Hi there, Recently started having problems with my PC Rundll32 won't close at shutdown CD's won't autorun iTunes won't open Add/Remove Programs Function in Control Panel crashes if I try to use it Frequent My computer crashes I've scanned with Norton, nothing. Adaware, and Spybot Search and Destroy have not … |
| | i am trying to install the ms crm trail version and i keep getting err msg " The minimum required version is SQL Server 2000 SP4 (8.0.2026)." i already downloaded the sp4 with all its components updrade and my sql version is 8 but i need it to be 8.0.2026. … |
 | [B]Intro[/B] I'm not the best at this, but I thought we were lacking a SQL tutorial... [B]Test table[/B] My Little Test Table called "test" for this great exercise contains the following [B]FirstName[/B] [B]LastName[/B] [B]EyeColor[/B] Paul Esson Brown John Smith Blue John Howard Green Kim Beazley Gray [B]SELECT[/B] This selects data … |
| | I hava a table that stores payment information, with invoicenumber int and part varchar, where part can be (1/1, 1/2, 2/2, 1/3, 2/3, 3/3, etc) The thing is not all payments are related to invoices, so I have many null value for invoicenumber. Is it posible to create a UNIQUE … |
| | Hi all, I need to build a application in which i have to test wheather sql server 2000 is connected or not.I cant be dependent on any query using master database as user might not have access to it. I used following code [COLOR=#0000ff]Try [/COLOR][COLOR=#0000ff]Dim[/COLOR] objIPHost [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] System.Net.IPHostEntry objIPHost … |
| | Ok ive recently recoered from a dialer trojan and was wondering if anyone could take a peek at my HJT log: [code] ogfile of HijackThis v1.99.1 Scan saved at 16:53:18, on 28/01/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.5730.0011) 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 … |
| | I've been struggling with trying to fix my friend's laptop issue. At xp startup this rundll error comes up and like many issues here...you just click ok and runs like normal. The only thing I do notice is whenever she goes online (dial-up) and loads up a page she gets … |
| | Greetings, Hope I'd be able to get some advice here. My system has been laggy recently - especially with MS Office applicatioins. Thanks in advance. [code] Logfile of HijackThis v1.99.1 Scan saved at 9:28:14 AM, on 1/22/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.5730.0011) Running processes: … |
| | system restore comes up blank nothing to choose from here is my hijack this: help me PLEASE!!! Logfile of HijackThis v1.99.1 Scan saved at 7:39:47 PM, on 1/19/2007 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 … |
 | [COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I … |
| | I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL … |
| | I need to complete a task, although I am not quite sure how? The task is to create a very unusual search system for a car rental site. There is a database of cars that the rental company possesses, and when the user specifies the rental dates - the list … |
| | Hi Friends, I have the following query, i am using the column alias by this way, select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature it works fine and i get this output. Work Code Work Nature 1 External 2 DE-Sales 3 DE-Miscellaneous 4 DE-Equipments &Transport But my requirement … |
| | [COLOR=#008000]I have a table with a primarykey ID and a unique key for ID_EMP and OSID When I insert I want to populate the OSID column whth the next int value related to id_emp My trigger works but is returning the error message: Warning: Null value is eliminated by an … |
| | In my database, I have two tables: Forum and Files Files have two fields. First one is [B]FileID[/B] and second one is [B]FileAddress[/B]. [B]FileId [/B]field is fine. but in [B]FileAddress [/B]field I have a lot of urls. I want to just change certain parts of url. For example, instead of … |
| | We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or … |
| | |
| | Greetings. How are all of you? I'm new to Daniweb, but heard of you through Mauisun. Anyhow, I have a copy of SQL 2000 standard, but it's an old school copy without reporting services. I understand that 2000 now comes with RS for free... does anyone know where this "free" … |
 | Hi guys. Hope you can help me with my problem here.. It's quite complicated so I'll try to explain it in a very detailed manner.. I have these two databases which we may call dbaseA and dbaseB. I created another dbase which we call dbaseC. dbaseC is going to be … |
| | I'd like to split a full name field on a space into first name last and update my database, I would prefer to stick to TSQL/SQL if it can be done on SQL Server 2005, any ideas? table actors actor_id int Unchecked actor_name varchar(50) Checked rating smallint Checked actor_last_name varchar(50) … |
| | Hi Guys I've got a bit of problem with date. When I transfer data of a table to txt file the date column that appears in the table like "28/03/2001" changes to "28/3/2001 0:00:00" in the txt file. I've tried to change the format of date in the table but … |
| | This is the most bizarre network issue I ever came across. I have been fighting with this for several days now and could not figure out whats wrong with my PC. Hopefully, someone here can help me with this. I have IE7 installed and even though I have the network …  |
| | Hi all - I am a newbie to this forum, but maybe someone there can help. I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, … |
| | If i go to, [URL="http://www.adkjasdljsadjasj.com"]www.adkjasdljsadjasj.com[/URL] it should pop up a page that says "Page can not be found" but now its giving me this random page that has porn links all over it. I use E-wido and i love this anti malware program, but its not finding the virus. Im …  |
| | Greetings all! To get to the point, I'm having issues accessing SQL databases. The specific error is as follows: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here's the setup: The workstation(s) … |
| | Hi all, DECLARE @STA as char(50) SET @STA = 'TT' SELECT * FROM ABC_TBL where ABC_Filed in (@STA) if i have multivalue in parameter @STA, like 'TT', 'DD', 'AA' so how can i write my statement? i only need to pass one parameter with multilist, so do anybody know how … |
| | How can I find active users and UsersID online in MSSQL ? I cannot find it in Enterprise Manager ? Someone know a scripts that can do ? I need to find active users before I do some upgrade jobb on servers ! Thanks in advance.... |
| | I'm getting the error [inlinecode]Incorrect syntax near '='.[/inlinecode] when I use the following case statement in a view. Obviously I'm not an expert on MS SQL, but I'm curious as to why I am allowed to use the '=' sign in a preceeding statement but not in the THEN section. … |
| | I have a web site that I've set up, and has been running for several years. The client has MS SQL Server. When it comes to the administration side of SQL Server, admittedly I don't know enough. The web application has been running fine, but we've been getting errors with … |
| | Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …  |
| | Hi Guys, I'm having some problems in importing data from a file into a table. I created this file by exporting data from the same table. I've deleated all the records from the table and now I want to fill it up from the file I've created I'm importing data … |
| | [COLOR=#191970]The data table looks like this date num1 num2 num3 num4 num5 num6 1/1/06 1 45 32 21 15 48 SQL script 1 should be able to do the following show the Top 3 number pairs another words if the pair 45 and 15 shows up 98 times and 32 … |
| | Gentlemen: :?: Sorry to have posted twice, but I really messed up the title. Can anyone send me to the right contact for some SQL Topology assistance? I have posted on several SQL Forums and everyone seems to dance around this topic. I need to find out the proper way … |
| | hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me |
| | [COLOR=#191970]Can anyone possibly give me some pointers on how to speed up access to a central SQL Server from 3 remote sites. Currently 2 of the sites use 3mg DSL and the other uses Broadband Cable 3mg. All are VPN's into the server through SonicWalls. This topology is extremely slow … |
| | Hi Guys, I was just trying to transfer data from access tables to a txt file and then back from file into a table using following code [code] Private Sub Command0_Click() DoCmd.TransferText acExportDelim, "Db Export Specification", "AUTHENTICATION", "J:\Power Equipment\Common\SK\db.TXT" End Sub Private Sub Command1_Click() strSQL = "delete * from AUTHENTICATION_TEST" … |
| | Hi :) Im not an SQL n00b, but I'm no SQL guru... I'd like to work out the SQL code required to achieve the following goal in pseudocode: Grap a record Using info from that record, add (the width) to a running total. When the running total exceeds a certain … |
| | Every time I try to play one particular dvd that I burned, the computer shuts down and restarts giving an error message: The system has recovered from a serious error..." Is there anything in my log that tells what is causeing this? Logfile of HijackThis v1.99.1 Scan saved at 11:29:41 … |
| | i have two questions? i made my window application in c# using standalone firebird database ,now i want to make my exsisting application database as emmbedded firebird database???? how can i,and also want to implement import feature in my application,which imports the database backup file(export is working fine). |
| | Hey, I've got a databae in which each record has seven dates associated with it, and I need to pull out each record's ID and its associated most recent date. Here's my first attempt, but Access doesn't like it at all. [code]SELECT id, MAX(initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate6) …  |
| | Hi all!! Is there a way to return 2 cells merged in one? For example take the followng table: | A | B | C | |abc | def| etc | and from this do a "SELECT A, B FROM table WHERE C='etc'" but instead of getting two values "abc" … |
| | hi, after I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2005, is there any way to create a script for all these setting that I've done? So that I can just modify the database name and run it on another pc, the … |
| | Let's say I have a column within a table that contains codes {0,1,2,3}. These codes are for what color shirt are in stock. We can say 0 is for black, 1 is for white, 2 is for red, and 3 is for blue. Then I run a SELECT query on … |
| | Hey I am just starting to play with some SQL stuff after upsizing a old access database. What i would like to do is be-able to pull information out of the SQL database and display this on a web site. The query i want to use i have built using … |
| | Hello there, I need a help. I have a computer that has windows 2003 server installed and I have 9 clients in domain control that use SQL Active Directory, an aplications in Visual Basic. The problem is that whenever they try to use it is soooooooooooo slow and if I … |
| | I have the "Critical System Error" in the task bar. I have run Hijackthis the log file will follow. Can someone please tell me what I have to do to remove this bogus alert? Logfile of HijackThis v1.99.1 Scan saved at 10:08:02 PM, on 11/17/2006 Platform: Windows XP SP2 (WinNT … |
| | l am trying to get rid of this spyware that keep on flashing in my taskbar. l try everything to get rid of it. l use a program call hijack to scan the computer,here is my log report please help me out to rid of it. thak you .. Logfile … |
| | When ever I restore the master database I put the server in single user mode using "sqlsrvr.exe -c -m" at the command prompt. When I successfully restore the database I go to restart MSSQLSERVER service and it will say it is starting but will stop. I am able to login … |
The End.