Hi Steve, Tried that - it scripts them okay, but bums out after about 5% of copying them.
Haven't used MS-SQL for years and now remembering why!! :o) R -----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 16:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views Import all entities as objects as opposed to "copy tables" > -----Original Message----- > From: Ross Williams [mailto:[EMAIL PROTECTED] > Sent: 28 November 2003 16:16 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] MS SQL Enterprise Manager - Importing Views > Importance: High > > > Hey hoo, > > Just getting back in with MS SQL Enterprise Manager - have run an > import from one live database to another and it's imported all of my > Views into the Tables. > > Has anyone come across this? I can see the Views in the Tables listing > when they should be in the Views listing. > > Does anyone know how to rectify this or import differently? > > Many thanks, > > Ross > > > ------------------------------------------------------- > RAWNET LIMITED - Internet, New Media and ebusiness Gurus > > Visit our new website at http://www.rawnet.com for more information > about our company, or call us anytime on 01344 393 040. > ------------------------------------------------------- > Ross Williams > Managing Director, Rawnet Limited > Direct Phone : +44 (0) 1344 393 440 > Switchboard : +44 (0) 1344 393 040 > ------------------------------------------------------- > This message may contain information which is legally privileged > and/or confidential. If you are not the intended recipient, you are > hereby notified that any unauthorised disclosure, copying, > distribution or use of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, information or > conclusions expressed in this message are those of the originator, not > of rawnet limited, unless otherwise explicitly and independently > indicated by an authorised representative of rawnet limited. > ------------------------------------------------------- > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For > human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
