In my experience blocking is almost always due to poor application code rather than anything you can do much about on SQL Server - that said if you do not...

Remember the network share the backup is being restored from has to be accessible to the user that is running the SQL server service - it is not enough to...

Just beware of a little potential gotcha here - using convert with varchar and no...

Is one (or both) of the servers Win 2000 Server or are both Win 2003?

Ah .. didn't notice that .. your subselect makes more sense then (though again it might be necessary to exclude rows in subselect where the actual phone field was not...

What about something like

SELECT

*

FROM

(

SELECT

COLUMN_NAME,

...

Coalesce will only work if the phone number columns are nullable and have nulls when the value is not there - otherwise if a record did exist for e.g. home...

What is dbo.Tally for this example?

Win 2003 has built in firewall (bit like XP's ... i.e. half hearted) and security is generally locked down a lot more so by default it is difficult to...

I do something similar for those long tables

SELECT

' ' + 'alias.' + COLUMN_NAME + CASE WHEN ORDINAL_POSITION=@@RowCount THEN '' ELSE ',' END + char(13) +...

Can't see how that can be the issue - because parser must be looking up the column names anyway even if fully specified so that it can error on e.g.

SELECT...

So who said you can never have too much memory!

You will get this error if you are using Windows authentication but the client machine is not logging into the domain (or AD) that the server is on. I...

Replies so far seem to have missed the obvious point that the same text takes up twice as much space in the database as nvarchar - because the unicode character...

This actually sounds like it might be a target for replication rather than DTS