Personally I would leave it as Windows, but once you have deployed the data source, change it to use a specific windows account, that has a stupid password that way...

If you can afford it this is supposed to be a good one http://www.amazon.co.uk/70-443-70-450-Microsoft-Optimization-Infrastructure/dp/0470183748/ref=sr_1_4?ie=UTF8&qid=1336034065&sr=8-4 granted its for the MCITP but the majority of the concepts would be the same.

I'm waiting...

depends how you setup the data source which links the report to the data.

if its set at windows authentication then yes they could bypass SSRS and use Excel if they...

the account need db_backupoperator in the database level roles or follow this link to grant the nessesary rights http://msdn.microsoft.com/en-us/library/ms178569%28v=sql.100%29.aspx

Do you have any links to support what you have detailed here?

We have always used SQL to backup the databases for SharePoint, granted yes that the crawl data maybe out...

two user parameteres in @StartDate and @EndDate

two parameters to store min and max date in the table @MinDate and @MaxDate

select the min and max date from the table

SELECT @MinDate =...

It's not bad. I found with it that around 70% of it was basic enough to give the understanding but that it was lacking a bit of meat on...

are you sure its SQL thats causing the growth?

get something like TreeSize or WinDirStat to see where all the space is used and see if you can delete anything.

Thanks Peter, I have ordered that book just waiting for it to turn up, knowing my luck it will get delivered when I'm not in and I will have to...

the only limitation on rows is the amount of storage you have on the disks the file(s) are on which hold the table

from doing a Google search it seems like its down to authentication where your SMTP server requires authentication. I would check your using the right username and password in...

you should have an RTO in place and if logshipping of the primary server fails you need to fix the problems within the RTO or bring the secondary database online,...

just a thought but do you need to send 20 messages in one session? could you not store the individual email

bodies in one table then at the end...

as vinu pointed out you will need to use alter table drop constraint and the drop index commands

please ensure that you know what the definition of these objects are before...

anything specific you want to know or just in general, google has a lot of good links based on your term