Not enough information. It would help to see the code, the DDL for the tables including defined indexes, and the execution plans for the queries.

You can use the UI to create the table create scripts for you. Right click on the table and go from there. Remember, we need to be able...

You would use a scheduled job to perform the archive process. Start by looking up SQL Server Agent in Books Online.

And, yes, if the trigger fails, the insert that triggered the insert will also fail.

Give this a try, but I would seriously look at Service Broker.

DECLARE @ani varchar(27)

DECLARE @fate varchar(3)

DECLARE @callid varchar(32)

DECLARE @BCPCmd varchar(2000)

SET @ani = (SELECT ani FROM inserted)

SET @fate = (SELECT...

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