Hi everyone. I've been trying to figure out why I've been receving all the email. I didn't realize that I Google Chat Group DUH [?]. It must have been one of my many sleepless nights do to medicle disabilities.
I clicked on "Reply" and this page came up. Most messages that appear here are over my head although I've been playing with PC's for over 30+ years. My Son built me this PC. He has a position with Microsoft. He graduated with his MCS Degree in software development. Now, I know where I'm at (Computer Chat Room)[?]).For the past few weeks I've been marking this site as spam. How do I cut back the amount of this groups site. Thanks Terry On Mon, Apr 20, 2009 at 8:28 AM, cmt <[email protected]> wrote: > > 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!
<<inline: 32A.png>>
<<inline: B05.gif>>
