Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:46:52
|
| Frank writes "I believe I was able to copy objects from a unique sql7 server over to a unique sql 2k server via network. The stored procedures and views work via Ent.Mgr or Query Analyzer. But i'm not sure that it's a valid database.The problem i'm having is an SMS-Server is not working with the converted db. Am i missing something? Is there an unknown problem I'm unaware of? The Copy/Move did not work. So I used DTS move objects, and set options not to copy logins. DTS was not perfect as well so i copied the objects that would work via DTS, and created the others. After I got the databases to look somewhat the same i exec sp_updatestats. The difference from the two db's are views that are owned by INFORMATION_SCHEMA of Type SYSTEM. I was unable to recreate these views. Are they necessary?Is there a list of things I should look for on the converted db?SQL 2000 Std SP 3 on a Win 2000 Adv. Serv box. Name = SQLSQL 7.0 Std SP 3 on a Win 2000 Adv. Serv box. Name = UTILITYAny suggestion would be appreciated. help!" |
|
|
|
|
|
Conversion of SQL 7.0 to SQL 2000