Hi, Does anyone have a function which replaces accent chars from a string with the non-accented equivalent? For example 'hôpital' should return 'hopital'. Thank you in advance....more >>

I have this stored proc that is to look for changes only between 2 tables and inserts the changes into one of my temp tables that I later delete in my DTS flow. I am running into a problem I think becasue in my query I am joining on fields that may not exist yet in one of the tables. Is th...more >>

What are gotchas for starting Sql & the agent with a Local system account versus a system Domain account. ...more >>

There is a form in an Access Project (.adp, Access front end with SQL Server) for entering data into a table for temporary storing. Then, by clicking a botton, several action stored procedures (update, append) should be activated in order to transfer data to other tables. I tried to avoid any ...more >>

Hi Experts, i am writting a stored procedure in sql server 7. Its a simple stored procedure It is my first stored procedure. I want insert a record in table if the primary key field user id already does not exists. if it exists SP should pass 0 as output else if insert is successfull it should...more >>

hi i have a db with hebrew collation. i now want it to be cyrillic collation. converting the db collation - wont help. i tried exporting data to a blank DB created with cyrillic collation - still, no good. what is the best way of having a DB with a certain collation so no matter the desti...more >>

I am planning to build a server to be used as a SQL Server and web server. Right now I can only use a single box for both. I have read some threads were dual processors are having problems with some parallel queries and the suggestions of having sql server use a single CPU. My budget is li...more >>

Today I was asked the following question but I don't know the answer. Could you guys tell me the answer and explain why? CREATE PROC TestProc @I int OUTPUT AS SET @I=1 RAISERROR ('An error',18,50) SET @I=@@ERROR go DECLARE @I int EXEC TestProc1 @I=@I OUTPUT select @I go I d...more >>

Is there a tool that can report transaction log information? Such as reporting what tables/columns were updated, by whom and when, etc....Thanx....more >>

Whats the difference between sql 7.0 and sql 2000? I'm learniing sql 7.0 but was wondering if I'm ,wasting my time...more >>

I am confused about windows account, win dimain account, sql login accoun and sql database user account.... can you give me a fresh example to show the exact relationship between them and how they work together?...more >>

I want to Insert 10000 rows at a time and commit in sql server , Is there a way to do it if the source tables have no id fields ? What would be the most efficient method? Thanks Ajay...more >>

I haven't used the READ UNCOMMITTED transaction isolation level before, and I was wondering if this would be an appropriate use: I have an ID table containing ID numbers that are randomly generated and need to be unique. There is a stored procedure that potentially generates thousands of these...more >>

Can you restore a SQL6.5 backup to a Sql2000sp3 ? ...more >>

Hi all In the SP below im (trying to) do some dynamic sql. As you can see the table to use is set as a variable and the 'exec' method used to run the sqlstatements. My problem is that the 'if exists' method is not doing what i was hoping it could do. The @presql command returns somewhere bet...more >>

I am new to sql query and have a question. I would like to display row column values as column names. questions table consisted of question_id, group_id, question response table consisted of response_id, group_id, question_id, answer I would like to display the answer responses under...more >>

We've found deadlocks in the trace file that were not captured by our Powerbuilder application. Some deadlocks are trapped or, at least, reported to the user as a db error, and others are completely silent. We've also seen evidence of strange data that would be explained by unprocessed deadlocks...more >>

Dear All, I have developed a Data Access Page with Access as a project. It is connected to a SQL-Server database. I try to edit the data in the table and am not able to do so. I might be missing some permissions. I have changed a number. What am I missing? Thanks in advance. Jeff...more >>

Hi, I'm pretty much a database beginner and have what I think is a basic question: If I have a table which has a 'status' column and I can have say three statuses: "active", "pending", "inactive". Is it better to break these out into a different "Statuses" table? On the one hand it seems...more >>

Hello What should I use for better perfomance since unique constraint always use index ? Thanks Kamil ...more >>

I have developed an Access 97 database that I would like to distribute to a number of staff, but they do not have Access. At the same time I am considering upgrading to SBS 2003 premium edition which comes with SQL Server 2000. 1. If we were to upgrade would it be a very difficult job to recre...more >>

I have two databases with each one on a different server. I can copy both databases to the same server with no problems. But how do I merge them? This is what I came up with so far but how do I do the same process for multiple rows and tables? IF NOT EXISTS (SELECT tmp_DB1.dbo.tb1.key1 F...more >>

My SELECT query returns a data set, one column of which contains a set of values corresponding to the same date. I.e. for each date in column "Date", I have a set of numbers in column "Numbers". However, I am only interested in getting the largest value in column "Numbers" corresponding to each ...more >>

Hi. I have a problem I hope someone can help me with. I have a database of events. Each event has a date and a duration (days). What I need to do is to be able to display search for events on some web pages. My problem is that if an event is on say 15 nov 2004 and has a duration of 3 da...more >>

Hi, I am having a problem with aquery. Firstly here is a script to create the table and insert some sample data: CREATE TABLE [dbo].[tbltemp999] ( [Machine_Name] [char] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [EventDate] [datetime] NOT NULL , [EventID] [int] NOT NULL ) O...more >>

Salve a tutti, io ho un problema di questo genere: eseguendo il comando DBCC CHECKDB('DATABASE') il motore sql mi restituisce questi tipi di allarmi: Server: messaggio 8909, livello 16, stato 1, riga 1 Errore di tabella: ID di oggetto 1093578934, ID di indice 0, ID di pagina (1:7). L'ID di pa...more >>

Hi all I recently noticed when trying to optimise a major query of a chess website I am the webmaster of, that adding an order by for "gamenumber" which is a clustered index field as in for example "order by timeleft desc, gamenumber desc" actually speeded up the queries and reduced sql server...more >>

Hello All, None of the solutions I have found in the archives seem to solve my problem. I have a date column in my tables (stored as a char(10)) which I would like to append a leading zero to for those dates that start with 9 or lower. Any ideas? Thanks, Mike ...more >>

Hi all, I am getting below error messages mentioned between dotted lines. --------------------------------- fcb::ZeroFile(): GetOverLappedResult() failed with error 2. The log file for database 'UAT' is full. Back up the transaction log for the database to free up some log space....more >>

I created a index on a computed column. I did not see any improvement in performance with a join to this column and also my inserts and updates to this table are failing. Any ideas? Chender...more >>

Hi, I have been able to JOIN ON CONTAINS(column, 'whatever'), but can't seem to get the syntax right to join on one field containing a related field. The query below is what I am working with... As written, everything inside the single quotes is interpreted as a literal string. I.e. "FormsOf...more >>

Table: All columns int -------- Col1 Col2 Col3 1 1 4 1 2 4 1 3 7 2 1 8 2 2 8 2 4 8 3 1 8 3 2 8 3 3 9 Query Requested: ---------------- Declare @valueforCol2 set @valueforCol2...more >>

SServer PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM SQL Server 2000 v 2000.8.00.76 (sp3) MS Office 2k3 MSJet ms04-014 (latest ost sp8) MDAC v2.8 RTM ADO 2.1 vb6.exe / ADO 2.0 I think this is a SQL Server/ADO problem as I have 2 applications with same problem. My access datab...more >>

I've seen plenty of posts regarding the estimation of table size, usually in the processing of planning for server storage needs. Well, I've got a different problem. I need to know how much data each of our Customers are using in a Database. (1 SQL DB stores multiple customers). Basically, ...more >>

Hi guys, whilst working on a project which I thought was nearly complete I have come across a problem which was some how over seen, which I am hoping one of you guys know how to resovle. Firstly here is the script to create the table and insert some sample data: CREATE TABLE [dbo].[tbl...more >>

The dean of our school requires an annual report from 8 departments every year. There are 23 categories that the dean wants info for. In the past, these departments each created a booklet, sent it to the dean's secretary, who then summarized the booklets, then created another booklet to give t...more >>

Does anyone have a UDF or Stored Procedure that checks for transposed numbers in a group?...more >>

I have a table containing multiple records per key. eg: 1 | John Smith 1 | Mary Brown 1 | Julie Grey 2 | Danny Pink 2 | Jill White I need to consolidate this into a single record for each key, eg. 1 | John Smith, Mary Brown, Julie Grey 2 | Danny Pink, Jill White I can achieve this u...more >>

Is it possible to load both the SQL 7 database and transaction log backups to SQL 2000 ? I assume it will perform the upgrade during the load. Thanks, James...more >>

I am trying to append records from one table to another in a db running on MSDE, knowing fullwell that some of the data in the source will be duplicates of that in the destination table's pk. What I would like to happen is to have the stored procedure plunk in all records that don't violate the ...more >>

Hello, SQL gurus! This message use HTML tables (in case you see a bunch of gobbledy-gook). I need to modify an SQL statement: SELECT DISTINCT Trim(InvtID)+', '+Trim(Descr) AS Item, month, = Sum(QtyShip) AS Qty FROM Sales_View=20 GROUP BY Trim(InvtID)+', '+Trim(Descr), month, CustID=20 H...more >>

Hi, We have XML files (and its XSD) that are dump of our tree-like data structure in memory. These XML files may potentially have unlimited levels of nesting because some elements can contain themselves (recursively defined). We want to build some reports using some third party reporting to...more >>

I have the need to remove a constraint on a table since I'm trying to alter the datatype of one of the columns. I know I can drop the constraint given the name, but since the name is auto generated (something like DF__WHRPT_ITV__Expor__45F365D3) I need a way to find this constraint name so that ...more >>

Hi all We had a small problem when an ASP web page had a missing 'where' statement and updated all the records in the table. Luckily we could retrieve all the data from the backups. How do you guys prevent this from happening in your large systems. Is there some teqnique for controlling ...more >>

[MS SQL Server 7] We load a table from a text file using Data Transformation Services. The source file is already sorted by primary key order. After the DTS load, the default retrieval order on the target table (select * from targettable) appears to be random. I know that theoretically t...more >>

MS SQL Server 2000. My case is: I have the table T with primary key calling __recid int without identity property. This table includes a lot of records (about 1000000). I need to convert __recid's data type to IDENTITY. As you know sql sentence: "alter table T alter column __recid int IDENTIT...more >>

Someone emailed and requested me to post it on Usenet newsgroups. Sadistic FBI agents should be tortured the way how FBI sadists and perverts tortured this poor guy (non-muslim) for three years and continue to torture him even after he left america tracking him with implanted transponder ch...more >>

I've got a SQL Server database. Nearly finished. It's going to go on a single non networked machine. One day somebody might get access to it over ADSL (probably TS), but for now it's a single user no lan. The machine will actually be running the MSDE. Windows XP Home. I'm quite happy, for no...more >>

Hey all, I am currently researching ways to compare databases via an XSD schema. I wrote a small app that creates a dataset from a database and exports that dataset to XSD. This gives me an XSD file with tables and relationships representing the entire database. At this point, I am tr...more >>

Hello I want to insert an iostream object into a ms acces db. I use ole-obect as the data type for the specific column. Inserting a new record works fine but somehow the field where the ole-object (iostream) has to be interted stays empty. Is ole-obect a proper data type for an iostream or ...more >>

hello I make every week on sunday a full backup of my database(mdf =60MB / ldf = 300MB) additional i make daily from monday to saturday(6.00/12.00/18.00) three times a backup of the transaction log now I receive follow model of the backed up transactionfiles : 1.11.2004 6.00 log =130MB ...more >>

Please help!!! We had a sql server 7 DB, with a char 8 field, in which some of the data was only 7 characters in length. Via a type 4 JDBC driver, we got back a NON space padded String. This server got upgraded to sql server 2000. Now, via the type 4 JDBC driver, we get a String padded fie...more >>

Can someone help me with this. I need to calculate the week ending date of the first week of the year based upon a year provided by the user. Is there a simpler way other than writing my own UDF?...more >>

We are negotiating with a vendor and we have a few questions: 1) From a licensing point of view, what is a database? Can we install multiple copies of SQLServer on one box? In that case, would each copy be a different database? 2) Within a single SQL Server installation, I can create multi...more >>

I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the production machine where it uses the hosting provider's SQL Server database on the back-end. Is there a way to export tables from one SQL Server databas...more >>

I cannot insert into my appointments table because the primary key and = identity column, appt_id, cannot be added. What do I have to change in = my SQL statement to add new records into this table? I'm using SQL = Server 2000 BE with Access Data Project FE. tbl_appointment -----------------...more >>

can you defrag system tables. They appear in my dbcc showcontig report. Some are worse than other but if it where a user table I would defrag it. However the reindex commands doesnt work on system tables.... Any ideas. Thanks Matt....more >>

I am trying to select a group of records based on a parameter value passed to the db from a web page. The value comes in as @Status and has a list of statusID's: (1,2,5,9) I've tried to use "Where table.status IN (Select * from @Status AS ValueList)" And also tried "Where table.status IN (@St...more >>

Dear All, I have written an update trigger that should write a message to an audit table When I try to update any field in the table I recieve the following error message - [ODBC Sql Server Driver] [Sql Server] Stirng or Binary data would be trunicated [ODBC Sql Server Driver] [Sql Ser...more >>

This one's kind of hard to explain, so I've opted to post a simplified version of our view that prompted me to ask this question: The question is re-asked after the view... create view MainView ( PrimaryKeyID, SubTotal1, SubTotal2, GrandTotal ) as select t.PrimaryKeyID, ...more >>