glad its working for you.

also please take a look at this url http://www.sqlservercentral.com/articles/Best+Practices/61537/ it will be a good starting point on how to post the information that we need to...

do you only ever want the row for the largest sessionid and its corresponding transactionid where policystatus = 10 irrespective of the policy number?

or do you want the largest sessionid...

something like this?

declare @table table (policytransactionid int, policynumber int, sessionid int, policystatus int)

insert into @table VALUES (1,1234,1,10), (2,1234,5,10),(3,1234,9,10),(4,1234,10,3),(5,5678,89,10)

;with cte as

(

select

ROW_NUMBER() OVER (PARTITION BY PolicyNumber ORDER BY PolicyTransactionID DESC) AS RowNum,

policytransactionid,

policynumber,

sessionid,

policystatus

from

@table

where

policystatus...

server role - sysadmin

database role - db_owner or db_backupoperator

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...