Plese, verify the data format before convert.

You can explicit the format for data in convert clause.

Hi

Is this case, try to connect via query analyser and select * from sysprocesses to verify blocked processes.

In some cases, blocked processes and network activity causes this error message.

Do you use a Bulk copy to insert data ?

If true, I don´t  know if Bulk Insert start a trigger.

Please , refer Books online.

HI

I concerning with AKM.

The  best method are create a table for you save a price.

Use a table like AKM describe. Its a best pratice and you are compliance with...

Hi

I sharing too. The risk we knows.

I had many problems with kill sessions and the last resource was a reboot or stop and start SQL Server.

The chance of you corrupt...

For detailed informations on select cluause you can use a syscolumns together as sysobjects.

Lets try.

Hi

If your datbase status stayed Loading and you have a log file, apply all logs to full recovery.

If you dont have logs, retired hint recovery from restore command.

Hi

You can use two attach methods : simple text ou HTML format.

Yoy may decide what format you´ll are use in parameters passed do cdonts.

Please, check documentation available in microsoft or...

Hi

When you use right join ou left join , it´s possible that you have resust set with null values.

To prevent this, youn have to way :

Use isnull function in the...

Hi

Can you post the first line you are using to import via bcp.

Some problems are related on separator and/or delimitator row.

You´ll need use dynamic sql to processes a query.

You have Openquery(@sqlStmt)  command or create dymanic sql and exec(@sqlStmt)

One tip:

Try use hint nolock , if possible.

You´ll prevent exclusive lock in table.

Other way , try rowlock hint to minimize locks.

Hi

All suggestions works fine.

But we need know realy what we need.

For each case we have many solutions, but the best solutions is a least expensive.

Distinct clause is leats expensive than...

HI

One tip !!!!

Try using cdonts.

Cdonts work better than xp_sendmail and you can improve a format that e-mail send it.

Hi

Remember that FK is relational integrity enforcement.

In this case, try to delete all records in child table before try to delete records in parent table.

Seen in BOL.