Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fousek

    Searching thru millions of rows for records that "sound like"...

    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...
  2. fousek

    Searching thru millions of rows for records that "sound like"...

    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...
  3. fousek

    What does the CPU column in the sysprocesses table represent?

    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...
  4. fousek

    What does the CPU column in the sysprocesses table represent?

    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
  5. fousek

    select @@servername returns null

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

    select @@servername returns null

    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
  7. fousek

    Error updating jobs in SQLServer2000

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

    SIMPLE TRIGGER QUESTION

    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
  9. fousek

    Error updating jobs in SQLServer2000

    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...
  10. fousek

    Problem installing MS SQL Server 7.0 on Windows 2000

    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.
  11. fousek

    Problem installing MS SQL Server 7.0 on Windows 2000

    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...
  12. fousek

    Problem installing MS SQL Server 7.0 on Windows 2000

    Tom, I used the NT administrator account. Palmer F
  13. fousek

    Problem installing MS SQL Server 7.0 on Windows 2000

    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}...
  14. fousek

    Any ideas how to traverse a simple tree in SQL?

    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
  15. fousek

    Update field on joined databases

    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...
  16. fousek

    Any ideas how to traverse a simple tree in SQL?

    Hello all! I have a table defined as: create table OrgTree (parent int, child int) OrgTree has the following data: 1,2 1,3 2,4 2,5 3,6 4,7 4,8 8,9 Is there a SQL stmt that will return, given a particlar parent, all of the children (and children's children, etc.) of that parent? So, parent...

Part and Inventory Search

Back
Top