before you fail back check its portno.

with this script. Don't know where i've downloaded it from(author is mentioned), but it does the job.

then fail back and run it again. It...

I didn't encounter it in sql2k because I create a clustering index by default, and until now I didn't get any complaints from the app-resp. (Or they can live with...

How up to date must your data be. Do you have control on that ?

If yes, you could have a simple normalized table structure and a "relation" table. after...

I've had the same issue with a heap as Andy Warren. This was on a SQL7 sp2. Now I only REMOVE a clustered index if it's been proven it hurts...

maybe this link helps ..

http://dbforums.com/t746009.html

did you check that the account that runs the cluster has access to your sqlserver. (login should do)

"declare @sql nvarchar(2000)

SET @sql=N'Select *

From vHaulageJobsUnfinished U

WHERE EXISTS (

SELECT *

FROM HaulageItems I

JOIN Jobs J ON I.JobPrefix=J.Prefix AND I.JobID=J.ID

WHERE J.JobRef LIKE ''' + @ShippingJobRef + ''' AND U.Prefix=I.HJPrefix AND U.ID=I.HJID

)'...

"... but replace all the 'IS NOT NULL' statements with '!=NULL' and ..."

You'll have simular differences when you use the JET-syntax for outer joins on sqlserver.

'*=' does not work...

You'll always (never say never ) have to interpret business "demands" to "needs".

You can do the same thing in # ways. Some are already constructed for...

Maybe you can go for the colation-solution with your select. (check BOL)

e.g.print CHARINDEX('k' COLLATE Latin1_General_CS_AI ,@teststr COLLATE Latin1_General_CS_AI )

When you run the package, is that at your client or are you at the server-console ?

Don't modify dts-packages from your client, but always perform this stuff at the server,...

is the job-step set to "quit with failure" when the step fails ?

With Standard VB6 it needs a normal login-procedure and the a switch to the

application-role executing the sp_setapprole.

Is there a .Net-framework-based integration for SQLServer application roles?

If not : are application roles...

If you just want to insert and you don't need the recordset fore anything else in your logic, don't use the recordset to do this, but use a native insert...

maybe isnull(yourcolumn,replacementvalue) can help out or

coalesce(yourcolumn,replacementvalue)