The location plan is stored in MSDB. You can view it in Enterprise Manager>Management>Jobs.

-SQLBill

If you had installed a log viewing application (such as Lumigent's software), you could review the transaction log and see what changes were made.

-SQLBill

I agree with SQL Junkie....it sounds like you are connected to the database you are trying to detach. Connect to another database and then try to detach it......

USE Master

EXEC SP_DETACH_DB...

Another solution would be to create a 'fake id' column. Call it something like FakeAOId. Fill it with the actual AOIds and then update James2 to some other AOId that...

I had this same issue with a query, except a LOT more rows were involved.

Look at your query execution plan....that HASH MERGE is killing your time. First it gets...

Can you upgrade ServerB to SP4?

-SQLBill

They are two different databases. You wouldn't be able to restore MySQL into SQL Server. You should be able to link the databases and copy the information from MySQL...

One way.....Restore the database to the point in time prior to the problem. Then restore the database again to another location (instance or dbname), then figure out what is...

Restore should take under 1 hour....I would guesstimate that it would be about 40-45 minutes.

-SQLBill

Try this:

SELECT CodeCarreau

FROM DimPromotion

WHERE ISNUMERIC(CodeCarreau) = 0

Then try the same thing with NumeroContrat.

Anything that is returned will be values that can not be converted.

-SQLBill

Fill factor 0 means to fill the pages all the way.  You can never get 100% full, so that's why you are seeing a bit over 99% full.

-SQLBill

C,

You must not have SQL Server 2000.  DUMP is only included for backwards compatibility with earlier versions of SQL Server (6.5, 7).

-SQLBill

How long did the backup take?

-SQLBill

Are you running Query Analyzer from the same machine that has SQL Server?

If not, 1) has a new firewall been installed? or any changes to an existing firewall?

2) Are you...

You ran this:

DBCC DBREINDEX ('TABLE1','PK_TABLE1',70)

Note that last number '70'. That's percent full.

Now look at this:

Avg. Page Density (full).....................: 70.56%

Note that number '70.56%'. 

They are the same, each page 70% full.

What...