SP failed during upgradation...

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric,

I have two questions for you.

1. SP (SQL 6.5) which has coding like below failed to upgrade. How should I recode the follwoing in order to upgrade successfully.

BEGIN

select @dump_date = (select dumptrdate from master ..sysdatabases where name = 'oest') if (@@ERROR <> 0) BEGIN RAISERROR ('Unable to obtain dumptrdate for dateabase on @@SERVERNAME', 19,1) WITH LOG END

END

2. Can a SQL 6.5 connect to SQL 7.0?

Thanks in advance.

Kothan.

-- Anonymous, April 19, 2000

Answers

Kothan,

1. The dumptrdate does not exist in the 7.0 version of the master..sysdatabases table.

2. Yes.

Hope this helps,

Eric

-- Anonymous, April 19, 2000


Eric,

Thanks very much.

Kothan.

-- Anonymous, April 19, 2000


Moderation questions? read the FAQ