While I have never seen anything that discussed best practices, there are a few articles here on SSC that mention error handling... including

http://www.sqlservercentral.com/columnists/rmarda/doesyourspchokeonerrors.asp

There are a few others spread...

Hey Steve,

They connect over the Internet using Enterprise Manager, with sql server authentication.

Thanks,

Dan B

Everything I have heard would indicate that BOL is correct in this case.

Dan B

Are your users connecting with sql server authentication or windows authentication?

Try including the LoginName column with your trace to see if anything is returned there.

Dan B

Or this might be a little prettier...

select t.[name] as tablename, isnull(p.[name],'') as ConstraintName, 

case p.xtype

When 'PK' Then 'Primary Key'

When 'C' Then 'Check'

When 'UQ' Then 'Unique'

When 'F'...

How about something like this?

select t.[name] as tablename, isnull(p.[name],'') as ConstraintName, isnull(p.xtype,'') as ConstraintType

from sysobjects t 

left join sysobjects p on t.[id] = p.parent_obj

where t.xtype='U'

order by...

Andrew,

So that we may more accurately reproduce your problem can you provide sample code from beginning to end that fails execution, including sample data?

Dan B

Andrew,

How about simply adding a cast to varchar around each field being concatenated? Something like this?

update clnpers

set cust_id = cast(shop_id as varchar) + cast(rec_sname as varchar) + ...etc

Dan B

...

Thanks Andy! I will give this a try...

Dan B

Are you able to successfully create a DSN on the web server with the same credentials as your code? Perhaps the user is not set to the correct default...

I found the two mcse/mcdba (70-228/70-229) training kit books from mspress to be pretty good review. However, I think it is worthwhile to check out other books about sql...

Yowza...

I never thought that it worked on all FT columns individually.

Certainly highlights the difference between thinking like a person and thinking like a machine.

Certainly had a hard time...

Peely,

Once your deletes are up to date it seems possible that the number of daily deletes would be close to the number of inserts. How about an INSERT trigger...

Groovy.

Thanks Mark!

Dan B

I am pretty sure the BackOffice 4.5 Resource Kit has scripts to set up log shipping as well, although I have not used them personally.

Dan