Search results for query: *

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

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

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

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

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

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

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

Robert, My data does have foreign keys

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

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

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

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

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

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.