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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ijrussell

  1. ijrussell

    Getting the current code for a connection

    Hi I'm trying to see what code is running for a specific connection. I can do this using the Profiler - for a specific SPID and filtering for just the StmtCompleted events. (using SQL 2005) However, I'd like to do this from Query Analyzer - and thought I could using: SELECT @lcSQL = Text...
  2. ijrussell

    OLE Objects - GetChunk problem

    I've been trying to use GetChunk() to transfer the contents of an OLE Object field back to the original file that was embedded. However, it's not working! I'm getting Word documents that won't open up in Word, because Word cannot recognise them. Is there anything I should be doing to get OLE...
  3. ijrussell

    Problem with RESTORE

    Hi I have received a SQL backup of some data from a client and am trying to restore it to my SQL Server. I am getting Error 3270 - Internal Consistency and 3013. I have the following files: stonav04NavisionData.bak (22GB) stonav04NavisionLog1.bak (344kb) stonav04NavisionLog2.bak (344kb)...
  4. ijrussell

    One Time Suppliers

    Hi desmcc You are right - it is BSEC. We got the data a few weeks ago after being advised about the BSEC table from another source. But thanks for the reply!!
  5. ijrussell

    Learning a bit of Abap (In the UK)

    Hi I work for an Audit Recovery group and as such need to get accounts payable data out of a number of accounts systems. One of those being SAP. Most of the time companies have enough IT Knowledge to extract the data. But sometimes they don't.... What is the best way of learning enough Abap...
  6. ijrussell

    One Time Suppliers

    Hi Can anybody point me in the direction of the table that stores the Names and Addresses of One Time Suppliers. Thanks
See more

Part and Inventory Search

Back
Top