I loved Brian's book

Did you guys expand the Job Step detail to see the more-detailed error?

Also, you can go into Maint. Plan and right-click on the plan, View History

That one shows detailed error...

I think SQL 2008 needs 3.5 SP1 RTM even

If you have Visual Studio 2008 installed, it wans VS2008 SP1 installed first as well

Let the SQL installer install whatever it needs...

Create a Subscription, then choose Email (instead of File Share)

note: Email option may not appear if you did not configure SMTP for your SSRS

Pick Email in the Dropdown [Delivered By]

Good question

I know if you deploy the report in SSRS (Reporting Service), you can then export to Excel

To do it in SSMS 2005, no clue

2 ways I can think of

1. Create a table manually, then

INSERT INTO @table

exec sp_fkeys XXX

2. sp_helptext sp_fkeys to find the source code

then customize the source code for your need

The requirement is a bit iffy

But using ROW_NUMBER (in SS2005), you can create a sequence of an Object/ID

e.g. group by ID, order by time = you have a trail of...

right-click on a Database, you'll see a "Report" menu item -> Standard Reports

Wow, so many negative opinions, I read it and just take away whatever I can, doesn't hurt me anyway

By the way, to continue on SP_MSforeachdb.... I know it's undocumented (maybe...

I don't think the order matters

You just install the Report Viewer/Explorer Web Parts into SharePoint and connect to SSRS2005 correctly

so I would install

1. SQL 2005, and SSRS

2. SharePoint, and Web...

GUID I would say not. NEWID()

Sequential...

I wonder, would a SELF JOIN and use DATEDIFF or <= operator work?

it would be more SET BASED

SELECT T1.user_id_num

FROM #temp T1

INNER JOIN #temp T2 ON DATEDIFF(hh, T1.insert_date DATETIME, T2.insert_date DATETIME)...

Small companies often don't required/consider DRP or off-site backup

My recommendation is

1. Backup locally (keep a week's rotation for example)

2. Either scheduled task with RoboCopy (or DOS commands), or even...

You are getting into the "Datawarehouse" concept

and yes I agree, usually needs custom solutions (either via SSIS, BCP, etc...)

or is it possible, just take DIFFERENTIAL backups on Production

then restore them...

I know my SSMS 2005 SP2 (9.0.3042) can't connect to SQL Server 2008 database

It's good to know your 9.0.3282 (CU9) can

SQL Server 2005 Build List[/url]