Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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