question

vinnas avatar image
vinnas asked

Query on SQL Server 2000 DB Side-by-Side upgrade to SQL Server 2008.

I have queries on SQL Server Side-by-Side upgrade to SQL Server 2008. I ran the upgrade adviser and It reported following issues. whether these issue are required to be addressed while doing side-by-side upgrade. 1. These extended stored procedures will not work after upgrade because SQL Server will be unable to locate the DLLs. The DLLs listed below define extended stored procedures - xpSLS.dll - xpSLSImportStats.dll - xpLogShipping.dll These tables may hang if the size of the table is large in SQL Server 2008 ALTER TABLE in upgrade process can cause the activity to stop. - backupmediafamily - backupmediaset - backupset - restorefile - restorefilegroup - restorehistory Full-text search is currently enabled. Re-generate the full-text search index in SQL Server 2008. Full-Text search engine installed. Upgrade of Full-Text Engine for SQL Server 2008 require valid account name and password. Account name should be associated with a specific security group.
sql-server-2000
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.