see BOL - "Customizing the Lock Time-Out"

SELECT @@lock_timeout;

GO

SET LOCK_TIMEOUT 1800

GO

Find this more readible?

Declare @i as int

Set @i = cast(right('02/04/2008',4) + substring('02/04/2008',4,2) + left('02/04/2008',2) as int)

select @i

(I'm using '02/04/2008' as you can see the month and day)

Not sure what you gain from the explicit transaction.

Can you pass the data you insert to the table to the java app as parameters? That may release you from having...

Be careful - changing the database settings will not change the collation of any data already in the database.

what errors are you getting?

Hi

Why not use activity monitor?

Gives the last SQL batch for the process...

Same here - the second statement is OK for me.

Mistake in the Qu.

You get the sql by double-clicking on the process, which I think solves the original problem - although I'm not sure if there would be truncation.

the alternatives posted seem interesting...

Hi

If it took 300 hours to import, you must have a big database.

One consideration for any restore as suggested above should be to check if you have enough space for...

Maybe I mis-understand this.

You can run the alter command to change the collation of existing columns, but any data already in the column will keep the OLD collation.

This could give...

Take care - C2 Auditing seemed to cause my server to crash.

Disabled it and no crashes since (6 months).

Hi

When you say the query ran quickly before, did it run on the same database with the same numbers of users? I would suspect that there have been some data...

Hi

Two thoughts.

1 - select from sys.dm_os_wait_stats - may indicate where you are waiting for resources? Dont forget you may need to clear the counts -

DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR); (see...

what happens if you run profiler on the job?

is it under legacy?