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

    upgrading from 2000 to 2003

    I would like any advice on upgrading sql server 2000 to sql server 2003. Specifically, I would like to know if there are any problems with vb6 code that are affected by the upgrade. I also use stored procedures. Are they affected by the upgrade? If so how? Did your upgrade go smoothly, or...
  2. jisaacson

    cannot generate sspi context

    I have been using VPN successfully for several years to connect to my office server. About a month ago I started getting the message that I could not establish a connection to my host server because the system could not generate the sspi context. The problem is that I have no trouble getting...
  3. jisaacson

    help needed on cloning a listview

    This works. I had option strict on but reset every one I could find to option strick off and still got the same message.
  4. jisaacson

    help needed on cloning a listview

    There was a question back in Dec 05 about cloning a listview. This was thread thread796-1169523. The code was as follows: Dim itm As ListViewItem For Each itm In ListView1.SelectedItems Dim newitm As ListViewItem = itm.Clone ListView2.Items.Add(newitm)...
  5. jisaacson

    SQL statement causes itself to be blocked

    Thanks for the info. I appreciate the quick response No wonder I never saw this before. However, is there something I can do with the sql statement to avoid this? It does cause problems with multiple users
  6. jisaacson

    SQL statement causes itself to be blocked

    When I run the sql statement shown below,and then look at the current activity - locks/process id in enterprise manager, I find that the statement blocks itself. INSERT INTO TempRptisaacson (YB_MKTCode, YB_ADCode, YB_STCode, YB_MediaType, YB_ADName, YB_AGCode, YB_AGName, YB_INCode...
  7. jisaacson

    Deleting a large number of records +2gigs

    Some of the indexes are not used that often, but when a look-up needs to be done, it makes a big difference to the user with the index. However, I probably should review the indexes I am using to see if some of them can be removed. I'm glad that you reminded me that I can improve performance...
  8. jisaacson

    Deleting a large number of records +2gigs

    Robert, My data does have foreign keys
  9. jisaacson

    Deleting a large number of records +2gigs

    No, I don't want to delete all records from the table, just selected ones. This means that I will be deleting by row.
  10. jisaacson

    Deleting a large number of records +2gigs

    I have a database of over 20gigs. One of the tables has over 19 million records, as we have not deleted anything since we created the database. I now want to delete old records. I am concerned with the time it takes to do this. Whenever I have deleted records in the past from other tables...
  11. jisaacson

    Installing visual studio.net

    I am having a problem installing visualstudio.net. When I run setup it tells me I need to run Windows Component Update. I then run the update and it wants to install VPN Client. I already have VPN installed. How do I get around this. I tried letting it install the VPN client, but it...
  12. jisaacson

    How can I modify chart data from visual basic

    Skip, Your suggestion did get me started. It gave me the clue I needed to access all of the text, tables, charts, etc in an existing PowerPoint slide(s). Thanks for your help Joel
  13. jisaacson

    How can I modify chart data from visual basic

    Skip, These are Microsoft Graphs embedded in the slide. The presentation was drafted manually, using dummy data to set up the charts and text in the file. No links from Excel workbooks were used. Joel
  14. jisaacson

    How can I modify chart data from visual basic

    I have a PowerPoint slide with 4 charts - 3 bar and 1 pie. I would like to be able to dynamically modify the data in each of the charts. I want to do this from a visual basic program. How do I point to the tables that contain the data for the charts? Thanks for any help you can give me.

Part and Inventory Search

Back
Top