Hi. I used the database publishing wizard to script a database I had on a SQL 2000 server. I then opened up SQL Management Studio 2008 and opened up that script as a New Query. I connect to my database on Winhost and then try to run the script but I get an error that says: Failed to start debugger. Additional Information: The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) If I look at my Tables on my database there is a System Tables folder but no tables exist underneath. I thought these came when I created the database? _________________________ jjjeney
Try looking at this kb article for restoring your database to our server. You will need to run the backup sequence on your SQL 20000 server and use the .bak file to restore it to our SQL 2008 server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
