what format would you like us to use? dd month year, without any punctuation at all? (example: today is 17 August 2007)

the short date format, using two...

I agree with Matt, especially because with the expansion in internet banking, it seems to me that neither set of codes is truly exhaustive. What if, down the road,...

1. Remember that SQL 2k5 uses TempDB MUCH more than prior versions. 2. Maximum number of simultaneous connections, minimum uptime percentage - 90%? 95%? 98%? 99%?...

Are there version differences between the 5 servers? missing updates or special patches? As always, verify permissions are valid?

OK.... let's deconstruct what you've asked:

Source:

1. trivia - implies that the person pays attention to details, no? and will absorb information that may not seem immediately relevant to...

what's the difference between slang and formal speech? You can say the same thing using either. However, computers as a rule greatly appreciate formal speech. I believe...

so, does case 1 solve your problem? and, if it does, do you want to discuss how the group by does not?

Haggis, the reason why the question was asked is you have a redundant 'Order By'. Try removing it and see if the query works.

Also, this question is T-SQL, but...

jp - it seems to me that you are trying to estimate the amount of space that will be 'freed up' by archiving all the database content for the year...

http://en.wikipedia.org/wiki/OOAK - One Of A Kind - i.e., uniqueness

As a general rule, in databases, you can either be REQUIRED to promise OOAK, or you can only have it recommended. ...

Given your scenario, how important is this? You want to import into Development before PROD? from the same source? Why is Development more important than PROD? ...

I believe that once an index is defragged, there is nothing to roll back. more critical, though, is that any subsequent index after the failed index will not be...

IF we are talking ONLY about an 'internal management database' that will compile information about the 40 instances, why not use the instance number as part of the key field?...

In some cases? In all cases? I suspect that the tool believes you are in the middle of a process, where performing such activity is verboten. Are...

Why not follow the directions specified?

=====================================================================

BugCheck Dump ...