Your going to have to write dynamic sql in your trigger to get this to work the way you are going at the moment.

I think I'd look closer at the requirements. Is there a need to have x amount on-line for ready access, say previous month plus current for instance. If...

If I may, I'd like to make a suggestion. Don't do it this way. If for some reason the call to xp_cmdshell fails, your insert into the table...

You will find it here: msdb.dbo.sysjobs

If you use the job_id, if they drop and recreate your job, the procedure will also break.

Best thing to do is document your job and...

Looks like you told him what he could do, not what he wants. Looks like he needs the proverbial 2 x 4 to understand that he can't trace the...

antonio.collins (12/15/2008)

---

Appropriate datatypes depends entirely upon your application and data usage.

From your column name list, the only obvious choice is

ExecutioninstanceGUID should be a uniqueidentifier.

Executionstarttime could be either...

If the purpose of this thread was to "blow off steam", I think it has (and still IS) serving the purpose. What better place to swinging through the trees...

Garadin (12/15/2008)

---

That's really not enough information, but if I had to guess based on the field names:

Username ...

What quotes? Your sample above doesn't have any.

Leave it to geeks....

I just want to be sure what you are asking. You have two indexes on this one column:

One index is a primary...

Have you tried setting up as a 1 column import? You would then split the data from there.

h.schlais (12/15/2008)

---

Hi Lynn, I get the following error:

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.sp_start_job'. The stored procedure will still be...

Are you looking for somethig like this?

select

OrderID,

OrderDate,

ShippedDate,

RequiredDate,

ShippingWindowDays,

...

I don't know if this helps, but you can integrate Reporting Services with SharePoint. You would then use Reporting Services Reports to provide the integration you are looking to...