DTS Type should be copy objects and select next on the next screen where it says script fle directory. your local pc user must have write permissions to this folder. if you do not you will need to change this to a local folder that your user has write permissions to. you will get the
Microsoft OLE DB Provider for SQL Server error ‘80040e14’ Divide by zero error encountered. /includes/connection.asp, line 40 there is a query error or a value of zero in the database
Reference : http://msdn2.microsoft.com/en-us/library/bb264564.aspx Possible error Server Error in ‘/’ Application. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error
A SQL Server login Use a valid Windows login to connect to SQL Server. If you must continue to use a SQL Server login, you can change the security authentication mode in SQL Server to SQL Server and Windows. To do this, follow these steps: 1. Start Enterprise Manager. 2. Expand Microsoft SQL Servers, and
========== After some research I found this posted online , works like a charm, Do one thing, use the query below select ‘Exec sp_changeobjectowner ”’ + name + ”’, ”dbo”’ from sysobjects where xtype = ‘U’ and copy all the results and execute them in a query analyser and it will change the tables owner, some which ar already having
