Select a connection type from the Connection menu.  In the connection properties box, select Existing connection and select the name of the extra connection and click OK.  This associates an...

Don't depend of sp_server_info to be correct.  It select data from the master.dbo.spt_server_info table which is not necessarily kept up-to-date by hot fixes and service packs.  See this article by...

I'd use DTS for the import.  It has connection objects for all formats you listed.  It can be scheduled as a job.  If the filenames are consistent, you could do...

We're thinking about trying ApexSQL Doc.  It's $199 for a single seat with volume discounts and free support and upgrades.  Sounds like it works a lot like the AGS tool...

Daniel,

You don't mention if you want to rename and retain the log file as well as the data file.  If you want a new log file to be created when...

Dave,

At the very least, implement a backup plan using SQL Server Backup rather than DTS.  As Jason pointed out, you can schedule a combination of full database backups, differential backups,...

Marvin is correct about not being able to use a variable for a table name, but I don't think you need to anyway since temporary tables aren't created with the...

It would work if dbo is mapped to the same login in both databases.  This is an example of cross-database ownership chaining (see BOL).

By the way, it's not a good...

Looks like it's working to me.  Maybe there aren't any rows with a DBDate of 1/28/2005.

Try the select where DBDate > '01/27/2005' and see what you get.

Greg

That's my understanding.  The $2800 per developer list price seems kind of intimidating, but is probably worth it if you want Visual Studio and Office XP also.

An MSDN subscription gets you Developer Edition.  You can also get the Developer Edition alone for a per developer price.  Check this link:

http://www.microsoft.com/sql/howtobuy/development.asp

Greg

select * from table

where DBDate between '01/28/2005' and '01/29/2005'

You just have to remember that '01/28/2005' really means '01/28/2005 00:00:00.000' when compared to a datetime.

Greg

Packagetype is a column in the sysdtspackages table in msdb.  Since you say it's a new SQL Server installation, maybe the service packs aren't up to date or it didn't...

I don't think you can do it.  I've even tried use a Data Link file created with the ODBC dsn for a remote server and it didn't work.

I think because...

James,

The import package may be failing when scheduled because the login used by SQL Server Agent doesn't have access to the Access 2000 database location. 

Keep in mind that when...