If you can't ping it, I doubt you can get DTS to connect. If you can connect to it via Query Analyzer from your local machine, then you should be...

I'm sorry I don't have time to detail all about connections here. In the meantime, check out http://www.sqldts.com. Under Tutorials they have a good tutorial called Building a Package...

If you can get Windows to recognize the shared drives as the same drive letter, etc. You should be fine.

One of my favorites "Women want men to change, but they never will. Men want women to stay the same, but they never will."

Not too lyrical, but true.

How about...

We use HiT software's SQL Server drivers to connect to AS400 DB2, and it does require a linked server definition:

http://www.hitsw.com/products_services/sqlmiddleware.html

It sounds like you shouldn't need .Net on the SQL Server box. As long as you aren't running IIS (and/or Reporting services Web server part, etc.) on the SQL Server,...

Well, those above are good for learning T-SQL. The Murach book is especially intended for Developers learning T-SQL.

Professional SQL Server 2000 Programming by Robert Vieira is good also. It...

If you're at the begining/intermediate level the Murach's SQL for SQL Server by Bryan Syverson is a great book. If you're a little more advanced, The Guru's Guide to Transact-SQL...

I think that they are good for establishing a certain floor level knowledge on the part of the test taker at minimum. You know what is possible, but not necessarily...

Believe me, it's nothing impressive. I just do well on those 'standardized' type tests (MCSE, MCDBA, GMAT, eetc. tests). I've taken 14 Microsoft tests, several other vendors certification tests, the...

For practice tests you could go with Transcender or Testking, etc. there are a lot of people who sell practice exams for the test.

The test was something like 54 questions...

Generalized view:

In ER tools (like ERWin and ER/Studio), the Logical model is the data model with no concern as to what platform the database is going to be run on....

BTW. In this case Diff backups also help keep you from having one of those 15 minute t-log files be corrupt and messing up your whole recovery. I'd hate to...

you should be fine then. The full will include everything up to the completion of the backup.

The Differentials just help keep you from having to restore ALL of those...

There's a lot of information about this subject in Books Online. Check out 'Backing up databases' and 'Backup and Restore Operations.'

Unfortunately, Books Online isn't the best resource for learning...