I'll go also for wz700 suggestion. In fact that's what I use. Trigger script generation based on schema. And it does not matter...

FROM BOL:

------------------------------------------------------------

Remote Query Execution

SQL Server attempts to delegate as much of the evaluation of a distributed query to the SQL Command Provider as possible. An SQL query that accesses...

I am not going to argue that this can be done.

My point is that in order to build such a structure you are dangerously sacrifycing DATA INTEGRITY constraints and...

There are a lot of ways to do that but one of my favorites is this one

HTH

select case

         when iValue>1 and iValue<= 5 then 1

         when iValue>5 and iValue<= 10 then 2

         when iValue>10 and iValue<= 15 then 3  end as data

if @days <= 1...

Call DoCmd.TransferDatabase(acExport, "ODBC Database", _

            "ODBC;DSN=Volume_Control;UID=sa;PWD=xxxx!", _

            acTable, "tblFilename" & processPane.ListItems(ctr), "tblTemperooeste", False, False)

The above uses The Jet engine to retrieve remote data to override the behavior for a particular...

I also ran into an interesting thing in some of the Access queries:

With SQL 2000 any query testing a boolean field with a  -1  is comming up with an empty...

Hey no problem, it happens to me all the time

a Join

You're welcome

Well I NEVER set the default to master. I point them all to tempdb Instead

I think this is what you are after:

INSERT INTO dbo.FoldingTable (Orig_Value)

SELECT

 dbo.CountyParent.CaseNbr

FROM

 dbo.CountyParent 

 LEFT OUTER JOIN 

 (Select CaseNbr From dbo.CDS_Case WHERE CaseNbr is not null

  UNION

  Select CaseNbr...

but if you do have A Lot of jobs it is still no biggie. Go to EM -> Management -> SQL Sever Agent -> Jobs, Right click on the JOBS...

I believe that you will have to combine Frank's post with  some DATABASEPROPERTYEX( database , property ) and update the table that way. I agree with frank it should not...

Can you post the bit to Option map that you are using?

ex. auto create statistics = Bit 1, etc