3,481 Topics
 | |
| | From last two days i am searching for the answer of this querry. I want to know how can i access the rows of tables in stored procedures using loops(Without cursor). We don't want to use cursor for that because of the performance issues.  |
| | Hi..... i create a new user in mssql... user is --- kumar now i login to mssql by using the above user... now i login to mssql with another console by using administrator account..... now i try to delete the account(@ present in administrator account) -- kumar .... then the … |
| | Anybody famliar with 04cg0ryk.dll. I get an error when I start my computer. The computer can get to it but[I] I found it in the regestry. So I ran Hijack which is for dll problems. This are my results. [/I] 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:\Program Files\Windows Defender\MsMpEng.exe … |
| | 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:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\brsvc01a.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\brss01a.exe C:\PROGRA~1\COMMON~1\AOL\ACS\acsd.exe C:\Program Files\Symantec\LiveUpdate\ALUSchedulerSvc.exe C:\WINDOWS\system32\Brmfrmps.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Binn\sqlservr.exe C:\Program Files\Norton AntiVirus\SAVScan.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\wanmpsvc.exe C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Common Files\Symantec Shared\ccApp.exe C:\WINDOWS\system32\carpserv.exe C:\Program Files\Synaptics\SynTP\SynTPLpr.exe C:\Program Files\Synaptics\SynTP\SynTPEnh.exe C:\Program Files\ATI Technologies\ATI Control Panel\atiptaxx.exe … |
| | I'm about ready to reformat. Can anyone help me? I'm afraid to infect my entire network and lose my job. Please! here's the log from hijackthis Logfile of HijackThis v1.99.1 Scan saved at 11:41:10 AM, on 8/24/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running … |
| | Very stormy weather here. Hit blue screen which disappeared in crash so fast I couldn't read it. Programs are freezing, followed by flurries of Requests to Report but task manager unresponsive to shut down. Checked properties in some of the dll entries in my registry that showed two different formats … |
| | Hi guys, I have this situation.. The Min funcition in SQL returns lowest value in query but I what to return is the 2nd lowest instead. Take this table for example col=Pay(3000,2300,1000,1900,1200) Min(pay)=$1000 but I want to return Min2ndlowest(pay)=1200 Is there a way to solve this problem. Thanks for help … |
| | Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group-> INTEL\FR6EnterpriseDB (Windows NT) Btw … |
| | First of all Hello to this forum. I have the follwoing problem. When I am runnig an UpdateCommand with codebehind : sqldatasource1.Update() I get the following error. (I want this command to CompareAllValues) [COLOR=#000000][B][I]You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed … |
| | I've been recently having troubles opening a few files. BearShare, Morpheus and Limewire to be exact. I regularly used Bearshare, then one day it kept closing on me. So I downloaded Limewire. Same deal. Now with Morpheus, same deal. Here's my Hijackthis log. Any and all help is appreciated. [QUOTE]Logfile …  |
| | Below is a working program that goes through the xml document and outputs all of the data to an output file. That part is fine, but what I need help with is that the tagname Comments: in the xml document will have the word Patch* in it. I need to … |
| | Hello! I came here through a Google search, and used the instructions given to that person. Well, the event log says: "Virhesovellus svchost.exe, versio 5.1.2600.2180, moduuli netapi32.dll, versio 5.1.2600.2180, osoite 0x0000a3c0." I don't remember installing anything suspicious, it started yesterday. Oh right, I almost forgot the HJT log: [QUOTE]Running processes: … |
| | Hello, I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: … |
| | I'm having a problem with SysProtect, I ran ewido, avast!, Norton, and booted up in safe mode turned off system restore and did those things again... HJT file: Logfile of HijackThis v1.99.1 Scan saved at 2:45:47 PM, on 8/6/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 … |
| | Hi all, Please help me I cann't shut down my windowXP. It keeps telling me that rundll 32 is not responding . After I clicked "end task" for this error , it pops up again and again for a few times, and then the system is able to log off …  |
| | My computer is really slow lately and all my anti-virus programs (ewido, and Norton) say I have a trojan... but Norton couldn't do anything to it and ewido was able to delete some (that keep coming back) and quarintine the trojan dialer, though.... ewido says i have: [B]Trojan.Dialer.qs[/B] [B]Worm.Randon[/B] [B]Downloader.PurityScan.cq[/B] … |
| | I recently developed a problem with "Trojan.Adclicker". It is being recognized and deleted by Symantec anti-virus every time I restart my computer, but this is getting old. Any help will be greatly appreciated! Logfile of HijackThis v1.99.1 Scan saved at 8:46:32 PM, on 7/10/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) … |
| | Hi i having a few problems what i need to do is find duplicate rows in a mssql database i can do from one table but i need it to run across 2 tables this is the code i useing to do one table SELECT COUNT(*), sID1, sID2, sID3 FROM … |
| | Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in … |
| | Already typed my post once, having to do it again.... With the following code in MS SQL 2K: SELECT Users.*, Trainers.FirstName AS TFirstName, Trainers.Surname AS TSurname, Trainers.DisplayAs AS TDisplayAs, Trainers.DIRealname AS TDIRealname, Trainers.UserID AS TUserID, Trainers.TrainerExpiry AS TTrainerExpiry FROM Users LEFT OUTER JOIN Users AS Trainers ON Users.UserTrainerID = Trainers.UserID … |
| | product transaction date -------------------------------------- 1 06/07/2006 2 06/05/2006 2 06/10/2006 3 06/09/2006 I have a table like above, now I want to retrieve the latest transaction date for each product, so the result should be: product transaction date -------------------------------------- 1 06/07/2006 2 06/10/2006 3 06/09/2006 I try to use statement: … |
| | bottom here is my asp coding, for connecting to mssql2005 i know how to connect to mssql by vb using the com+. but i want to try using the database connection on asp page. [code] <%@ LANGUAGE="VBScript" %> <% Option Explicit Dim UID, SQLStmt, Connection, FirstName, LastName Dim RS, SSN, … |
| | There has to be someone out there who can help. I have been losing programs on my computer recently. I would use the program. when I was done at the end of the day, turn off the computer, and the next day when I turned the computer back on, my …  |
| | Can't change our home page and need help. HJT scan is below. please help! John Logfile of HijackThis v1.99.1 Scan saved at 2:48:32 AM, on 7/23/2006 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) 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:\WINDOWS\system32\spoolsv.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe … |
| | I am attempting to apply an SSL certificate on a per client basis in SQL 2000 (Windows 2000). I have read a number of MS Knowledgebase articles on the subject, and followed their directions, none of which seem to be working. After installing the certificate, the directions say to export … |
| | We are getting frequent error in display while processing through web, we are having higher end hardware , ML350G SERVER,with 4GM Ram, duel processer capable, 145x3 hard disk, We are having 30 GB Space in C: Drive and 240GB in D:Drive, we have sql database upto 17 GB, the process …  |
| | Hi all, Please help me in solving following query. Can we define in sql server the same parameter as input and output? How to do it? Thanks and regards, Swapnil. |
| | I currently have a form that i have created using html, (can create in another language if makes it easier) however, i can't seem to find how to send the information from that form to my database. I have searched over the internet and asked some people that I know, … |
| | Hi !!! I m Jai and pursuing engineering in IT. We have to do a mini project in DBMS. I have decided to do a project for mainting Insurance policies. Pls help me out for its case study. Also suggest me any other new topic if possible. Thank you. |
| | Hello, I backup my databases like this: [I][B]dump database MYDATABASE to disk='c:\temp\MYDATABASE.bak' with init[/B][/I] [B][/B] This saves the structure and data to the bak-file. Now, for some DB's I want to save the structure only, can someone tell me how to do this? THX pakko |
| | I need some help with this virus. I'm not too savvy on fixes, but I've tried some and not having any luck. Can you help please? below is my hjt log. Thanks!! Jessica Logfile of HijackThis v1.99.1 Scan saved at 2:48:32 AM, on 7/23/2006 Platform: Windows XP SP1 (WinNT 5.01.2600) … |
| | Hello, i'm currently working on an online game (browser based), and obviously, since all of the contents is meta-data, I have loads of DB-related work. Recently I came into a brick wall while trying to figure out how to make one of the more important features of my game to … |
| | hello frinnds, i am new to this forum.........afte seeing this i feel it is gonna helpme..... right now my problem is-> i am usin msql, here i am using a table in a database..inside this table i have field called [B]ID, i[/B] want autoincrement feature for this field......... i don … |
| | I own a small web site / hosting company and I had a hard drive failure and my back-ups didn't work perfectly. I have a complete back-up of my C drive from May 2006, but I can't figure out how to restore my MS SQL. Can anyone help? thanks, Marc |
| | 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 … |
| | Tried some of the previous fixes for about blank adware / malware with no luck. My "ewido" keeps pulling C:\WINDOWS\System32\hp100.tmp as Malware infected with Downloader. Zlob.qe but never seems to really fix it. Below is my latest scan - any help would be greatly appreciated as too many hrs invested … |
| | Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number … |
| | I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this? |
| | Hi - this may seem like quite a simple query but i'm new to the SQL world... I have a column in my database (DB_Users) called Email - how would i go about extracting all of the email addresses in the column? I am using SQL Server 2005 and i … |
| | Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not … |
| | Hi All, I am writing this just to even know if this is possible. What I would like to do is a UnGroup. Crap this is so hard to explain...okay I have a table in sql that is five columns long. The first Column is, ohh never mind. Copy and … |
 | Visual C++ Error - Buffer Overrun Detected! I have had no success getting rid of this error message. When you open IE, the error is generated. If you immediately open IE again, it works fine. After about 5 minutes, when you open IE again, the error message reappears. I noticed … |
| | Hi there. I really hope someone can help me before I pull my hair out. About a week ago our Nanny's kids used my computer while I was out and when I returned there were two short cuts on the desktop. One said "Free I-pod nano" and the other said … |
| | How do I find, alter, create, edit, etc. the stored procedures, triggers, and foreign keys on an MS SQL 2000 database? I'm trying to figure out how a given database maintains its referential integrity but I can't get behind the scenes on those things. I'm using SQL Server Enterprise Manager … |
| | Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i … |
| | I have a DB which have three types of users: students, admins, and volunteers. I am trying to use SQL Server Enterprise Manager 8.0 to set up those roles such that students can (where appropriate) select, insert, update, or delete from given tables/rows; similarly for admins and for volunteers. (The … |
| | Hi i try to sum two column in Sql, but don't get it.... this way is not working.... [COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#808080]+ [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])))[/COLOR] [COLOR=#808080],[/COLOR] and with that is not working to [COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#000000] as A ,[/COLOR][COLOR=#808080] [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])) as B[/COLOR][COLOR=#808080],[/COLOR] sum(A+B) as Result can someone … |
| | hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields. |
| | Hi Gurus, I have little bit idea to Create a DTS Package to copy any 5 tables from Pubs to Northwind. but how can i do the following ..? Create a log table to store the package start time, end time, execution duration, records affected. When any transaction inserts/updates/deletes any … |
| | Hi friends, As title refers, my problem is related with connection to the sql server. I use MSSQL Express 2005. My program, that is written in php, tries to connect to the server but the connection is failure.I didn't create an account from login under root and my connection type … |
The End.