Regarding OPTION 2 below:

1) Run the Wizard to convert the DTS to SSIS (I tried several and got no errors)

2) Run the existing 2000 DTS packages via SSIS

3) Rewrite the...

Based on this Microsoft KB: http://support.microsoft.com/kb/260414

In fact, you MUST specify a UNIQUE SQL Server Virtual Server name ---

6Q: Can I have multiple instances of SQL Server for a...

Yeah -- turns out CD 1 is your SERVER; CD 2 is your TOOLS

2 DIR's created (SERVER, TOOLS) but will not fit on 1 700MB CD -- so you have...

Are you saying it's OK to overlay FILE123 on CD1 w/ FILE123 on CD2 into a single, target directory --- then burn to DVD?

Yes - typo. I meant to type SQL 2000 SP4

Yep - found this out the hard way. Using Cluster Administrator, I initially took some of the objects offline -- and the Uninstall failed (gracefully).

I brought everything back...

Sorry -- didn't see any reply w/ your feedback.. Any thoughts?

Jack - EMC recommended we issue CHECKPOINTs to help resolve an EMC Timefinder Freeze/Thaw/Backup (clone) failure we're intermittently encountering on our symmetrix SAN which retains our SQL Server 2000/2005 files.

Lowell -- EXACTLY what I needed!

select replace(convert(varchar,getdate(),112) + convert(varchar,getdate(),114),':','')

Thanks a million..

Let me answer myself (after some digging in this forum):

If you have update access to the database behind Reporting Services and know the names of all the objects you want...

G2 - thx. Very helpful!

Think I figured this out. this DB has just 2 databases on it. I had the SQL Trace filter set ON:

EXEC sp_trace_setfilter @TraceID, 3, 1, 0, 7 ...

In SQL 2000, I accomplished this by:

/* SQL 2000 STOP & CLEAR Here: */

-- Stop a TRACE:

DECLARE @TraceId int

SELECT * INTO #TempTrace FROM :: fn_trace_getinfo(default)

SELECT @TraceID = (SELECT...

thx Ian -- exactly what I was looking for..

From the SSRS home screen, I've created an RS role 'EVERYONE' which allows Browser access (May view folders, reports and subscribe to reports.)

Does SSRS 2005 mandate that everyone accessing a...