The way we move objects is:

#1  Create SQL scripts for ALL objects that are being promoted through the system

#1.  Why is he doing this?  Moving from DEV to TEST?

#2.  Why does a DEVELOPER have this authorization?

If I understand this correctly WHERE fldModelID IN (1, 2, 3) will return items you don't want because they can have 1 but not 3.

What you need to do is...

Trigger would probably NOT be the way to go.

How 'bout DELETE FROM dbo.TableX WHERE SomeDateTime <= DATEADD(MONTH, -6, GETDATE()) put that in a job and run it???

Paul,

I had nothing in mind other than... It is generally unrealistic to have changes made during the day and have immediate gratification for your example. IF you make...

#1.  When is your maintenance window?

#2.  Why can't you schedule all of these changes to occur in that window?

I think that eventually they will have to open that up for searching (QOD answers).  The problem that I had yesterday was to find items that didn't fall in 0-Z...

I don't think the problem is with your server rather your PC itself.  I think you are overrunning your own memory buffer..

I am sure that was the answer for the question.  Unfortunately, I can't figure out how to see the answers from the QOD page so off I went to the...

You may not have enough memory on your PC to do this.

What happens when you try and do this via QA ?

#1.  Yes but all the information in that DB will be GONE

#2.  Research Backup/Restore DB in BOL (Books on-line)

The short answer is:  It depends.

• How many rows are going to be in table?
• How much manipulation is going to take place?

@TABLE will write to DISK once it is big enough

#TABLE...

Russell,

I could have looked it up as well but, I was trying to prove a point about follow-through ....

hmm..   If the person posting this postion hasn't responded to my question I wonder how well they would do with placing me.....

Have you tried doing an INSERT INTO #Table with the same schema as your openrecordset?

INSERT INTO #Table (field1, field2, field3)

SELECT a.field1, field2, field3

FROM OPENROWSET('SQLOLEDB','myserver';'sa';'MyPass',

   'SELECT field1, field2, field3 FROM pubs.dbo.authors ORDER BY...