you will need two sets of licences, as you need to licence the machines which run the services and as you will have two boxes with a SSRS service thats...

Size widely depends on what you store, how often you purge and the amount of indexes and other objects are within the database. I have prod DB's which range...

i dont have anything to hand, but I'm sure our good old friend google will help you out.

need to create the DSN which points to the MDB file then create...

if this is the only step in the batch you could just select @@rowcount, if not you will need to declare a varable and set that variable = @@rowcount at...

guessing its possible as you can create ODBC connection strings for the data sources, so aslong as you created and ODBC DSN which pointed to your access mdb shouldnt be...

you could use powershell and script out all the objects you require into one big script and run it on 2005, you could also script the entire database from 2008...

have you granted one of the db_dts.......... msdb roles to the user?

In tests that I have done, 32bit server >=4GB RAM <=12GB RAM need /3GB and /PAE, servers >12GB RAM only need /PAE

These general rules have always provided us the best...

SSRS wouldnt be the tool for this unless you had a report setup on a subscription which exported the report to a excel file stored on a file share daily.

You...

Personally I would put PAE switch in the boot.ini file so that Windows can assign more then 4GB of memory to the SQL process. I have never used a...

Generally AWE and PAE are used together to that Windows can assign more then 4GB of RAM to a single 32bit process.

As your over 12GB in the box I wouldnt...

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