The original database was SQL server 2005 and now it is moved and it SQL server 2000. I found one issue were I have to set up the identity fields again as they are there but not set to increment etc. I also have to make them primary keys again as well. I have doen this successfully when I duplicated the database on the SQL serer 2005 machine. On this one I got to set the primary key and I get:
'users' table - Unable to create index 'PK_users'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '38'. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'users' has been created but its maximum row size (45973) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. I can look at the column and there are no duplicates. And this new error: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'users' has been created but its maximum row size (45973) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. First time I have seen this one. Is this a limitation of Sql Server 2000? Thanks. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dean Fiala Sent: Friday, July 15, 2005 8:55 AM To: [email protected] Subject: Re: [AspNetAnyQuestionIsOk] 'C:\WINDOWS\TEMP\': Access is denied. SOLVED - NEW PROBLEM DUPLICATES I'd check the database first and make sure you don't have any duplicate records. If you migrated, you might have accidentally created dupes. Then check the stored proc and make sure it is working as expected in query analyzer. On 7/15/05, Mike Belcher <[EMAIL PROTECTED]> wrote: > Well after I had gave the permissions and all that I guess I needed to > reboot as when I did that now it works. Now I have all the sites running > etc........ I have another very strange problem. The original machine was > windows 2003 32bit using sql server 2005 and visual studio 2003....... I had > 1.1 and 2.0 framework on that machine all this has be duplicated on the new > machine except now it is > > windows 2003 64bit > sql server 2000 > visual studio.net 2003 > 1.1 framework > > > the problem: > It all works fine except now when I use the site and say an example I will > search users and now the results show two of each........... 2 joes and two > jeffs and so on. This happens on any page. I can go to an inbox and there > are two of each message. This is the last problem to solve. What could it > be???????????????? > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Dean Fiala > Sent: Thursday, July 14, 2005 10:34 PM > To: [email protected] > Subject: Re: [AspNetAnyQuestionIsOk] 'C:\WINDOWS\TEMP\': Access is denied. > SOLVED > > How? > > On 7/14/05, Mike Belcher > <[EMAIL PROTECTED]> wrote: > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Belcher > > Sent: Thursday, July 14, 2005 9:41 PM > > To: [email protected] > > Subject: [AspNetAnyQuestionIsOk] 'C:\WINDOWS\TEMP\': Access is denied. > > > > Okay I have read about network service account and full rights etc.. I > gave > > it full control. I gave just about all accounts full control to that temp > > directory and I still get this error. I do no that if I right click and do > > properties on the temp folder that READ ONLY is checked and I can UNCHECK > it > > ten thousand 45 times and it will still come back checked the next time I > do > > properties. Can anyone help..... > > > > > > Misha! > > sir Charles! > > Dean!!!!!! > > > > anyone else........ spent hours on this machine to day to get this far to > be > > with this problem now.................... > > > > > > > > > > Compilation Error > > Description: An error occurred during the compilation of a resource > required > > to service this request. Please review the following specific error > details > > and modify your source code appropriately. > > > > Compiler Error Message: BC30138: Unable to create temp file in path > > 'C:\WINDOWS\TEMP\': Access is denied. > > > > Source Error: > > > > > > > > [No relevant source lines] > > > > > > Source File: vbc : Line: 0 > > > > > > > > Show Detailed Compiler Output: > > > > > > C:\WINDOWS\SysWOW64\inetsrv> > > "c:\windows\microsoft.net\framework\v1.1.4322\vbc.exe" /t:library > > /utf8output > > > /R:"c:\windows\assembly\gac\system.web\1.0.5000.0__b03f5f7f11d50a3a\system.w > > eb.dll" > > > /R:"c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll" > > > /R:"c:\windows\assembly\gac\system.web.services\1.0.5000.0__b03f5f7f11d50a3a > > \system.web.services.dll" > > /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net > > > files\citimatchdevelopment\556e71e8\59c1fa7c\assembly\dl2\3727dd84\3449c5a5_ > > db88c501\citimatch.dll" > > > /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.x > > ml.dll" > > > /R:"c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\syst > > em.drawing.dll" > > > /R:"c:\windows\assembly\gac\system.web.mobile\1.0.5000.0__b03f5f7f11d50a3a\s > > ystem.web.mobile.dll" > > > /R:"c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system. > > data.dll" > > > /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.5000.0__b03f5f7f11 > > d50a3a\system.enterpriseservices.dll" > > /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET > > Files\citimatchdevelopment\556e71e8\59c1fa7c\9t7cdfqa.dll" /debug- > > "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET > > Files\citimatchdevelopment\556e71e8\59c1fa7c\9t7cdfqa.0.vb" > > > > > > Microsoft (R) Visual Basic .NET Compiler version 7.10.3052.4 > > for Microsoft (R) .NET Framework version 1.1.4322.573 > > Copyright (C) Microsoft Corporation 1987-2002. All rights reserved. > > > > vbc : error BC30138: Unable to create temp file in path > 'C:\WINDOWS\TEMP\': > > Access is denied. > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > -- > Dean Fiala > Very Practical Software, Inc > http://www.vpsw.com > > > > Yahoo! Groups Links > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
