Did you read Remi's anwser? You can't use x = NULL

You should either account for those cases independently using IS NULL or the Change the ANSI_NULLS to ON (this...

As David Posted you are going to need the COLLATE statement

 and you will have to use it either at the "join"  , "where" or at both clauses depending on the...

You can run distrib.exe fom the command line!

Search BOL for "Replication Distribution Agent utility" for more info 

hth

Yes, that will do what you need.

Becareful to really ensure that you don't need that initial check!

... and viceversa

Don't know much about clustering but I know you can't rename an instance

Christopher,

When you use EXPLICIT Transaction commands you have to call COMMIT or ROLLBACK after you call BEGIN TRANSACTION.

Lets assume that in "your post" you get an error in the...

Actually, I would like to suggest you use a stored procedure instead of a view if at all possible.

Declare @list varchar(200)

set @list = '688,708,87,88'

Select * from Employees

where charindex(','+ cast(empID as varchar(10)) +',', ','+@List+',') > 0

That Error handling should "In my opinion" be used only when you are trying to perform several DML as a single transactional action. You should not need that for a...

No Problem, Feel free to post again if you find any more problems

When you run that script from a Job it is using SQL Server Agent service credentials. Services do not know anything about mapped drives because that information is kept in the...

In your case

-max server memory is not needed.  (use dynamic)

-min server memory neither (use dynamic)

and because I am recomending dynamic allocation "working set size" does not need to change...

DBCC setinstance (objectname, countername, instancename, value)

hth

Pretty sure you don't need a cursor for that!