IMO you should not do this. If you have separate LUNs you can separate your logs from your data, and from tempDB. You could move the individual LUNs to...

are you saying you want to share one large LUN between multiple servers? If so, I don't think you can present the same LUN to multiple windows servers. ...

You could spread data files across the 'drives' and not join them together. Just add data files to your existing filegroup(s) and place them on the separate drives.

So the cover does not fall into the hole

WROX "SQL Server 2000 DTS.  Excellent examples. 

I like the web.config, nice suggestion...

On your Page that has the viewer put something like this in the page_load event (param is optional):

Private Sub Page_Load(

Couldn't you just setup a few windows groups (user reporting roles) and assign them permissions to various reports/folders in RM.  Then let windows authentication do the work for you? 

I think you are describing the URL method of integrating, which is what I use.  You can also use the SOAP method, but I am not familiar with that. 

The sample was not showing hidden when I would go through the "Edit Group" route, so this was how I setup my report.  But when I went into the XML,...

1. Create a table in your database that could have as few as 2 columns (user_id, session_id).  The session_id will be used to manage concurrency (i.e More than 1 user trying to...

You don't have wait for a job to run.  You can initiate the job by for example executing the sp_start_job proc from a Web Page.  Another solution we use is...

If you use the MS Query functionality in Excel you will lose the scheduling capabilities of DTS.

You could use tijoj method of determining the columns within the ActiveX script I...

Could you write the user IDs to a table in your DB.  Then change the Reporting Stored Procedure to join to that table. 

Then you don't have to pass a...

Excel is similiar to most OLE DB data source and so you can manipulate the destination fairly easily.  I would use an Execute SQL task to DROP the existing table...

The procedure I'm calling is supposed to return a recordset. 

I pass in 3 input parameters and want to receive the recordset and use it for the source of my...