Yeah..it can be a real pain especially for Stored Procedures and certain UDF instances but I have a few scripts which correctly generate them for you.
Most generic users of SQL Server don't use complex object models they simply create a database under SA conditions and run it as DBO owner...(not good)..in this instance you wont have much problems... N -----Original Message----- From: Steve Powell [mailto:[EMAIL PROTECTED] Sent: 06 July 2004 15:00 To: [EMAIL PROTECTED] Cc: Steve Powell Subject: RE: [ cf-dev ] SOT - SQL That's a fair point that I had overlooked. You do have to have the same users with the same passwords at both ends. Particularly the dbo and any users for the tables. You also need the smae roles. See that's easy in my case because of the security framework we use. Users are based on the db name and permissions. regards Steve Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote : > NOTE: Attach / Detatch can have issues with object security & named > instances depending on setup. > > > > > > -----Original Message----- > From: Steve Powell [mailto:[EMAIL PROTECTED] > > Sent: 06 July 2004 13:16 > To: [EMAIL PROTECTED] > Cc: Steve Powell > Subject: RE: [ cf-dev ] SOT - SQL > > When you moved your data in SQL Server. You exported tables which doesn't > copy the IDENTITY column settings over. The ID column will not have an > identity, seed or increment set it will also not be set as the primary key. > > When you move data from one DB to the another you need to Copy Objects not > copy tables. That way the constraints, defaults and such get copied as well. > > You do need admin permissions on both DB's to do this which is why copying > tables is easier. > > You will have to reset the IDENTITY COLUMN values by hand based on the MAX > current ID. Or strip the table sout and export them again. > > A simpler solution can be to detach the DB. Copy the MDF and LDF files and > re-attach the files at both ends. That way you get an exact copy of the DB. > > regards > > Steve > > > Alistair Davidson &lang=en">[EMAIL PROTECTED]> > wrote : > > > Is report_id set as the identity column in your old server? Make sure > > it's still set as identity in the new one. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > > > Sent: 06 July 2004 11:35 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] SOT - SQL > > > > I have just moved an SQL database from one server to another. I have > > setup > > all of the connections in MX administrator all OK and everything worked > > fine. > > However the backend admin system is another story :( > > > > I am trying to add data to the database and get the following error. > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value > > NULL into column > > 'Report_ID', table 'schools_performance.dbo.Report_Names'; column does > > not allow nulls. > > INSERT fails. > > > > The data trying to be inserted according to the error page is ... > > > > INSERT INTO Report_Names (report_name, path_name, Doc_Type_ID) VALUES > > ('summer reports', 'summer', '3') > > SELECT @@IDENTITY AS 'last_record_ID' > > DATASOURCE WebUserDSN > > > > I still have the database & code on the old server and all works fine > > there. > > > > I imported the data from the old server to the new server. All appears > > to be the same .... > > > > Any ideas? > > > > Regards - Paul > > > > > > > > > > ************************************************************************ > > ************************* > > The information contained within this e-mail (and any attachment) sent > > by Birmingham City Council is confidential and may be legally > > privileged. It is intended only for the named recipient or entity to > > whom it is addressed. If you are not the intended recipient please > > accept our apologies and notify the sender immediately, or telephone > > +(44) 121 303 6666. Unauthorised access, use, disclosure, storage or > > copying is not permitted and may be unlawful. Any e-mail including its > > content may be monitored and used by Birmingham City Council for reasons > > of security and for monitoring internal compliance with the office > > policy on staff use. E-mail blocking software may also be used. Any > > views or opinions presented are solely those of the originator and do > > not necessarily represent those of Birmingham City Council. We cannot > > guarantee that this message or any attachment is virus free or has not > > been intercepted and amended. > > ************************************************************************ > > ************************* > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > > provided by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by > > activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > Steve Powell > [EMAIL PROTECTED] > 07971 583792 > > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended recipient(s) please note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or call > our switchboard on +44 (0) 20 89107910. The opinions expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by > activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] Steve Powell [EMAIL PROTECTED] 07971 583792 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
