When you create something in TempDB you can of course specify the collation you want.

We do something very similar the only tweak is that the questions have an 'answer type' attribute which defines how the question is answered. Currently we have three types of...

I'll bite until someone who knows 6.5 better comes along.

You could use a DTS text file connection in place of isql?

Do you see it growing by 500MB increments at all?

The sytem tables map here might help you:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

Mine just seems tio remember the view you last used for each database.

Mail is great fun and I always go through the same pain setting up a new server.

SQL Mail needs an smtp client (aka Outlook) installed on the same box as...

I did it by copying dtproperties and it worked fine. Here is the MS way just for reference: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125

If you are able to delete from the source you could try this: Batch up your records into bundles of say 10% of the total. Start a transaction insert a bundle...

Hi - Just to give us a bit more to work on..

How are you running the transfer ?

Why is the server bounced once a week ?

If needed could...

I'll bite.

I think that one of the convets is redundant. Also I think it's missing a closing bracket right at the end.

convert(numeric(10,2), convert(numeric(10,2), IsNull(Run, 0))

could be re-written as

convert(numeric(10,2), IsNull(Run,...

If you wil be running big queries where result srts and interim result sets will spill into tempdb then I wouldf look to put tempdb onto a seperate RAID 5...

I think you mean Hardware - I'ts got a RAID card. Config of the RAID card is probably done through a software app (look under Dell in Program Files) but...

Hi - I tried to reply but my post got lost somewhere.

Briefly 2 ways of implementing RAID. Hardware & Sioftware. Software through NTFS & Disk Manager - slowest because it...

If you want to disable the trigger globaly use

ALTER TABLE table 

    | { ENABLE | DISABLE } TRIGGER

        { ALL | trigger_name [ ,...n ] }

On the other hand if...