Here are two more common-sense suggestions:

1. Don't forget to take a break every so often. It's easy to get so deep into a project, the adrenaline starts flowing, and you...

There are a few situations where select * from a table might be beneficial, from a maintenance standpoint. Example: My customer uses a service vendor that performs USPS address validation, zipcode+4 lookup,...

From the standpoint of server administration, each instance of SS should have all of their database files in the same folder IMHO.

From the .NET side, how big of an effort would it...

If I read into what you're saying, VS2005 automatically puts the database in a folder that is inconsistent with the customary SS 2005 folder structure. So the root cause is...

Let's hope not.

Anyway, there is one more player I didn't mention, since they are new on scene - the online store vendor.

The customer is basically a trade association. At their office...

Thanks Jeff. I was thinking either ignorance or sheer stupidity.

There are four players in this scenario - the customer; the vendor that installed & configured the new Windows server with...

On the first page of the dialog, there is a check-box "Move pages to the beginning of the file before shrinking" try checking that box; Then click Files to reach...

Here is a video from Popular Mechanics. It really does look cool.

Microsoft Surface: Hands-on First Look

http://link.brightcove.com/services/player/bcpid932579976?bclid=932553050&bctid=9337 

select PL.pageDisplayName, COUNT(EL.eventTargetID)

from pageList PL

INNER JOIN eventlog EL ON EL.eventTargetID = PL.pageId

where EL.moduleID = '1179652124'

group by PL.pageDisplayName

order by PL.pageDisplayName

I think it's more a matter of contrast than color. Remember WordPerfect for DOS? Users would type white text on a blue background, and then print black text on white...

I would prefer the ANSI join syntax for two important reasons:

1. It clearly separates the join logic from the criteria logic, making the code easier to understand & maintain

2. SS...

That might be "the three hops" problem - Windows can pass credentials from one machine to another, but the 2nd machine cannot turn around & pass those credentials to the 3rd machine....

Haven't tried this with SQL Server, but this works with Access:

I import from a workbook that has one sheet of data, but it also might have a sheet of instructions. (The file is an...

I logged in to the MS Managed Newsgroups, didn't find a direct answer to your question but the key is stored in the registry here:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration

Name: CD_KEY

Type: REG_SZ

Data: (your...

Will, on 5/23 you said

"As I said originally hard drives were failing."

but re-reading the entire thread I can see that was not actually the problem. Sorry for butting in.