SQL2000 How to install it on an AMD3 core computer

Shielding a core,I'm like this too.,In the BIOS setting,Yes,Since you can open the core, you can shield.,The method tells you.,How to shield.,Each BIOS is different.,Options like CPU Core are。 Mine is x3 440 I hope it can help you.,I'm also a problem I just discovered.。。。 If it's a triple core, you can use it without playing SP4, and you can't even pass the last step by playing SP4, and it's stuck directly, and it can only be used in the dual-core in the future!

I've tried, and then open a core after installation, and SQL won't start! Believe you, Microsoft doesn't seem to support odd cores

I've had this happen to you, and I call it dynamic configuration fields, but I usually do it with the design language. It is rarely implemented by SQL statements alone, of course, it can be achieved through SQL cursors and exec statements, and the principle is the same anyway.

Note: SQL Server seems to have a limit to 255 columns.

Step 1 Read the record and table1 to get the listing.

'select * from table1 where like ''de%'' ';

while not do

beginstrclu:=strclu+','+'name').asstring;

end;- Step 2 Assemble the required SQL query statements.

=' select '+strclu+ ' from table2 ';;

It doesn't have much to do with the processor, you look at your system version and SQL version, if it's XP, then install SQL Desktop Edition, if it's Server (2003 2000), then all four versions of SQL can be installed.

It can be solved by opening into four cores.

With 2005. Otherwise, it won't be easy. 2000 plus sp4 should do the trick. In 2005, SP4 should also be added. They all have corresponding sp4 patches. Make no mistake.

It's AMD's three-core Ken shouting that he doesn't need to pretend, I personally tested it, Zheng Shou Zheng has many netizens personally tested;

Other non-tri-core ones may need to be patched, what patches, I don't know, I haven't found them;

3.Intel's processor should be fine! The rest is to install the potato with the system administrator permissions normally!

Yes, it is best to have a 2003 or 2008 server version

The SP4 patch for SQL adds support for multiple cores, but this support is limited, that is, the number of processor cores must be to the integer power of 2, i.e. cores, etc. From this point of view, not only the triple core, but also the upcoming Intel6 core is likely to be unsuitable. Because the software fails to pass, it is useless to patch the CPU, and the solution is either for Microsoft to provide an update patch for SQL2000, or to use deception to pass the detection of the software.

Judging from the information received so far, sql2005 may still have the opportunity to cheat the detection by modifying the number of cores in msconfig, and sql2000 sp4 has no chance at all. Therefore, for the time being, the sp4 patch cannot be applied on the triple-core physical machine.

There's no good way now, I'm also a server like this, and I've been looking for a long time and have no way, so I have to install a virtual machine and I'm trying.

SQL doesn't have much to do with processors.

I don't know. I can only say for sure that it has nothing to do with the processor.

A large part of this is due to systemic issues.

On computers with multi-core processors, you might not be able to install SQL Server. Here's Microsoft's help.

Talk nonsense. It's just possible. I can fit both cores. The roommate's quad core is not pretended to be used.