I suppose your DBs are too big to fit onto drive C?

Could you

1. Perform a full backup across the network in the morning.

2. Then, at the beginning of your 3 hour...

Ahh...  Have you checked the scripts repository of this site?

What may also help is to

a) Backup your data as a precaution

b) Power down the machine.  Remove the mirrored drives (I assume both are being upgraded since they would want...

Hi.

You'll need to restore your backup to a SQL 2005 instance.  From there you could generate script to recreate all of your tables, views, stored procs, triggers, functions, constraints, etc. ...

By schema do you mean a diagram or the SQL code required to create the tables, views, stored procs, triggers, etc?

If the latter, then script your DB from enterprise manager. ...

Everything in moderation...  I personally do not make a lot of use of XML at all.  I think the use of XML in standards is beneficial due to the wide...

hahaha - we'll see

I had previously added to this thread good point   Still is a good point,

but rather than following the way of expressing...

Very true Tim - you cannot rely on SQL doing that..  I have seen one case where someone proved that SQL does do a form of lazy boolean evaluation but...

You are right, MS Search can be a pain but has been made a bit easier maintenance-wise in 2005.

Perhaps your users want to be able to use surrounding quotes -...

Use a case statement (or several).

EG

(ps, formatting your code as "Formatted" makes it a LOT easier for us to read & understand)

SELECT  
 wkey,  
 STATYR,  
 'N' AS overrideFlag,  
 Case 
  When GRDTOT...

Look in the articles section of this site.  Articles for those topics are probably in the T-SQL articles section.

The other place to look for definitive information is SQL Server Books...

Fair comment from Roger.  Makes me think actually that the next step for the article would be many-many relationship as many people...

Good article - I too have come across some rather powerful systems with no FKs.  Their excuse was that when data loading they could do it in any order.  I...

Note that if the table has referential integrity constraints then you cannot just "truncate" it, even if it is technically empty.  you'll have to use delete from [tablename] in that...