This works quite well:

SELECT YourNVarCharColumn

FROM YourTable

Where binary_checksum(YourNVarCharColumn) <> binary_checksum(Convert(varchar(n), YourNVarCharColumn))

This will give you the queries to run:

Select

'Select ''' + Table_Name...

Here's a function I wrote to strip HTML/XML/ASP/etc. tags out of data. It explains how to use it in your queries and exports: http://www.databasejournal.com/scripts/article.php/3494196

My first thought is:  are you sure the app is connected to the SQL 2005 machine? Perhaps it is using the old connection info or cached connection info and is...

The import/export wizard doesn't support DBase files, but Integration Services does. You can export to dbase files using the OLEDB provider for Jet 4.0 in SSIS.

Be aware that if you have Object Explorer open and focused on the database in question, that is a separate connection to the database. If you can find no other...

I have no idea what you are trying to say. There is no possible way that you looked at my split function that I wrote and is not publicly distributed.

Yes,...

As long as it is transactionally replicated, you will not be able to enter data at the subscriber. If, however, you want to have the ability to switch your application...

Then you shouldn't be using transactional replication. You should be using merge replication.

Cursor? Do you want your mouth washed out with soap?

All you need is: 

Select A.ID As

You don't need to use the ServerName if they are on the same server.

Be aware that using Select Into has some pitfalls. For example, if a column has no values...

Why would you need default values for the subscriber? When a record is replicated, the entire row will be replicated. Defaults will not come into play.

Use DBCC InputBuffer(@@SPID) to find out the string that called the procedure and then parse out the values. For example:

Create

Procedure dbo.

You should use the Information_Schema views instead of the system tables whenever you can. The SQL 2000 system tables have been deprecated in SQL 2005 and will not be...

I use this script I wrote:

Declare

@SpaceUsed Table ([name] sysname,

rows

int,

reserved...

If all else fails, open Task Manager, find the process for DTExec.exe, and kill the process. Take note whether the process is using a high amount of CPU or memory...