3,481 Topics
 | |
| | Windows explorer.exe was crashing & rebooting itself. On Startup, explorer.exe would show the desktop for about 10 sec, then crash for about 10 sec, then cycle through the same for about 10 min until it just would not start up again. Following the instructions for cleaning from another post: [URL="http://www.daniweb.com/forums/post738435-2.html"]http://www.daniweb.com/forums/post738435-2.html[/URL] …  |
| | i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 connected users only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will … |
| | G'Day all, I've got a plugin for an application. When it's installed it runs the following:[CODE]Alter table DocketItem ADD Optimised BIT DEFAULT 0 NOT NULL[/CODE] However, when the plugin is uninstalled it tries to run the following: [CODE]Alter table DocketItem DROP COLUMN Optimised[/CODE] When the plugin is uninstalled, I get … |
| | Hi We are going to be starting a new ASP.NET website that will use an MSSQL database and the database is likely to eventually fill up as each database has limited size. Is there a way to have a database overflow into a new database when it is full but … |
| | Hi I am Salman, I am using Windows Xp Sp3. some websites which i used to visit regularly have stopped opening they will just stop at Transferring data from websites... and will stay there for rest of the tym. Here is my Hijack-This Log . [CODE]Logfile of HijackThis v1.99.1 Scan … |
| | The following stored procedure is supposed to add a new record to the database OR update Mdescript if it already exists. However I keep getting errors such as primary key violations. Please take a look, many thanks :) [CODE=SQL] USE [COSHH2008] GO /****** Object: StoredProcedure [dbo].[CHSP_OR_ACTIVITYAREA_001] Script Date: 12/02/2008 13:59:33 … |
| | Dear Friends, I have created a dll in VB 6.0 and i am calling this dll using a trigger which is for INSERT record. But when my application inserts a record to the table, Trigger runs succefully but record is not inserted and gives this Error: Description: Receipt. Database error … |
| | topic continued from here: [url]http://www.daniweb.com/forums/post748453.htm[/url] |
| | I'm trying to display data in cold fusion but when I add my history table I get duplicate listings. I've tried select distinct different joins. How do i join my history table and not get duplicate listings My store procedure in MS SQL is [CODE]USE [Website] GO /****** Object: StoredProcedure … |
| | I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the value of the autonumber from a master table and write it … |
| | I have converted around 395 Excel survey forms to MS SQl database with that many tables. Well, I run a script to assign a primary key on all the tables on my database.First I set the column property to NOT NULL and then i assign the primary key to it. … |
| | I would like to create a variable in my trigger - @DBNAME. When the trigger executes, this value should be set to the name of the database it was executed in. E.g. for the master database the value of @DBNAME would be master. How would I go about figuring out … |
| | Hello, im a rookie i would like to connect to a MSSQL2000 server Retreive information post it on the website then detele it on a condition please help i have compiled this so far. [code=asp]<% '* database server parameters Dim serverIP '* ip adress Dim serverPORT '* ip port Dim …  |
| | Hi all, Just a quick question: I have my website done and the database I used is MS Access. Problem is MS Access' return of results are really really really slow. Now I want to shift to SQL server, but the web hosting site we paid does not support this … |
| | I have a nasty infestation of virus/spyware or something on my pc that causes frequent freezing. here is a hijackthis log. On a side note. Last year my pc suffered a lot of damage to most of the default programs with windows xp. Does anyone know if getting a reformat …  |
| | |
| | Hello! I want to use the following code [code=sql]SELECT * INTO Persons_Backup IN 'Backup.mdb' FROM Persons[/code] But all I ever get is the error message: "Incorrect syntax near IN" How could I solve this? But when I miss the IN clause, it works perfectly. I think the problem is that … |
| | I am using MS SQL server, and I'm trying to create a SQL query that adds data to a "Reminder" table if data in the "Occurrences" table meets certain criteria. This might be a little difficult to explain. Here's the problem... I have a table "Occurrences" which i updated every … |
| | Hi I wonder if someone can help me - I've recently started getting random redirects from the google search page. Looking through some of the threads I've attached a hijack this log of the computer. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 22:42:46, on 29/10/2008 Platform: Windows XP … |
| | Very interesting bug I am noticing with my PC that's been happening since yesterday. The file iexplore.exe will start up and run for a few moments, and then shut itself down. However, when it does this, it opens no windows to Internet Explorer at all. It just spikes my processor … |
| | I need help with joining these two tables: Table1 idx idy --------- one 1 two 2 tree 3 Table2 idy u ------- 1 a 2 b 3 c 4 d 5 e 6 f I want to show rows from the Table1 that have idx=one joined with all the rows … |
| | Hii Group, This is samuel Like to hav a small suggestion from you hope u ppl do. "[B]I would like to copy dat from one table to another of the same database in a give timestamp,I mean when system time equals to the feild time then the entire data should … |
| | Hello, I have question about backup and restore procedure for MS SQL 2000. If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. … |
| | Hello, I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I … |
| | |
| | I have McAffee enterprise edition, and it worked for peanuts!, it identified there was a virus, and bam!, I was still hit, and hit hard. *there ... I vented that one off :-)* I have a file in the RUN entry of the registry: C:\WINDOWS\system32\kdyvj.exe that upon deletion is immediately … |
| | The following query: [code]CREATE PROCEDURE GetDistance AS SELECT a.ZIPCODE, a.CITY, a.STATE, ROUND( (ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) ) ) * 3963,1 ) AS distance FROM Zipcodes a, Zipcodes c WHERE ( ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) … |
| | Hi Everyone, I am new to ASP.NET, i am currently doing a project. I'd like to create a log in page using code. please assist. Some one give me a code sample of a log in page. Including connections to MSSQL database. I am totally lost. A step by step … |
| | all links on search engines are re-directed to seemingly random pages. Majority of anti virus and spyware programs are blocked from being downloaded or installed. managed to get a hijack this log. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 8:06:14 PM, on 11/18/2008 Platform: Windows XP SP3 (WinNT … |
| | |
| | I am an amateur when it comes to Advanced SQL but here is the situation. I have a Test Table with data such as below: Name(char) Qty(number) Date (char) Location (char) Test1 1 11/14/08 10000 20050 Test1 1 11/14/08 10000 20100 Test1 1 11/14/08 10000 20000 Test1 1 11/15/08 10000 … |
 | Hi all, I have a server in our network contains the database of the project (SQL Server 2005). Suddenly a developer computer couldnot connect to the database which in that server. and now another computer did the same. The strange is the designer computer which still connecting to the server. … |
| | Hello, I have an application that uses BLOB for files in MSSQL 2000 database. I do a full backup once a week and transactional backup everyday. Does transaction backup includes BLOB? If I restore transaction backup is it going to restore BLOB as part of the table. Thanks, DC9 |
| | Hi Fellows, Well. let me start by higlighting the problem i face.I have two columns namely PID which is the primary key and also a auto number.The second is Serial No. which is also a auto number. The problem i face is that when i submit my form spcifying a … |
| | hi I am new in SQL Scritpting and my question might sound stupid, but please help me out to understand. Can one explain the difference between the two and similarity? The need and and use of the two? As for Temporary table does one create them or it comes with … |
| | I noticed that many ppl have the same problem im having i got this check core .dsk in my c:windows/system32/drivers i have hijack this but am gonna need some help removing it ill post my hijack this log now thanks for any help in advanced ...p.s. im a little more … |
| | Hi Guys, I have some confusing part in the sql command the question is i have 2 different query : a)[code=sql] Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID[/code] b) [code=sql]Select Sum(Amount) as Total FROM TABLE3 [/code] the result if a) query is 100 … |
| | I have questionnaire that has two radio buttons(one is "Register" and the another one is "Drop") in it and all answers are saved in an SQL database. For Example ,when the user checked "Register" and then by clicking "Sumbit Page" the values stored in the sql database.When the user returns … |
| | I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA. |
| | HI! I've got a problem... Given the schema below I need to create an SQL query, but for some reason I think there is something wrong with it.... BRANCH(BRANCH-NAME, BRANCH-CITY, ASSETS) Query: in what cities are the branches where the maximal bank assets are less than £200,000? So I've come … |
| | I have a problem in my SQL 2005 Data Warehouse. I'm using a slowly changing dimension data flow transformation in SSIS which will not delete any records from my DB when they are deleted from the source data. I need to keep the dimension keys, but in this one case/one … |
| | Hi All, I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder. I have a table projects and a table clients [B]Projects_Tbl[/B] ProjId ProjName ClientId [B]Clients_Tbl[/B] … |
| | i am working in sql 2005, i have problem in Sql collations. our database modified in different people, some time we get collations error. how to solve this error? and how to avoid this problem in my future? |
| | I have to tables as parent & child tables as below Table 1 TID1 Name 1 Test1 2 Test2 3 Test3 Table2 [U]TID2 || TID1 || ID1 || ID2 || ID3 || Name[/U] 1 1 1 2 3 All 2 2 2 2 2 All2 3 1 1 1 12 … |
| | I have several questions: Here is the context: The ASP.NET application I'm building - a web service in essence - will be connecting to MSSQL to log requests to a table. These are basic INSERT commands. During high-volume hours, do I risk race conditions? How does MSSQL handle sequential INSERT … |
| | can't solve a homework problem for computer class. Any clues?: Given two tables, USERS and LOG, where USERID is a primary key in USERS and a foreign key in LOG, write a SQL statement that will return LOG records (all fields) with corresponding USERIDs in USERS. The report should include … |
| | Hello Guys, I was dumped in the middle of a project with not a lot of experience in MS SQL server. I have 3 little questions 1) If i receive a bak file(restore file) from another server, is it normal that if i restore the file i will no see … |
| | Hi, In my Insert SP, I have 5 local variables: @MemberID int, @VideoID int, @Total money, @DateRented datetime, @DateDue datetime insert into RentalRecord values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE())) When I try to execute the SP, I get this error: Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied. Please advise. … |
| | is it possible to convert system made from php with a database of mysql to ms sql database..? how? thaks |
| | Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in … |
The End.