You don't tell us what exactly you are trying to do:  insert records from a table, update records base on values.  The solution is probably very similar, but it is...

There are so many things to this.  I would probably take a day to put it together. I have done similar things in different projects, but not all in the order you...

You are going to need to use an ado.command object with a parameter of type output.  You will need to pass in a connection string (or hard code it).  Do...

What this discusses is getting the data into a global variable from the output parameter of a stored procedure. http://www.sqldts.com/234.aspx

From there you can refer to the global variable in...

Before I dig in, let me make sure I understand your problem.  I think that this can be done.

How do you get this file?  Is there a folder that contains...

Try this:

http://www.sqldts.com/234.aspx

If it is the database password, you need a different element try:

Database Password=MyDbPassword;

rather than pwd=MyDbPassword

This will also work:

Select s.EventID, Datediff(s,s.EventDatetime,e.EventDatetime)as seconds, s.MachineID, s.EventType,

case when

(Select emt.EventType from

(select Max(em.EventID) MaxEventID from  #GPSEvents em

where em.EventID <= s.EventID

  and EventType in (4,5)

  and em.MachineID = s.MachineID)...

I'm not clear what the columns and rows represent.  I think that a list of rows that exemplify what you are wanting (with columns labeled) with the expected output would...

I think that I understand what you are trying to do.

You need an activex script that reads one record from the recordset and sets up other tasks based on that...

I don't believe that there will be any blocking, but I can't be sure.  I believe that SQL Server will get row level locks and will let you insert. I...

I found the test to be somewhat challenging.  I have listened to a lot about SQL 2005 and have occasionally used the tools.  But I'm still working primarily in SQL...

Someone please correct me if I am wrong, but after trying to do what you stated, I was told that the Access database has to be on to server in...

Also, make sure that there is no maximum file size for the log file.

I can't think of any way to do this other than brute force.  You need a list of computers on your network.  You need a user that is in each...