I've written some T-SQL that more or less does the same thing.

I use msdb.dbo.backupmediafamily joined with msdb.dbo.backupset as the basis for my code..

The 'type' column in backupset will tell you...

Sounds like you have a case of orphaned users. Take a look through books online at the orphaned user topic, see if that helps you out.

I was able to address the problem I was having, but not resolve the growth issue.

I added a second physical file to tempdb, and was able to confirm that the...

I also tried changing the default size of tempdb, restarting SQL, and it did not take the new size. Also, a restart of the complete server had no impact.

When I...

It appears to not be set. Here is sp_helpdb for the tempdb database:

tempdev 1 f:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf PRIMARY14144 KB Unlimited10%data only

templog 2 f:\Program Files\Microsoft SQL Server\MSSQL\data\templog.ldf NULL4672 KB Unlimited10%log...

I find that most times I end up using a cursor, its because I'm doing something that would be better done via a regular program, like an emailer or some...

I have always used service.msc to change the accounts for SQL 2000. I don't believe its any more scientific than that - just make sure that account has permission in...

If you create a macro within a spreadsheet and call it 'auto_open' it will run each time it is opened, but that would depend on how your spreadsheet gets created.

But...

Ok, so I posted a little too soon:

For the server roles:

sp_helpsrvrolemember

And for the db roles:

sp_helprolemember

cheers, Mark

Firstly, check if you can run the report your subscribing to correctly as yourself, interactively.

Secondly, make sure SQL agent is running, and if so, check the SQL agent job...

Are there any events in the windows event log that correlate with this problem?

For the purposes of your exercise, I think that would be fine. It can be changed later if needed.

In real life situations, this is a pretty important step. Many people...

i'm a little confused by your reply. You said the services failed to install, however said the database engine installed correctly. I presume when you say 'Services' you mean 'Reporting...

Generally speaking, the installation wizard is pretty good at telling you what you're missing in the way of software/configurations. The various problems I have encountered during installs have usually fixed...

If I were you I would investigate the errors that occured during installation before going too much further.