If you already have indexes and are looking to drop and recreate those indexes ,then from a performance point of view, the best way to do it is to use...

You can also check why the log is not being reused using the following query.

Select log_reuse_wait_desc from sys.databases where name = 'DBNAME'

You need to have a downtime. In Sql server 2005 one cannot add the dependency without taking the sql server service offline.

This has nothing to do with system memory.

See the below information

" The error is a .NET Out of Memory exception pointing to the Management Studio running out of available memory....

Create Login requires Server level permissions (system admin or security admin). So be careful in granting those permissions.

It might be a permission issue.

When you run the stored procedure through the Query analyzer, You are running it under your account.

You might be having privileges to create a login.

When...

I really wonder ,how you came to a conclusion that output you get by enabling trace flag 1222 is useless.

If you would like to learn deadlock troubleshooting and interpreting...

Hi Grant,

We do have a tape backup that occurs every night and we move the tape to an off site location.

Thanks

Thank You Jeffrey for your valuable suggestion.

Hi

My upgrade went fine without any Hiccups.

thanks

Thanks for the response.

Can it be Done without the Resync?

Thank You Gail ,for the valuable information.

You can change the database owner to SA and see if that helps.

DBCC CheckDB will not update any statistics.

If You are rebuilding the indexes ,then You need not update the statistics.

We do have a nightly process that copies the backups onto the tape. But what if i want point in time data... It would not be possible taking...