Yes you are right .A bit strange (to us that why the index that is created second is used)..but there might be some logic we dont know .

main thing is...

can you share the command you are using and other relevant information please.

If you are not abel to connect remotely you must be getting the errors .

an you share it please .

make sure you have SQL Browser enabled and TCP/IP , named...

You are correct Paul ..its indeed WAL (So silly of me).

In the haste we miss the reality 🙂

Regards

1) for how long will you do that ..its going to be a pain .You can create a SP using cursors to do that .Remember you cant do kill @spid_name...

I have never tried this on 2005 from 2008 .

Unfortunately i cannot try it now but let me see if that is possible ...

Yes she does say that its possible...

As i said my friend : this is only supported in SQL Server 2008.

All your instances should be on SQL server 2008 .

Regards

create a new database and import the tables form the old database .

Over here you know the HOBT id , object id and index name .but you do not know the rowid or page id etc .So you know that update is...

Yes it does(I tested it way back) .This is because everyhing is logged in the log file first (as per copy on write principle) and the database is in full...

For 2000

----------

1) create this SP attached in all the databases you want

2) execute this :sp_msforeachdb "exec ?.dbo.Rebuild_reorg_index"

so there is no need to find and then rebuild/reorg .this SP...

This is possible in SQL Server 2008 .

We call it Central Management Server.All you need to do is to choose a SQL Server 2008 server and register other servers to...

Blocking is the way to synchronizing data access .

Just imagine what will happen if someone pulls the chair on which you are sitting .

As pradeep said ,killing is not going...

Well if you restore the full backup and then the t-log with no recovery the database is suppose to show you the status of 'restoring' 🙂

if you are configuring Mirroring...

add this : select rtrim(cast(GETDATE() as varchar(12)))