Adam Cogan www.ssw.com.au
AdamCogan at ssw.com.au
Wed Nov 5 18:04:31 CST 2003
Arthur Not sure if you want to use a 3rd Party utility, but we have used Speed Ferret - a Find and Replace thing many times. It is from a company called Moshannon - more info at <http://www.ssw.com.au/SSW/Standards/DeveloperGeneral/TheBest3rdPartyToo ls2.aspx#SpeedFerret> http://www.ssw.com.au/SSW/Standards/DeveloperGeneral/TheBest3rdPartyTool s2.aspx#SpeedFerret Adam <http://www.ssw.com.au/> www.ssw.com.au -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, 6 October 2003 1:14 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]Changing a Column Name Globally Suppose I want to change a column name globally (i.e. in every table, every sproc, every view and every UDF). Is there a concise way of doing it? SalesID -> SaleNumber. TIA, Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, October 05, 2003 3:43 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Question about Computed Columns On 5 Oct 2003 at 15:25, Stephen Hait wrote: > Computed columns, maybe? > > > When what was introduced to SQL > > That's the trouble with relying on the subject to contain part of your message. I (plus, I suspect, many others - including Paul) just flick through their list messages without even looking at the Subject header. It's actually quite annoying to have to look up at the subject to get the sense of the message when you are skipping through them. Could I ask nicely that people put all the relevant content in the body? Please? -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com