OK, I am in the Colation screen and I selected "Windows Collation", selected "Dictionary Sort" and checked "Case Sensitive".

Now what Collation Country/Language do I select in the drop down list...

For SQL Server licensing it is licensed by CPU "SOCKET". If you have 2 physical CPU sockets you have to purchase two licenses. They currently do not count the cores,...

YES!

Every dba should know the hw drive configuration. Although SAN technology has improved, there are still plenty of bottlenecks and they are always on the drives. I am assuming your...

I got two different results. The first returned 75 and the other returned 150. I double checked it by writing a vbscript to get the count of each record length...

Keep in mind when importing from an Excel spreadsheet, for Excel the Maximum rows in Excel for a sheet is 65,535. Not too big when compared to SQL. We regularly...

Perfect!

Thanks everyone.

Never ever Image a SQL server.

Hence your problem.

Sorry. :o(

I can only suggest that you do a Raw Windows build, patch it, cut your Ghost/image of it and install your instance...

I don't know what type of data you are importing, DateTime, Int, BigInt,varchar(xxxx) but when SQL opens an Office file, it requires some dll to do this. Try Saving the...

Thanks alot everyon. I really appreciate your help on this one. I did not have this problem on our 64bit servers. They took whatever I told it to take.

Thanks again.

Thanks for the reply. I've decided not to turn it on.

Thanks

Try connecting via IP address.

You're going to think I'm nutts but this will most likely solve your problem.

I am assuming you are installing in your first node? Correct?

If so, then log everyone off from...

How can I query to see if rpc is on or off?

BINGO!!!!

Renaming it twice did the trick!

I actually used the GUI to do it.

I get the following error...

Msg 15032, Level 16, State 1, Procedure sp_renamedb, Line 36

The database 'HR_TRACKING' already exists. Specify a unique database name.

Obviously SQL knows the correct name, users are...