create one in your project in BIDS or create on in the SSRS web page

I've just run the script and it executes and shows the foreign keys under the table ok.

What permissions do you have to the databases, SA? dbo? ddladmin?

Can you see the...

DBCC CHECKDB MSDN

Depends!!!!

DBCC CHECKDB creates an internal...

Point 4,

Out of the three jobs, you would only need to stop the backup job as the copy and restore wont do anything should the backup not be in...

DBCC CHECKDB doesnt require downtime, what it will do is put the databases into a consistant state by rolling forward or back any transactions so that it can check for...

Not a problem, hope you have fun with SSIS

+1 for DBMail, why re-invent the wheel when its already there for you.

Reading through the MOAC book, its very limited in what it details in the actual couseware, I would say if you have a very basic knowledge of SQL and you...

I would say you have missed a step, I have just followed the steps and opened the packages and I see what the book says I should see.

I would go...

Lookup UPDATE in BOL or a search engine.

But basically you want to do a self join

UPDATE t1

SET t1.ID = LEFT(........t2.FilePath......)

FROM table t1

INNER JOIN

table t2

ON

t1.FilePath = t2.FilePath

skimming over the book, it seems that that part is trying to open the package you saved when running through the import export data wizard, you have done this and...

I would say you have opened the wrong solution, either the solutions do not match the book, or someone has modified the solutions.

Do you have the book CD and reading...

for example

Page 47 - Chapter 2 SQL Server Import and Export Wizard

Point 7 - In the control flow double click the preparation sql task

If you read the rest of the...

which book are you reading from?

There is no "Prepare SQL Task" it is "Execute SQL Task"