Hello, I just migrated a web-app that was on a Windows 2003 Server/SQL Server 2005 to a new machine that has Windows 2008 Server/SQL Server 2005. I duplicated the settings from the 2003 server as best I could on the 2008 server(the new IIS is a lot different).
The web-app worked perfectly on the 2003 server. Everything works on the 2008 server except for a piece that queries the database to create a new table. Here is the error: ExecuteNonQuery: There is already an object named 'XMLtmpTable' in the database., IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XMLtmpTable]') AND type in (N'U')) CREATE TABLE XMLtmpTable(XmlId int IDENTITY(1,1), Vid varchar(255), nodeT int, IDtype varchar(20), nID bigint, nTitle varchar(3000), nText varchar (3000), qText varchar(3000), cText varchar(3000), pResponse varchar (3000), aFeedback varchar(3000), orderId int, qId varchar(150), cId varchar(150), DMid varchar(20)) The error seems obvious, but there is no object named 'XMLtmpTable' anywhere in the database. The strange thing is, if I copy the query into SQL Server Management Studio, it runs fine! It's only when it is run via the web-app where it fails. I've tried and tried and it never can get past this part. Is there anything I am missing? Thanks!
