Search results for query: *

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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.

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

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

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

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

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

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