Thanks, but can I also apply the same sp2 hot fix so that it becomes 9.0.3054 ?

But what is "Extended support" ?

Does it mean if we have had "Extened support" from Microsoft, we can still have Microsoft technical support services on our SQL 7.0 systems ?

...

Dear Adam,

Thanks a lot.

Yes, I have added the Q drive - Quorum to the Cluster group.

However, other than Q drive, I only has the R drive in SAN.

When I setup the "MSDTC Group",...

sorry, forgot to include this small part :

Your problem is : your products have their own set of attributes which are quite different to the others and you can't make...

Here is my updated version, ignore the previous one.

How about this table schema desgin :

Product

ProdID Brand Model UnitPrice ...

Hi

I was wondering if anybody could give me some advice with the following:

I have a table called Product (this is for an e-commerce site), now I need to show this...

Thanks every bodies.

The column's data type is VARCHAR or NVARCHAR, it is assumed that user will only input numeric data, eg. 123, 3, 4, 32.

However, due to some human mistakes, some users...

Thanks for all of your replies.

Do you are these Service Pack 2 & Hot-Fix are the latest ones for SQL Server 2005 ?

Or there are still some updated version ?

Service...

What is "CU4" ?

Please upgrade to SP2 + HOT FIX.

You should use SP2 or even SP2 + hot fix, if you have done it, your SQL will have the following version number :

SP2 only : 9.0.3042,

SP2 + hot fix...

Yes, you are right, all SQL-related counters are also zero :

"Time", "Available KBytes", "Full Scans/sec", "Index Searches/sec",

"Logical Connections", "Logins/sec", "Transactions", "User Connections",

"Average Latch Wait Time (ms)", "Total Latch Wait Time...

They are OK, eg. % Processor Time, % Disk Time, Physical Average Disk Queue Length, all of them are normal.