Why not try something like

IF @@SERVERNAME = 'Me'

  BEGIN

    SELECT * FROM DataBase_A..Table1

  END

ELSE

  BEGIN

    SELECT * FROM DataBase_B..Table1

  END

Can you post your SEARCH statement?

NULL is NOT a datatype but rather a STATE of DATA i.e. NOTHING...  In your above VIEW ALL EmpName will = NULL AND no matter...

There is no performance difference HOWEVER, there are differences for how many concurrent connections there are.  PER SEAT = n Connections (basically HIGH LEVEL concept), PER PROCESSOR = n CPUs...

the specific scenario that MS referred to was contention in the LDF when a lot of work was being done in TEMPDB again SPECIFIC pattern ONLY.  The creation of multiple...

I don't believe you will be able to get COLUMNAR data.  All you will get is something like UNABLE TO INSERT NULL...  unless you use custom error messages.

However, an easy...

What is dbo.wrkAccountingDocument  a VIEW? TABLE? is there an INDEX on ad.AccountingDocumentNbr ?

The NON-CLUSTERED index also may be causing problems because the 1st column is the same 1st column as the...

We had a perf. problem several months ago and sent logs/data to MS.  We asked about multi. T-log files and were told that there is a very specific scenario that...

I think the problem may the fact that the linked server is NOT using the indexes that you are anticipating.  Is it possible to 1st build a VIEW or a...

Another item to think about is.. IF you are strictly looking at Column2 for the WHERE statement it SHOULD be indexed.  If you add an index to it you will...

Someone else has a DB connection open i.e. Query Analyzer or an instance of Enterprise Manager.  Make sure there are no connections open to that database and try again

I would initially state NO however, IF the SAME account is on BOTH machines THEN you should be able to (as long as the passwords are the same)...

i.e. PC1\UserA and...

Why cant you call the SELECT TOP 1 1x time write the output into a VARIABLE and use that?

The wording is misleading.  You are correct in your assumption about TABLE SCAN however, due to CLUSTERED INDEX the code is performing a TABLE SCAN on the INDEX.  If you...

If you need to pick and choose which databases need updating create a table that contains DB names and LOOP through that....

What you could do is research on this site the use of msforeachDB and use that to loop.  You should be able to find decent SAMPLEs using the search feature...