Second this.

To print out varchar length over 8000, you have to write your own PRINT function. There is one on this site. You can search. (And Microsoft will develop one in...

You can join on:

ON LEFT(A.ZipCode, 5) = LEFT(B.ZipCode, 5)

(Performance may not good.)

SQL2008 can compress the trans log then ship to remote when mirroring, right?

Where is this "View Snapshot Agent Status"? I can't find in "Replication Monitor". :doze:

If you choose "replicate schema change" true, it will replicate when the snapshot agent starts next time.

Answer 2:

Yes, it is doable.

Every 10min? It may because the network or something refreshed...

I am not sure.

But, for your linked server issue, the "ANONYMOUS" means you used the 2-hop connection to the remote server,...

koolme_85 (1/5/2011)

---

i did but now its throwing the arithematic over flow error

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type datetime.

after i replaced...

In this case, you have no choice unless you stop the app explicitly. (Otherwise, the app will keep trying to connect the database.)

GSquared, I used your query and got 6 seconds on a 8GB SQL2008 SP2 machine. 🙂

dan-572483 (12/22/2010)

---

I'm building a maintance job to restore a backup file copied from another server and run DBCC on it.

The source folder has copies from multiple days on it, so...

That is for DELETE or UPDATE statement, not for the SELECT.

BTW, how could a NOLOCK hint to the target table on the DELETE or UPDATE statement? Make no sense to...

Unfortunately, you may have to manually run it.

Or, you can wrap it into your application, and use "SQLCMD.exe" ....

You can keep a "CREATE" script and run it when needed.

I guess so.

FYI, 4000 is SP2.