In this case I usually:

1. start SQL server in single user mode

2. Restore system dbs from command line

3. Restart SQL Server in multi user mode

4. Open SSMS

5. Restore Full...

Definitely store the images on a file system and the path to the images in the db, it's much more modular that way, and you can send emails with links...

Unfortunately I ended up doing an total reinstall and restore, at least it works now.

Thanks,

jim

Thanks Deepak,

I really appreciate your help!

I got a can't connect error message, I'm sorry as I don't remember the exact wording, but it was definitely a can't connect to the SQL Server instance type of...

I use stored procedures to move my files around with my SQL Servers.

They look something like

CREATE PROCEDURE [dbo].[msp_copy_Server_SQL_Full_Daily_Backups]

AS

DECLARE @command varchar(100)

DECLARE @location varchar(30)

DECLARE @destination varchar(41)

DECLARE @switches varchar(6)

DECLARE @day char(9)

SET @day =...

Un-installed SQL Server, re-installed SQL Server, restored from backup. It's back...

Since MS is having such a time patching SQL Server 2005 and we have had 0 problems...

I figured out how to answer my own question...

SSIS was not unistalled as I can still connect to the instance of SSIS through SSMS and the version is...

They "Didn't touch anything SQL Server", until I found the Event Log entries for installing the previously mentioned GDR 1406 hot fixes. Thus the GDR's must have been included...

Have you upgraded your tools to SP2? I imagine you have, but it's worth a shot.

I found this error message in the Event Logs:

Product: Microsoft SQL Server 2005 Integration Services -- Error 29549. Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the...

I get 0 rows returned when I execute

SELECT * FROM msdb.dbo.syssubsystems where subsystem = 'SSIS'

The server is not part of a cluster, and the databases can be queried.

The databases...

For Future Reference you can find the download for Analysis Services OLEDB provider at the following url:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

You'll be looking for Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider,...

We use Excel. You also have to install the Analysis Services 9.0 OLEDB provider on the client machine to query a SSAS 2005 cube or Analysis Services 8.0 OLEDB...

Thank you very much. That explained the url very nicely.

jim