depending on what you want to learn and what you already know the official MS courses for 2008 are

6231 - Which is more on the admin side

6232 - Which is...

same table same server? same table different server?

can you post the code you executed, including the DDL definitions of the objects involved in the query?

your trying to insert more than the column can hold, for example inserting a string of 100 characters into a column which can only hold 50.

i would identify which column...

you will need two sets of licences, as you need to licence the machines which run the services and as you will have two boxes with a SSRS service thats...

Size widely depends on what you store, how often you purge and the amount of indexes and other objects are within the database. I have prod DB's which range...

i dont have anything to hand, but I'm sure our good old friend google will help you out.

need to create the DSN which points to the MDB file then create...

if this is the only step in the batch you could just select @@rowcount, if not you will need to declare a varable and set that variable = @@rowcount at...

guessing its possible as you can create ODBC connection strings for the data sources, so aslong as you created and ODBC DSN which pointed to your access mdb shouldnt be...

you could use powershell and script out all the objects you require into one big script and run it on 2005, you could also script the entire database from 2008...

have you granted one of the db_dts.......... msdb roles to the user?

In tests that I have done, 32bit server >=4GB RAM <=12GB RAM need /3GB and /PAE, servers >12GB RAM only need /PAE

These general rules have always provided us the best...

SSRS wouldnt be the tool for this unless you had a report setup on a subscription which exported the report to a excel file stored on a file share daily.

You...

Personally I would put PAE switch in the boot.ini file so that Windows can assign more then 4GB of memory to the SQL process. I have never used a...

Generally AWE and PAE are used together to that Windows can assign more then 4GB of RAM to a single 32bit process.

As your over 12GB in the box I wouldnt...