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!

  • Congratulations strongm 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. williamkremer

    Cannot start Goldsync as service

    Symantec is a pain in the IIS.. In the Norton control panel there is a Personal Firewall tab and you can go in there and open a port for certain programs. In the Windows control panel, select Windows Firewall and there are settings in there too. You want to open a port and have GS configured to...
  2. williamkremer

    Cannot start Goldsync as service

    Does the creation of the transfer set also hang then fail? Also, you might want to check your firewall settings on the GoldSync server and make sure that an opening exists (exceptions tab, change scope and open a port) to allow communication to occur. You're right too that you have plenty of...
  3. williamkremer

    Cannot start Goldsync as service

    Wizard -- you get a star for that gem of info above. and Connie, it sounds like your disk really IS full. Creating a transfer set can use a lot of resources. And, wow, you're using GoldMine CE on dBase. Have you, like, stomped on your manager's foot yet, and said something like, Oops sorry, but...
  4. williamkremer

    Setting up a backup Goldmine server

    The one that is using sa for the default login -- Change that. Create a new login in SQL Server for both databases. Create a master user in GM and set the default database to your production database with the same login info. When you configure ODBC settings (system DSN) use the SQL Server...
  5. williamkremer

    move custom tabs

    Wellllll..... You can, sorta. The fields tab is the place where custom screens appear -- like duplicates of the ones all the way on the right if you chose to give the the tab a "tab Name" in the custom screen properties dialog. If no tab name, (only a Screen name) no screen appears in that group...
  6. williamkremer

    Contact in Conthist

    They are linked like this SELECT c1.contact as Main, cs.Contact Subs from contact1 c1 join contsupp cs on (c1.accountno = cs.accountno) where cs.rectype = 'C' order by c1.contact "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  7. williamkremer

    Removing Bad Records from Goldmine 5.5

    Are you using SQL or dBase? If you have it on SQL you can look first at your duplicates like this: select count(*) as HowMany, Company, SomeSecondField from contact1 group by Company, SomeSecondField having count(*) > 1 order by Company, SomeSecondField "You cannot hold a torch to another...
  8. williamkremer

    Attach an email to a contact

    Select cs.contsupref as Email, c1.contact as name from contsupp cs join contact1 c1 on (c1.accountno = cs.accountno) where cs.contsupref = 'email@email.com' "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  9. williamkremer

    Permissions to allow a user to add fields

    I don't know about you guys, but I think letting users add/modify user-def fields is a problem waiting to happen. It's bad enough when users start adding f2 values with reckless abandon, but adding the fields... Too many potential problems. What about things like custom views associated with...
  10. williamkremer

    DatabaseID in a trace

    Bingo! Thank you very much! "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  11. williamkremer

    DatabaseID in a trace

    I'm running a trace on a server to monitor which databases on the server are being used currently. In my trace columns I have DatabaseName and DatabaseID. Wouldn't you know, the databasename column remains empty throughout but databaseID column is populated by numbers (8, 2, 15, etc) When I run...
  12. williamkremer

    Who knows the answer fro this select statement

    Coalesce? Works like Case? Geez..... And why not use 'where link1 is not null and link2 is not null and link3 is not null' ? "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  13. williamkremer

    Covert Decimal to Int

    And you jbenson! "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  14. williamkremer

    Covert Decimal to Int

    Denis, wouldn't that just truncate off the 2 digits to the right of the decimal? Or will it shift the decimal? And, what will happen to 12.34 if it is cast as int? This: 1234 or this: 12 You are a great teacher, and george and vongrunt and sqlsister, SQLbill and many others. You are...
  15. williamkremer

    Delete duplicate fields in a table

    If your table is not too large, you may want to view the duplicate entries first before deleting: select count(*) as Dupes, FieldWithDupes, OneOtherField from My_table group by FieldWithDupes, OneOtherField having count(*) > 1 order by FieldWithDupes, OneOtherField "You cannot hold a torch...
  16. williamkremer

    Server process ID's

    Will do - Thanks Denis "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill
  17. williamkremer

    Server process ID's

    We have a CRM that connects to SQL server and has been administered haphazardly in the past. There are almost 50 SPID's and it's not possible to tell who is the user in most cases (the owner is Sess and Lock type = DB, Mode = S and Status = Grant) They mostly have the same "last TSQL Batch...
  18. williamkremer

    Remember this trigger?

    Here is what I want to happen: the instant that a record is created in Conthist table with a resultcode = 'CT' a timestamp is also created in that record. I want that timestamp to then be inserted into table Contact2 where conthist.accountno = contact2.accountno in the U_Time column. Hope this...
  19. williamkremer

    Remember this trigger?

    Ok, I'm back. So, are you saying that my Select statement goes away? Also, how does sql server know where the data is coming from? (it is supposed to come out of conthist and be updated into contact1) The longer this goes on the more confused I get. I thought it would be easy: when conthist has...
  20. williamkremer

    How do I update the last jobstep of a job?

    Oh, I see you already know sp_update_jobstep. Didn't read the whole thing! :-p "You cannot hold a torch to another man's path without brightening your own" Best regards, Bill

Part and Inventory Search

Back
Top