Search results for query: *

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?

the job is queued to the printer then notifies of error sometimes get message no permission to computer, sometimes can see computer, although icon is there. I will check the event log sys admin does not want to give everyone admin priveleges thanks

I now have two printer that are not working. Anyone with Adminstator privleges can see and use the printers. Anyone else cannot. Being told it has nothing to do with permissions. But shouldn't it be? The driver is not faulty or would not work. They can be seen on network and can be used And the...

Finished a program that accesses a dbIV file thru ADO. Program works fine, with exception of one thing. The queries to the database are toooo slow. No problem with Sql Server tables or Visual FoxPro only DBaseIV. Anyone know why?

I have several programs that us the msmapi.ocx. I believe the ocx is somehow corrupted. I can run the programs in develeopment mode & can save them. If i try to make them an executables i get the error: The instruction at "0x005620d2" referenced memory at "0x21d714c". The...

I have just had the same problem. I found that when i was making a record selection in vb code, the was sytax error in my selection. If that doesn't work. Send copy of your code. might be able to find it.