Why not using a database link and use the "excist" in the where clause??

SQL basics !!

GKramer

mak,

1) Check your torn page detection and your page chaining ( probably incorrect pointers )

2) problems related to high end subsystems http://support.microsoft.com/default.aspx?scid=kb;EN-US;810885

3) info on RollBack text operations...

ikorenbl,

Try the next setup;

select <re-arrange your columns>

into #temp_table

from original_table

drop original_table

select *

into original_table_remake

from #temp_table

Recreate PK's ,Indexes and others stuff

Just a thought on this...

GKramer

The Netherlands

There are a few undocumented stored procedures on this but I have to look it up,

Ill keep in touch.

GKramer

The Netherlands

Richard,

This application is designed to collect data at remote locations...

This sounds like a transactional replication ( pull mechanism )

send the data to an enterprise server for management....

Why not build view on it...

If you have access to BOL (2004) please look for the item FROM and look for the chapter TABLE HINT There you can find your answer ( I hope )

GKramer

The...

Richard,

I do not know the exact reason you have to copy your data to a client but have you ever thought about replication or logshipping???

Guus

Hi,

This is an operating system, driver, or hardware problem which indicates a data integrity-related error. Your pages or IAMs are not in chaning order....

For more details see http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

GKramer

The Netherlands.

Doing it the oldfashioned SCRIPTING way...............

First transfer the DTS packages to the new location ( you can use DTSbackup2000 for doing this...its freeware and highly recomandable ) and run the...

I've been facinated by your question ( I've never met this problem but like to know the answer anyway) so I start diging;

http://support.microsoft.com/kb/837938

It also indicates a corrupted clustered index using the standard...

Richard,

I built an application around an MSDE database and am looking fo a way to install the client tools (management console, etc...) without having to prompt the user for anything...

See BOL (2004):

What do you want to do exactely???

Gkramer

The Netherlands

***************************************

DBCC CHECKCONSTRAINTS

Checks the integrity of a specified constraint or all constraints on a specified table.

Syntax

DBCC CHECKCONSTRAINTS

    [(...

I agree with Colin....

Not only the cashes are empied....

but think about the downtime (if this is production server)

think about dependencies.

think about extra failures when not comming up properly (its still...

I'm one of 3 DBA's here ( in a total group of 40 operational guys (networking , exchange, hardware , OS related etc etc ( we are doing the whole of...

Remi,

But then again why would DBAS exists if everything was so simple as point and click :-).

To keep a certain group of "thinkers" off the street preventing a riot...