Hi, I'm in need of detailed information on how data replication works on the sql server 2000. If someone knows about a book or articles that describes how data replication works with transactions, stored procedures and/or merging databases I would like to be pointed in the right direction. ...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 chip...more >>

Just started learning SQL recently. But one thing i'm still not clear on is about altering relationships between tables after they've been created. Instead of creating a foreign key when the table is first created - i create the table and then run a query to set the foreign key and relatio...more >>

Hello Reader Why I am not seeing the row values as per the index set on the table? It appears in random manner. I think it should appear ascending as per the index set for one of the Column in Ascending. Please guide. ***************************************** * This message was pos...more >>

Hi NG, I've got an ASP Script (useing Javascript) to which i send data to by POST. This data stored in variables will be transferred to SQL stored Procedure. As shown at bottom... welches eine Variable übergeben There is coming up an error... I don't know how to solve it, please help or giv...more >>

When I try using the Upsizing Wizard to upsize a database to SQL database, I am unable to login because I get an error message which says: "Login failed for user 'Jim Richards'. Reason: Not associated with a trusted SQL Server Connection." I am using 'Windows Authentication' and I am entering ...more >>

hi, How to search a word in the sqltable?.ie suppose the field name has data type nvarchar(200). From there i enter the persional address of that persion. now i want to know the information whoes are coming from particular city?. The city value can enter in the address field. how we can make sea...more >>

I am interested to hear if people think it would be a good idea to move the Master & TempDB to a different HD. Here is my DB Server's set up: 1. Processor: (1) AMD XP 2800 2. 1st HD (IDE 0) is the system & boot drive 3. (3) SCSI HD make up a hardware RAID level 0 (striped without parity)...more >>

Hello all. The installation instructions in "Microsoft SQL Server: System Administration" tell me to Create a New User Account in the 'Active Directory Users and Computers' application. But when I search Win XP Pro for this filename, it can't find it. I started AddPrograms and clicked on eve...more >>

I'm currently running SQL Server 6.5 and 7.0 together on the same machine (i.e. switchable using the program switcher). Does anyone know if i can install SQL Server 2000 to run alongside both of these? Thanks in anticipation. Rob...more >>

Here is my SQL string: "SELECT to_ordnum, to_orddate," _ & "(SELECT SUM((DDPROD.pr_stanmat * DDPROD.pr_prfact) * (DOBOM2.b2_quant * DDORD.or_quant)) FROM DDPROD INNER JOIN DOBOM2 ON DDPROD.pr_prodnum = DOBOM2.b2_prodnum INNER JOIN DDORD ON DOBOM2.b2_orid = DDORD.or_id INNER JOIN DDTORD ON DDO...more >>

I have recently installed MSDE on my computer. Now I need to get a copy of Enterprise Mgr or equivalent. Does anyone know if I can obtain this from somewhere without having to purchase anything from M$ ...more >>

I'm trying my hand at triggers and it doesn't seem to be working for me. I have a very simple database that consists of one table: Employees. I want to create a trigger that will limit the EMP_TITLE field to either Ms., Mr., or Mrs. I am using the following code: CREATE trigger triTitleCh...more >>

Hi, In the Web application I am working on, data is read from a SQL Server database. At any time, there are about 15 people browsing the web. The SQL Server database is updated with new information once every hour. The update takes a couple of minutes. The isolation level during the update ...more >>

Hi guys, I'm trying to compose a query that will select all columns from a table, but without any duplicates. E.g. table name is 'tblShipment' columns are: fldUnique(pk) | fldShipNo | fldDate | fldValue 001 | 123 | 02/02/02 | 2000 002 | 222 | 01/01/01 ...more >>

Need to do a crosstab report, that lists the week across the top, and in the left hand column the months; cf. example: WK1 WK2 WK3 WK4 WK5 JAN $ $ $ $ $ FEB MAR I know you need to use the T-SQL function datepart, but it d...more >>

Hi all, I have a file with an extension of .sdf. I "believe" it is a text file of some sort but I am uncertain. The source agency hasn't returned any of my calls so I'm wondering if anyone is familiar with this extension? I'd like to import the file into my database - when I use DTS and chos...more >>

Hi, I can not find any reference or support for the following issue from Microsoft or on Google: When I open a table either to return data or try to use the design tools or if I try to create a new database diagram, I get a new result pane, diagram pane etc... but no result and no functi...more >>

I'm having some problems to optimize my stored procedure (select statement with joins) What I'm trying to do is calculate total work. My situation: I have 3 tables I'm using -Input (char destA, char destB, int work)where I have all input data (moves from destA to destB) around 3000 rows...more >>

I have two tables... Table1 and table2 and I need to reconcile them with each other. Table1 has the fields Product number, invoice number, price, vat amount and total. Table2 has the same data but in a slightly different format... It has Product Number, invoice number, Price and type. Ty...more >>

Hi all, The command is as follows: BCP asdos+_reports..StageCONTACTINFO OUT C:\16E8.tmp -w -b10000 -t"|" -r\n -Sblrkec28791d\sqlserver -Uadmin -Padmin -eC:\ERRCONTACTINFO.txt Here, since the first argument(database name) has a special char '+' in it, the command gives a syntax error....more >>

HI all, In SQL Server, i have a function which will return a table. like create function fn_test (@t int) returns table as return (select * from table) now i want the function to retun the table based on some condition like below create function fn_test(@t int) returns table as if @t =...more >>

hello ! I am not able to install Mysql on my pc runnig XP ..the log file shows server is readyfor connection on port 3306. but still client not able to server . error comes can't connect localhaost to server on port 10061 winmysqladmin showing green indiacting server is running but server...more >>

Dear Group Just wondered how I can avoid the CHAR(32) to be inserted if @String1 is NULL? SET @String3 = ISNULL(@String1,'') + CHAR(32) + ISNULL(@String2,'') Thanks very much for your expertise and efforts! Best Regards, Martin...more >>

hi, I have a database that has Primary Key constraints on every table. Yet when I run the replication wizard and try to configure merge replication the wizard notifies me that it will create a rowguid on the tables even though they already have a primary key. anybody know how to avoid the rowgu...more >>

I must increase column (filed) size in existing datebase but without using Enterprise manager....(Becouse we use MSDE on our clients PCs) The Filed is part of primary and foreign key constraints.... And every constraint has diferent index number in each database... for example (PK_something_9e3...more >>

Hi all: I restored one backup database (7.9 GB mdf) on two diffrent servers. I shrunk them by clicking "Move pages to beginning of file before shrinking". After shrinking, one mdf file is 6.7 GB, and the other is 4.2GB. I shunk again and again: 1. the 6.7GB become 5.9GB, 5.2GB, 4.7GB and 4...more >>

I need to create a TempDB that that takes this table... BRAID RATEDEFID BRADATE RATECODE PRODNAME 614 14 12/1/2002 Rack Beach Tower Terrace 615 14 12/2/2002 Rack Beach Tower Terrace 616 14 12/3/2002 Rack Beach Tower T...more >>

Hi There, I am looking for information on how to import the txt or csv file to the multiple table in sql 2000. If you have any kind of inf. please let me know wheather we can do this and how. below is the detail information. I received txt file every day which contain the information from...more >>

I am trying to check a list (MyList) against another List (SupplierList). I want sum the Qty's of UniqueID on MyList and extract the sum of the same UniqueId's on SupplierList. BTW There are more than one instances of Unique Id on each list. The Script below is providing me with the correct a...more >>

Hi guys, I have a field in my DB called EventDate as a DateTime field, therefore it holds both the date and time together like this: '2004-10-14 08:42:57.000'. I need to add together all the times in this column for a particular date range (BETWEEN). Any suggestions will be great. Tha...more >>

Hello Faculties When doing recovery after loss of data files, one would like to start SQL Server in single user mode. Is this possible? Thanks in advance Debashish...more >>

Hello Faculties If a client is not upgraded with MDAC 2.6, is it still possible to connect to SQL Server 2000 from that client? Thanks in advance Debashish...more >>

Hi, I have 2 tables and each has a text column. When i compared the 2 columns with the LIKE operator i found something strange. create table test1( var1 text ) create table test2( var1 text ) insert into test1 values ( '-- [ CustomerType = 1 ]' ) insert into test2 values ( '-- [ Customer...more >>

I have written quite a complex query in Query Analyser, now need to know how to automate the running of the query to dump the results into a flat file at scheduled times. Am an experienced Unix user, where it would be quite simple but new to sql server, is there a relatively simple way to do thi...more >>

I've posted the following question once: I have a column [id] in a table [products] The first 1, 2 or 3 alphabetic characters of [id] gives the category of the [id] example: ms123 --> category MS f-2345 --> category F rs2-123454 --> category RS erv-2345 --> category ERV Can someone he...more >>

I have a backup of SQL Server 6.5 database, but can no longer locate my 6.5 server software. I would like to upgrade this backup to SQL Server 7 or 2000 ( i do have this software!) , does anyone know if this is posisble without the 6.5 software? If the answer is no, does anyone know where i co...more >>

hello ! > > > I am trying to intstall Mysql binary version with installor in Windows > XP machine . But it is not working . i have installed in the default > path ,in windows service componenet its showing server is running,since > it is mysqld-nt so name-piped servr is also running. > ...more >>

Hi there, I have a database on my test machine that will need to be installed on users machines. I would like to create the database with the given schema on the users machine and also with some suitable default values in the tables. I note that although I can script the schema so that ...more >>

Hello, This is a simple question, hopefully with a simple answer. I have an nvarchar column of length 255. In one of the rows I have the following sentance - 'See the brown ball bounce'. Is it possible to use a command to remove all of the spaces in that sentance, so that the sentance rea...more >>

Sorry for x-post. Using Access 2000, what is wrong with this syntax? INSERT INTO Activity ( IDType, ID, ProjectID, ComponentID, SubComponentID, ProcessDate ) VALUES ( 'Employee', SELECT EmployeeID FROM tbl1104Mess , 6, 28,341, #11/02/04# ) The desired result is to place 1 record into Acti...more >>

Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise manag...more >>

hello, I've a problem with a trigger : this trigger update a file with an index field but it's return an error : UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad parameters for information, this is my trigger : CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS ...more >>

Hi All, In SQL Server how can I get the descriptions of tables in a database? From MSDN help I could find a way to get the description of columns using the following extended property SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'Reports', 'column',...more >>

Hello folks, I usually use this way to store more procedures inside a single SP: CREATE PROCEDURE usp_MyProc (@usp_mode int) AS IF @usp_mode = 1 BEGIN END IF @usp_mode = 2 BEGIN END and so on... My question is about performance: I don't know deeply how SP execution r...more >>

Just testing out this posting thing... Thanks!! tnhengatu@cafes.net ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encr...more >>

Hi, This is driving me nuts, I have a table that stores notes regarding an operation in an IMAGE data type field in MS SQL Server 2000. I can read and write no problem using Access using the StrConv function and I can Update the field correctly in T-SQL using: DECLARE @ptrval varbinary(16...more >>

I have a field called "type" in my "school" table that can have three possibilities: Elementary Middle High In my result set, I always want Elementary to come first, Middle to come second, and High to come third. An alpha sort gets me this: Elementary High Middle Sure, I could crea...more >>

Hey guys, Here's my situation: I have a table called lets say 'Tree', as illustred bellow: Tree ==== TreeId (integer)(identity) not null L1(integer) L2(integer) L3(integer) .... L10(integer) The combination of the values of L1 thru L10 is called a "Path" , and L1 thru L10 values...more >>