I could login to the SQLServerA from MachineB without any hindrance but when I try to connect to SQLServerA locally (From MachineA) then this throws eventid 18456. Can anyone discuss...

select distinct * from dupnames dup1

inner join dupnames dup2

on dup1.name = dup2.name

where dup1.id <> dup2. id

Try '"Example data to be imported"'

I think this was an issue with sql2k5 SP1. After that this error is no more. Could you tell your @@version Abhijeet?

It worked, Sturner. Thanks.

So the logic is that we need to use 'local' when we want the @@servername not to return the NULL value.

Paul,

Can't we make the threshold change using GUI? Do I need to run sp_change_log_shipping_primary_database and sp_change_log_shipping_secondary_database?

Can anyone tell me how to change this setting please

Yes, clustered index can be added on another filegroup. But why this is not recommended to have the clustered index on another filegroup.

-Lk

True Gail. But what does allow_updates do?

My bad. Thanks Paul. /PAE SWITCH can be used with AMD as well.

I thing Service Pack = Many Hotfixes. Is there any good article that describes as how to apply the service pack or hotfixes?

What is LINQ KrayKnot?

If you are not using intel then you can't use /PAE switch for memory extension.

-Lk

I am in hi-safety.

Ok got it. in case this is sync (High availability) the there is no data loss and we can just issue ALTER DATABASE SET PARTNER FAILOVER.

But there is ofcourse...