If it helps I'm trying to install the Developer edition.

I don't want to go unnecessarily deep into the installer process to try to solve this. If there's some way...

So I found this article http://blogs.msdn.com/psssql/archive/2008/09/30/how-to-fix-your-sql-server-2008-setup-before-you-run-setup.aspx that I thought would fix the issue, but I applied the x64 SP1 and then the x86 CU1 for SP1 (there was no x64...

Has there been a real fix deployed for this problem yet?

If you experience this issue and delete the cache files, will it pick up where it left off or are you going to have a gap in the collection?

I'm also experiencing a similar issue. Anyone know how to fix this?

Thanks for all the input guys, I'll work with the customer and see what we can figure out.

- John

It's not housing the data files, just the backups. All of the errors are related to creation of backup files and restores (for log shipping).

That makes sense. Thank you for your help

I tried to delete this thread because it's in the 2005 forum, the question should really be in the 2000 forum but it doesn't seem to be deleting it properly.

I've built one of these for my company and it's very complex so I'm not going to post it here but here are some considerations to look for when gathering...

You should be able to create them without Integration Services installed but I believe if you want to deploy the package and schedule it, then you need integration services running.

I don't know what else you want..? I gave the old / new function code, the table creation code for a test case, and some insert statements to populate...

Okay, something's weird because I created a test case

create database test

go

USE test

go

CREATE TABLE MyTable (

MyID INT

,MySubID INT

,MyName VARCHAR(50)

)

INSERT INTO MyTable (MyID, MySubID, MyName) VALUES (10, 5, 'Name1')

INSERT INTO MyTable (MyID,...

I had to rename some things because this is code I'm working on for a client but here it is:

Working Code:

ALTER FUNCTION [dbo].[MyFunc] (

@MyId INT

)

RETURNS @t TABLE (

MyIDINT

,MySubIDINT

,MyNameVARCHAR(50)

,MyLevelINT

)

AS

BEGIN

DECLARE

@MySubIDINT

,@MyLevelINT

-- This is...

Oh, I just didn't include the declarations and assignments above in the code snippet. I have a whole proc that I was modifying and as part of the it...