Derek Dongray (3/20/2009)

---

It looks like The Rant has run its course.

And from his description of his setup (sync software + 3 application tools + 5 databases), I don't think changing...

Show us what you are actually using now.

Are there any other triggers on the table?

Why do you want to do this? What are you hoping to accomplish?

OK, nothing apparent so far. I think that you will need to setup a profiler/trace collection on this SSIS connection and capture all of the SQL commands/procs/statements. Somewhere...

My office is in Claymont. One of my best friends grew up in Hockessin and still lives there.

OK, right off the bat: I see 3 dysnamic queries, but you...

The error is not about GOTO's it is about labels. It is probably malformed dynamic sql, but that is not...

Thanks, Gus. I came up with that fix on my own. Adam Machanic, Ward Pond and some others have a different solution that they use (don't have it...

Also, we will need to see the listing of the "usp_rtrh" stored procedure.

Greg J (3/20/2009)

---

select @query yields:

INSERT INTO a2db_rawhistory.dbo.tx_wb5asc ([WBKEY], [RECNO], [SEGMENTCOUNTER], [TUBINGINCHES], [TUBINGFRACTIONNUMERATOR], [TUBINGFRACTIONDENOMINATOR], [DEPTHSET], [PACKERSET], CurrentAsOf)

SELECT r.[WBKEY], r.[RECNO], r.[SEGMENTCOUNTER], r.[TUBINGINCHES], r.[TUBINGFRACTIONNUMERATOR], r.[TUBINGFRACTIONDENOMINATOR], r.[DEPTHSET], r.[PACKERSET], 'Mar 20...

The order of insertion has no deterministic relationship to the order that records are physically stored. The only functional order in SQL is that imposed by a Top-Level SELECT...

Just a point, AFAIK, tables and indexes can only be allocated to FileGroups, not mere Files within those FileGroups.

If you add a new file within an existing group, SqlServer should...

Like this:

select sys.table.name as [Table

Name] from sys.tables

(I have to admit, I have never tried, seen or even heard of this one before! :w00t: )

I always use your method #2, which we call "Wrapper" functions/procs, etc.

You can also just right an Agent Job that refreshes all of the views once a night or every couple of hours. Low-tech, but I used to do it...

OK. Well, good luck then.