That is exactly my problem. 

I wound up writing a second query and a second RS dataset that totaled what I needed.  BUT, that means that I have to be very...

The data I'm using repeats in_stock_cost for all the detail rows for a part.  So a strait sum gives me the wrong value because it adds this value for every...

Snapshot to me meant a replication snapshot.  Question doesn't give enough information.

I never thought of creating one folder for report 'deploys' and then moving them after with report manager.  Manageing the multiple locations to deploy to from the projects was one of...

I have installed on default instances and on some that use transactional read only replication (subscribers only so -far) and have not had any issues.  I do not have multiple instances...

Then why does the SQL2K SP4 say there is an update to SQL2K Books Online? 

OH,...  I guess they mean IF there is an update you will find it at...

My understanding is that SQL stores the actual key of the clustered index as the lookup for the record in all non clustered indexes when a clustered index is present...

I think there are cases where you would not want indexes and I'm stuck on a couple choices.  So I'm throwing out a question for other perspectives. 

If you have...

Is it possible to add a non meaningfull PK that is created using a default?  Just add a column of type uniqueidentifier and set it's default to newid().  Make this...

One more point, I don't think this would affect you since you say the account was a global admin, but the job owner has to have rights to create any log...

I've seen the same thing and with replication jobs.  Just last week I had a transaction log backup job that was created via a maintenance plan fail under a user account...

I'm no Reporting Services expert as I have just started in the last couple months getting my first production server up and running.  But I have had a similar kind...

What's your error?

Agree, the main reason for using maintenance plans is the ease of use for things like new databases getting backed up automatically when all user databases are picked and the...

If you want to use Maintenance plans - create two - one for system database one for user databases.  Change your PUBS and Northwind if you have them to Full. ...