Yes indeed.

I took old database offline and users 'sa' and 'builtin\Administrator' default database is assign to one of the offline database. That's why I can't get back in anymore.

But problem...

Thanks.

Not because of that, I took old database offline and users 'sa' and 'builtin\Administrator' default database is assign to one of the offline database. That's why I can't get back...

Er.....

I am not fully understand what you said, you mean not to reindex or reorganise the index even fragmentation level is above 20%, are you sure?

According from the book online...

No. Nothing is running.

I will try that again tonight and see how it goes.

Thanks

Thanks J,

I have suggested my senior DBA to create a Archive table and transfer into it for years of data, then delete the records from the Main Table. Will see...

J (11/5/2008)

What kind of an organization has an Employee table with 30 million records in the first place ?

As for obtaining a list of which records were updated, you do...

Hi,

I can't becasue it run by job and that is part of DB Maintenance plan. I am not running under quary analyser.

Any other idea?

Hi,

Sorry, What do you mean by that?

Off hours. Actually 23:30.

This is Test Table so that no indexes.

I will going to do it on proper Table with indexes on when that Update process is okay.

It was 104MB now 59GB so far but still going.

Update thing is still running.

Drive Size is full.

anyway to reset the tempdb back to the normal size rather then restart the sql server?

Thanks.

Hi,

Code is fine but it fill up my tempdb.

I am getting 'Could not allocate new page for database TEMPDB' ....message and stop the process.

Any idea?

Thanks.

Hi Lowell and Karl,

Thank you very much. They reason I am loop through single rows is I want the output for the record which has been updated.

But that is...

Thanks Jerry,

That explains it.