Enterprise Edition can be installed in Windows 2000 Server. In order to allow SQL Server 2000 to use more than 2GB memory, you have to add /3GB switch in boot.ini...

Have you tried to work on FileSystemObjects?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsmthcopyfile.asp

What about SELECT MAX([User].[User_ID]) as UserID INTO #t1 from [User]

We have consolidated the SQL Serves for CRM application. We created named instance to host databases for both DEV and QA for the CRM applications. It is not recommended, probably...

See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16187&FORUM_ID=20&CAT_ID=2&Topic_Title=18456+Level+16&Forum_Title=Connecting

Are you both from same company or it is just a coincident?

It is delimited by ",".

If table already has the composite primary key, it will be reconagized when you create the linked table from Access. IF the table doesn't have primary key, during the creation...

Did you run the QA from SQL Server machine or from another workstation?

Most of records in the text file have same number of columns. But sometime, there are few exceptional records which have more columns.

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;826161

No, you don't but you need rename them and give the new linked tables with the old name.

Edited by - allen_cui on 09/11/2003 09:32:10 AM

Fisrt create DSN to your SQL Server, and create linked tables in Access database via the DSN to SQL Serevr. The linked table name should be same as your original...

Don't think you can disable it. If the login used in SQL Server register property doesn't have 'sa' privilege, you wouldn't see the maintenance plan wizard.

You have to have 'sa' right or create SQL Server Proxy account or grant execution permission on this xp to specific users.

It may not help but you can check.

http://support.microsoft.com/default.aspx?scid=kb;en-us;268520

http://support.microsoft.com/default.aspx?scid=kb;en-us;198520