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

    Service using Winsock works on Workstation but not server

    Thanks Chip, I'll do some experimenting. There's lots of services running under the Local System account that talk TCP/IP without any special privleges. Automatic updates, Background intelligent transfer service, Computer Browser and many more. I think the restriction for the local system...
  2. BigMickeyD

    Service using Winsock works on Workstation but not server

    Thanks for the reply. That might be the cause. The service is running under the local system account on both the Workstation and the Server. The Workstation works fine. I have a catch 22. The service needs to interact with the desktop while it starts up (A "feature" of a 3rd party App)...
  3. BigMickeyD

    Service using Winsock works on Workstation but not server

    I have developed a "mailing address quality" application that runs as a Service and uses Winsock to communicate. Basically you send it a US address as a delimited string and it returns a USPS validated address as a delimited string. When the service is installed on my Windows 2000 workstation...
  4. BigMickeyD

    Insert Trigger

    I've made some progress I think, but I'm still having problems. MR_RequestID MR_Status MR_StartDoc MR_EndDoc 12345 R 0000012345 0000024792 12346 R 0000127342 0000127353 12347 R 0000162837 0001234567 ... 23456 R 0000162837...
  5. BigMickeyD

    Insert Trigger

    I'm new to writing triggers and could use some help. The table contains makeup requests, which have a requestID, a status (R - requested, P-Processed) and a starting and ending document number. MR_RequestID MR_Status MR_StartDoc MR_EndDoc 12345 P 0000012345 0000024792 12346...
  6. BigMickeyD

    import data but changing data along the way!!

    Data Transformation Services (DTS) is designed for doing just that. You would use two data sources and a VBScript or JavaScript transformation.
  7. BigMickeyD

    Setting up a DTS Job with SQL Authentication vs Windows

    IBETHA, From my limited experience, it depends on what your script is doing. If you need to access any files on the network, You need to use a domain account that has access to the network. BigMickeyD
  8. BigMickeyD

    Import Staging Table Fragmentation

    I'm using DTS to import a table from our AS400 to SQL server 7. The import staging table is truncated before the import starts. There are no indexes on the staging table nor a primary key. The import completes successfully but the staging table is highly fragmented. Of course adding a clustered...

Part and Inventory Search

Back
Top