The target table must be already exist before you run the insert into statement.

Or you can run select * into targettable from originaltable if the target table hasn't been...

How do you setup the linked tables to SQL Server in Access? If they are connected to SQL Server via ODBC and the ODBC configuration and SQL Server name havn't...

Partitioned View is the solution you are looking for. With partitioned view, The original table is replaced with several smaller member tables and each table stores a horizontal slice of...

I guess the statement runing in your client machine may be executed in parallel because the machine has two CPUs. The default SQL Server configuration for 'max degree of parallelism'...

Try the CONVERT command.

When you login into Outlook, which NT account did you use? Do you use same account to start SQL Server? The SQL Mail test only check the mail profile and...

can you run select * from sysprocesses to see what are the status, waittype and lastwaittype of this spid?

Two options.

1. Create DTS package to load the data. Search http://www.sqldts.com article "Looping, Importing and Archiving" for sample.

2. Use xp_cmdshell to load all data files name into a...

Before you restart SQL Server, user command kill with statusonly to generate a progress report on a given spid that is being rolled back to see how far the rolled...

Are those files be well organized? For example, Are they in same directory, has same format/structure, file name contains date info. Is this a one time process? What type of...

xp_readerrorlog -1, 'p:\mssql\log\sqlagent.1'

I think you need to run DBCC CHECKTABLE against those tables to see whether you receive any error message.

If you have space shortage issue and customer does not require recovery to any point in time on database failure, you can simply set the database recovey mode to 'simple'...

DBCC SQLPERF(LOGSPACE)

You can alos setup an alter to monitor your database transaction log and fire the backup log job once the log size excesses the threshold.

Don't think you can do it. You may have to transfer the data into second server and place tables into different file groups.

Why just use Copy Database Wizard, Backup...