SQL 2005 Upgrade complete! - Post installation tasks questions!

[Former Member]

Hi All

I have managed to upgrade our DEV and TST ECC6 systems to SQL2005 (from SQL2000) and so far all seems ok however I have a a few questions and checks I would like some help with. I have included my post installation tasks at the bottom of this post, so you know what I have done.

I have noticed that when I run SGEN I get a short dump LOAD_VERSION_LOST which I am not sure what this means.

If there is anything else I need to do or should do please let me know.

Thanks

Phil

<b>Post Installation Tasks</b>

<u>SQL Queries</u>

exec sp_configure 'show advanced options', 1

reconfigure with override

exec sp_configure 'max degree of parallelism', 1

reconfigure with override

exec sp_configure 'xp_cmdshell', 1

reconfigure with override

alter database <SID> set page_verify checksum

go

alter database <SID> set auto_create_statistics on

go

alter database <SID> set auto_update_statistics on

go

alter database <SID> set auto_update_statistics_async on

go

dbcc updateusage ('<SID>')

go

exec sp_updatestats

go

<u>SAP Tasks</u>

Check SM21/SM50/DB02/ST04/ST22/SICK for any unusual error messages.

[Former Member]

SP12- Delete old TemSE.

Ensure in SQL server that the value min server memory and max server memory is same. SAP recommended that memory setting is FIXED. Regarding the LOAD_VERSION_LOST that you get during SGEN running, you can ignore dumps since it's normal when the dumps appeared while SGEN running.

Thanks and REgards

**Poinst reward is appreciated

[Former Member]

What os the SP12- Delete old TemSE?

[Former Member]

Any OS...

[Former Member]

Hello,

I want run the below script on SQL 2005, can anyone tell me how I run it in SQL 2005?

exec sp_configure 'xp_cmdshell', 1

reconfigure with override

I need to enable xp_cmdshell in sql 2005

Reg,

SAT