Recent content by fousek

Terry - thanks for your response. Yes, I looked at English Query and concluded that it does not handle a "sounds like" situation. Are you familiar enough with the product to know that it does? My conclusion was based on about an hour of research, so I could be wrong! If it is smart...

Hello all. I have a SQL Server 2000 db that has a table with ~10 million rows with a column LastName. Is there a way to perform a search on that column for a last name that "sounds like" my search criteria? For example, if I search for the last name 'Meyers', I would like for it to...

TB - Thanks for your response. Yes, I'm sure I have a user process. Actually, if I open a session in Query Analyzer and run "select * from sysprocesses where spid = my_spid" (over and over), my CPU value changes unpredictably. The kpid changes, so I think the CPU column is showing...

I thought the CPU was measured in milliseconds in that table. But I see numbers in that column like 4788413 for user processes. What's the deal here? Thanks in advance! APF

My apologies. I posted this on the wrong forum and can't figure out how to delete it.

On all of my 2000 SQL Servers, the command select @@servername returns null instead of the local server name. I did an sp_addserver my_server_name, local Was there anything else I needed to do? Thanks in advance! APF

TLB - A belated thank you for the good information. I tried your solution today and it worked like a charm! APF

SeanB - You can't have a trigger fire on individual fields, but inside the trigger you can use an "if update", like so: if update(Driver) Begin do some processing end APF

I just finished upgrading from 7.0 to 2000. (Actually I created a new SQLServer on a new box, installed 2000, a copied my databases and jobs to the new box.) Almost everything is fine, however, I can't update any of the jobs that I have defined on the new server! I get this error: Error...

Yes, plenty of room in the registry. I tried to get it to connect using TCP/IP during the installation. I got a different error, but it still didn't work.

Tom! Thanks for your help. I don't think it is timing out. This is a new Win2000 Server and other processing is minimal. I have run the install on a spare Win2000 Server and that one worked fine. I really don't have a clue why this one is giving me trouble - and I don't know where to look...

Tom, I used the NT administrator account. Palmer F

Folks! I am trying to install MS SQL Server 7.0 on Windows 2000. During the installation, the service is started, but it cannot connect to the server. The only log file left after the failure is cnfgsvr.out. It contains this error (among others): driver={sql server}...

Mike! This is MS SQL Server. Actually I have coded a pretty hideous looking piece of dynamic code that uses self-joins and unions that works, but only if I know the numbers of levels my tree has. Thanks for your input, though! Palmer

Jim To answer your original question, you need: UPDATE db1.dbo.table SET db1.dbo.table.field3 = db2.dbo.table.field3 FROM db1.dbo.table, db2.dbo.table WHERE db1.dbo.table.field1 = db2.dbo.table.field1 By the way, when the owner is "dbo", the "dbo" is optional. So, you...