Session table does not exist as the required object name

Aaron_ESC

I have a Nav 4.0 SQL server option database at the client. I used the DTS wizard to copy all the objects and data from the database along with the user logins from the client's SQL server to the SQL server on my laptop. I am able to open the database in Navision on my Laptop but when I use the DTS wizard to copy from my laptop to the SQL server in my office and open the database there in Navision, I get this error "Session table does not exist as the required object name..." Anyone have any suggestions?

I've done a bit more looking and the missing object is apparently a view in the SQL server. Anyone know why the DTS didn't copy that?

Ok, this is the second edit. It appears that I've fixed the problem by scripting the views that didn't get copied. But I'm starting to think that using the DTS wizard isn't such a hot idea. Is using the SQL backup wizard any better?

DenSter

Using SQL Server for anything else than backing up is not a good idea. Use the Navision tools as much as possible.