Another way is to change the temp table. Add "COLLATE database_default" to string columns of all temp tables or table variables. E.g.

CREATE #t TABLE (c1 nvarchar(10) COLLATE database_default NOT...

The reason is that a NULL value is in the subquery. Since NULL is a unknown value, all values from the main query are eliminated. Change to this:

SELECT

The following two white papers about database mirroing may be helpful for you to make the decision.

Database Mirroring Best Practices and Performance Considerations:

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

Database Mirroring in SQL Server 2005:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

    EXEC sp_xml_preparedocument @Doc OUTPUT, @UpdBal creates xml handle for the current session only. Xml handle is session isolated. When SQL executes the dynamic query, it creates a new session...

It's a good practice always to check XACT_STATE() becuase you don't need to care it's in a commitable tran or not, or even its in a tran at all when...

You are absolutely right.

I think the course missed some details.

Sounds like a bug to me. If you run it in 2005, any statements after the "exec test" is not executed, which means sql server termininates the whole batch. Since...

According to MS, "ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and...

In most cases, connection pool is very helpful to your app's performance, especally when you have lots of clients. So it's not wise to disable it.

If you really do not...

It's not the transaction sleeping. From client app point of view, the connection is terminiated. But ado and sql server use connection pool technology. The real connection is still there...

The running account of SQL server service could not access the stand by file SecondaryDB_20060915071828.tuf in the folder \\secServer\SharedFolderSecondary\. When the second db is in stand by mode, this...

The second DB of a log shipping either in standby mode or recovering mode.

Stand by: you can use the database and it's read only. The state of the DB will...

The problem is not the job failed. It's your database in a state that cannot apply the transaction log. The error message is very clear.

You can run

SELECT * FROM...

I understand what you mean now. The encoding of unicode string in sql server storage is UCS2 or utf-16, not utf-8. I don't think you can change it.

What I said...

SQL server definitely support various unicode encoding including utf-8, but you need to use nvarchar instead of varchar.

nvarchar is unicode string data type.