1. made a copy of database with a new dbuser and new dbname
2. made a copy of website
changed settings in web.config.
Site runs fine, with exeptions
some functions in some configs say OldDatabase is not online any more even when I insert full name to database in the insert query, like
INSERT INTO [New_Database_Name].[dbo].[TableName]
I have tried copying config and creating a new one but this reference to old table persists.
trying to delete old user and old user schema from new database results in
Database 'Old Database name' cannot be opened because it is offline.
Then I tried to delete old user and old user schema from the new database
where I run into this..
Msg 3729, Level 16, State 1, Line 4
Cannot drop schema 'Old User Name' because it is being referenced by object 'OWS_SiteUrls'
So conclusion I come to that somewhere there exist a OWS_SiteUrls that reference the Old Database.
My knowledge is limited, so is my brain. what can I do ?