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

    BCP right truncation error

    Problem solved.... We'll call that an undocumented feature of the app's export/import process. I suspect they expanded the field in the export file, but forgot to change the size in the schema creation script. Thank you George. Out of curiosity, is there a switch for the BCP command that...
  2. monkeylizard

    BCP right truncation error

    9.0 4 1 SQLCHAR 0 32 "\t" 2 SESSION_KEY SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 32 "\t" 3 HIT_KEY SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 512 "\t" 4 NAME...
  3. monkeylizard

    BCP right truncation error

    I have an export from a 3rd party application in a tab delimited format. The exported file is flat text, tab delimited, and was designed to be fairly generic for importing into a DB (SQL, DB2, Oracle, etc). One field in the export is text. According to the app's documentation, the destination...
  4. monkeylizard

    Need help with BCP syntax

    I could be wrong, but I thought that the BCP was executed using the login rights of whoever is logged on to the SQL Server. So you may have writes to the G: path, but if the same network path isn't mapped to G: on the server, it won't work. Monkeylizard Sometimes just a few hours of trial and...
  5. monkeylizard

    Add date to TEXT or NVARCHAR field

    Nevermind. The code shown in the last block works fine. It was a second variable that I dind't tell you guys about that I was stringing in that was NULL and that was clearing the whole @TEXT variable. Oops. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes...
  6. monkeylizard

    Add date to TEXT or NVARCHAR field

    I need to add some additional text to a text field. We'll call the field NOTES. Assume that NOTES on a record contains a value of 'This is the first note, added on 04/18/10 4:26:08 PM.' I need to make the field have a new value of: 'This is the first note, added on 04/18/10 4:26:08 PM. This...
  7. monkeylizard

    Conditional Header in Word

    I was wrong about the <<>> being find/replace. They are indeed "fields" in the word document. It looks like an IF on the fields may do the trick. Thanks, everyone. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.
  8. monkeylizard

    Conditional Header in Word

    Possibly. I'll look into it on Monday. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.
  9. monkeylizard

    Conditional Header in Word

    Thanks everyone. That gives me something to go on. At least now I know it's probably possible to do what the business owners want, it's just beyond our current internal skill-set. A consultant may be in order. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes...
  10. monkeylizard

    Conditional Header in Word

    Tag" may not be the right word for this. Basically the 3rd party app has a list of predefined words that I have to encase with the "<<" and the ">>". when it finds one of it's predefined words in that encapsulation, it replaces the whole "tag" with the value of the database field that it...
  11. monkeylizard

    Conditional Header in Word

    I have a document template that uses find/replace tags. A 3rd party application opens the template and saves a new instance of a document after doing a find/replace on the tags. For example, the address section of the letter may look like: <<CUSTOMERTITLE>> <<CUSTOMERNAME>>...
  12. monkeylizard

    Block by application or log by application name

    Crowley16, I must be mistaken on app roles. I thought the connecting app had to tell SQL which app role to activate for the connection. Is that incorrect? Thanks for the Program_Name() and suser_name() values. That's helpful. Is there also a way to collect the actual SQL statement being...
  13. monkeylizard

    Sum based on differences

    I had used Gavona's second idea, putting the overs in C and the unders in D. That actually works just fine. SkipVought's SUMPRODUCT formulas give me the same result and much more concisely without the need for columns C and D. Thank you everyone for your help. Monkeylizard Sometimes just...
  14. monkeylizard

    Sum based on differences

    erm...I noticed the obvious mathematical error.I know 10-8 is not 8. oops. But the questions still remain. Thanks. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.
  15. monkeylizard

    Sum based on differences

    I need to total the differences between two columns into Over/Under totals. I need to know how far over Column A is than B, when value in column A is > B, and vice versa. I'm not talking about the net difference, but more of an IF logic. Example: ColumnA ColumnB 10 5 10 8...
  16. monkeylizard

    Block by application or log by application name

    Thanks Crowley16. But I don't have access to the apps' source code, so I wouldn't be able to edit them to execute the sp_setapprole stored proc. I've checked with our internal auditors. They would be satisfied if I can log all activity (besides Select, if I can exclude that) performed by anyone...
  17. monkeylizard

    Block by application or log by application name

    Triggers are an option for the logging on key tables if that's the route I need to take. Too many tables to trigger all of them. Can a trigger be set to only fire if the command comes from a connection made by an app not in an authorized list? I wouldn't want to log every transaction, say on a...
  18. monkeylizard

    Block by application or log by application name

    SQL 2000, possibly moving to 2005 Mode 80 I have a set of purchased apps that use SQL security rather than Active Directory. Each user needs their own SQL account with full read/write/exec rights as the apps use combinations of stored procs and direct updating. Within the apps, users have...
  19. monkeylizard

    Thoughts on Backup Solutions?

    I've managed an ArcServ setup in the past and it's what my current company uses. It's like most others. All the hard work is in getting the initial setup right. After that it's just a matter of supplying fresh tapes. I've used it for MS SQL, but never for HP-UX or Exchange. It works reasonably...
  20. monkeylizard

    Email Encryption Solutions

    733g rapelcgvba :) Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

Part and Inventory Search

Back
Top