Hi Paula.

What version of SQL Server and service pack are you running?  Does http://support.microsoft.com/kb/281287/EN-US/ apply?

Thanks Itamar perhaps my previous email was lost or misdirected. I will contact you directly with details. 

Thanks for the clarification Brian.

I agree with Frank.  Using char (or nchar if using Unicode) makes sense if the values are always  or almost always the same length.  For example in Canada (i think...

See http://www.sqlservercentral.com/scripts/contributions/510.asp  I have been using this script for a while now.  I prefer it to xp_smtp_sendmail as I can use it send the results of a query.  I...

WARNING:

 This website looked very suspicious.  Why would a charity give up 7% of its donations.  Why can't they accept donations directly.  I did some digging and found this link claiming...

try using

LEFT OUT JOIN north_data.event

ON north_data.class = xlocator and north_data.event = xlocator

WHERE north_data.class IS NULL

re: ApexSQL Edit.  There may be trial copies available but it is $199 to buy.  ApexSQL edit has the advantage that is specifically designed for SQL coding and has lots...

Ultraedit can do this.  I don't know of any freeware editor though...maybe

You let users install SQL Admin tools?  Be that as it may, there is just the SQL 7 or the SQL 2000 version of the tools.  The service packs affect...

SQL Zip is another contender in this field.  I have no experience with the product so I can't say how it compares.  It costs US$500 per server.

Well your english may not be perfect Chopeen but it seems pretty good.  I've met people whose first language is english with a worse understanding.  I understand what you meant.

Chopeen:   By execute I mean that SQL Server processed the command.  Whether it was processed successfully or not is irrelevent.  If I execute the script

IF 0 = 1 ...

I'm still confused.  The question asked "Which of these scripts will execute?"  They both execute.  However only the first one works sucessfully because of when the Quoted identifer statment works. ...

Replication and RAID are two different things although I agree similar functions can be achieved.  RAID is usually set up to guard against a local hardware failure.  Replication is set...