Unfortunately, sometimes you have to redo your work to get additional information. It happens all the tiome.

😎

unikhath (9/10/2008)

---

Hi,

I want to pull data from the database table which has been updated today. For ex: select firstname, lastname from users where updatedate <= GetDate().

This pulls all records from...

AND, I actually have to agree with Gail. If this is strictly for archiving data, the trigger is not the best method.

😎

Sorry to say this, but your explanation doesn't really jive with the code in your trigger from what I see.

As I said earlier, we need to see the DDL for...

Jobs are not interactive processes, but batch processes with no user interface.

😎

No. Neither Full or Differential backups truncate the transaction log. During these backups enough of the log is backed up to provide a consistant backup. Transaction Log...

Need to know more to answwer your question. Need the DDL (create statements) for the tables involved, sample data for the tables (in the form of INSERT statements that...

I can see why you have issues. This trigger is RBAR (a Modenism for Row By Agonizing Row). You really need to look at rewriting this trigger to...

So, I have to agree, what is wrong with the solution Steve suggested here

http://www.sqlservercentral.com/Forums/Topic566099-357-1.aspx

😎

Be sure to do a cost analysis. How many users will be accessing data from the server. Think potential numbers, not maximum concurrent users, as Microsoft does not...

Previous employer, we had to provide 7 x 24 hour support. Our system supported a world-wide business. We had 3 developers/support people on call, setup with a rotatine...

I'd suggest looking at the File System Task in SSIS to accomplish this task.

😎

Okay. With no tables or test data, here is something for you to try. Before running the code, comment the INSERT line so that all you are doing...

Okay, I can try and guess at the DDL for the tables, and I "make up" some data, but I have no idea if what I do will be close...

Sergiy (9/7/2008)

---

icocks (9/5/2008)

---

A further thing to bear in mind - if there's an Insert trigger on the table, then it will be fired in response to option 2, but not...