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

I need the DDL...

bitbucket (9/8/2008)

---

Think when Lynn says:

she means what...

Still, I think this could be done without a cursor. From the logic in the code provided, I can't see any reason that requires a cursor. A set-based...

Could you provide the DDL for the tables (CREATE TABLE statements, if it is hugh just the key fields used in the query plus any indexed fields), some sample data...