Try to alter table to allow "NULL' for that date column.

Can you check whether you can access sql server from your IIS server using OSQL/ISQL or ODBCPING.exe utilities with same login ID and password?

If you use ODBC DSN to connect...

I would look into the query execution plan whether proper indexes being used and the number of physical IO occurs during the reconcilation.

I guess you want place '1/1/01' into a date column if user does not enter date from Access form. If it is, you can alter table to add default constraint...

To enable Windows 2000 Advanced Server or Windows 2000 Datacenter Server to support more than 4 GB of physical memory, you must add the /pae parameter to the boot.ini file.

Microsoft®...

Because your SQL Servers are in active/active, I assumed you have one default inatance and one named instance. you are able to access the default instance that uses TCP port...

sp_helpserver will tell you which server are the linked and remote servers.

You may then search syscomments table to find out those procedures.

http://www.lumigent.com

Check setup log from c:\winnt\sqlsp.log.

If you want to move specific tables and indexes into second RAID disks then you need create filegroup and database files into the filegroup and recreate cluster indexes on those...

You don't really have to create second file group and move database files into it. Simple restore database that has single filegroup into new server, detach the database, move half...

http://www.sqlservercentral.com/columnists/awarren/introductiontotheadoconnectionobject.asp

This is you are looking for.

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

You have to run Profiler for the period of time as you like to trace which tables, views and SPs have been used and compare the results to your database....

Backup database statement doesn't have any options to let you verify the database backup. Actually, another statement "restore verifyonly" is ued to verify the backup.

Here are the statements generated in...