Jerry,

SQL server 2000 running on non Itanium server is always 32 bit 🙂

SQL server 2000 Enterprise Edition is ONLY IA64.

SQL Server 2000 Standard Edition is always 32 bit.

You should verify that the security context under which you are running xp_cmdshell has rights on the file system where you are trying to copu a file.

Sorry for the short response. I was interrupted while answering.

It looks like that you are experiencing a memory pressure problem. SQL server 2000 does not respond to memory pressure.

You can...

Suggestion: upgrade the RAM to 4 GB. Cheap and effective.

Sorry, I think that you are mixing data architect tools (ERWIN etc.) with change management tools.

You might want to take a look on ApexSQL Diff (www.apexsql.com) and similar tool from...

Sorry, your original question didn't state anything about performance issues.

I am using uniqueidentifiers (GUID) with newsequentialid default...

Dave,

MySQL market share is ~30%. It's used mostly in a small Web faced application.

If you are talking about a stand alone application then I am not aware about any...

Since there are not many details posted about particular requirements, I would assume that the most danger is in the learning curve of using Linux and MySQL in Windows and...

I am wondering that there is no privacy warning in BOL about identity... If with GUID I can only...

It is possible in SQL 2005 to create a GUID field with NEWSEQUENTIALID() default value.

NEWID() is random.

Can you please provide a DDL for the table?

You probably meant Visio, not Visual Studio?

ERWIN, ER/STUDIO, TOAD all have a trial version. It is more about your personal preference (and budget).

BTW, I am managing a DB with over...

Before adding a linked server, can you verify that you can actually ping both fully qualified name and IP address of linked server?

The thing is:

1. I do not understand what is a "traditional" report system. For me any "traditional reporting system" is a DWH. The goal of almost all DB based applications...

Just two last questions to clarify your position.

1. So,...