Recent content by opo

It worked perfectly! Thank you, thank you thank you!

The updates come in a flat file. I use a DTS to put them in a temp table on the same database. I then use another DTS to try to insert them into the primary table. When the DTS fails, because of the violation of the primary key, the VB program tries to inserts the records one at a time from the...

I have a table that contains over 6,000,000 records. It has a primary index on 4 char columns. I receieve duplicate or updated information regularly, so i need to either delete the existing record and insert the new, or update the old with new info. I tried doing this in vb program, but the...

I have a table with more than a million records. and it is indexed. I can select * from... the table based on a indexed-field with no problem, but any deletes or updates timeout. Any suggestions?

I need to make an .ocx that uses IDispatch to interface with another application. Trying to find a straight-forward and complete example of how to do this, if anyone has or knows of one. Thanks

Played around with DTS packages for two days, I now understand how to do it. Thanks!

Just looked at the linked servers tab in Enterprise Manager. I can see the sys tables but not the tables I want the triggers to affect. Is this a reason why they don't work?

The file is fixed length. I did not have a format file. The errors are in the bulk statment when doned in the Enterpriser Manager. The VB program works, just slowly. And I will send another post regarding the triggers.

Sorry, it took awhile to respond, had to research what you were talking about with a format file. I am a VB programmer and i have to add records to an exisitng Sql table from a text file. There could be anywhere from 40,000 to 100,000 records in each txt file. Currently i do this with an insert...

I'm trying to bulk insert a textfile into a sql server table. The message I get is unexpected end-of-file error Should there not be one at the end of a text file. Please help!!

I have just made my first simple trigger! all i need is to go between servers the code is CREATE TRIGGER pop3 ON dbo.test For Update As If Update (one) Begin Update server1.dbname.dbo.test2 Set server1.dbname.dbo.test2.two = test.one from test inner join server1.dbname.dbo.test2 on...

We are in the process of sharing a server with another company. We are thinking of using sql replication to send the data back and forth from ours to the central server then to theirs. There are concerns if their data is incorrect and gets copied to our tables. What is the best way to 'scrub'...

Log Question? Not sure if this is. I am a VB programmer and I need to know when our DBMA has change the structure of a table,deleted some information, or made ran some update queries. Is there a log that will show what he has done and when or is there a way to notifiy me when it occurs?

Check Microsoft Site, that reference you gave no longer exists :(

Hi Checked the Event Log, message: 'Document failed to print due to GDI/Driver error in rendering' Window Graphic Driver Interface ? If so how do i fix?