Table Rename

2006-09-20 Thread Sam Roach
Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. CFQUERY NAME=ALTER_TABLE DATASOURCE=#database# sp_rename '#old_tablename#', '#new_tablename#' /CFQUERY I am receiving this error. Error Executing

Re: Table Rename

2006-09-20 Thread Charlie Griefer
cfquery datasource=#database# ALTER TABLE #old_tablename# RENAME TO #new_tablename# /cfquery On 9/20/06, Sam Roach [EMAIL PROTECTED] wrote: Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. CFQUERY

RE: Table Rename

2006-09-20 Thread Adkins, Randy
That sounds like a connectivity issue rather than syntax. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:36 PM To: CF-Talk Subject: Table Rename Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005

RE: Table Rename

2006-09-20 Thread Sam Roach
: Table Rename That sounds like a connectivity issue rather than syntax. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:36 PM To: CF-Talk Subject: Table Rename Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL