Hi,

Ok, I followed your instructions, and it appears that the problem columns are dates.

In particular, dates entered incorrectly like 01/01/205.

In DTS I ave been able to program around stuff like...

Hi,

My admin managed to not install SSIS when setting up the server. Its a 64bit cluster which ads another layer of complexity to it.

Apprantly there are some limitation to 64bit...

yeah, I'll do that.

The temp table is within a stored procedure I would like to call. its resultset is the data I wish to insert into the other database.

Because the proc is quite...

thats no so good for multiple calls to the proc.

I am investigation use of the table ar at the moment.

thanks for all replies.

Hi,

When creating a new database, the 'Space Allocated' field actually reads 'Initial Size (MB)'.

Thats Fine.

What I would like to know is that: if I change the 'Space Allocated' setting on...

I assume in the space allocated section? I was looking at that but...

Won't that change the size of the database that is currently in use?

Or will it change ONLY after...

Actually, the insert is within a transaction that I see now is far too large. ( I didn't write it). I have reduced the number of queries within it, and...

Hi,

Node 1 is running what I think is quite a straight foward query and I do not know why it may be using an exclusive table lock. Why might it...

Hi,

I'd already added the WITH (NOLOCK) statements to the query #1 after posting, and intend to remove the statement on the INSERT.

It makes sense a little more sense not that...