Re: Table Rename

2006-09-20 Thread Charlie Griefer 

 ALTER TABLE #old_tablename#
 RENAME TO #new_tablename#


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.
>
> 
> sp_rename '#old_tablename#', '#new_tablename#'
> 
>
> I am receiving this error.
>
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection
> refused: connect
>
> Thanks,
> -- Sam
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253641
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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.

Here is what I am trying.


sp_rename '#old_tablename#', '#new_tablename#'


I am receiving this error.

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection
refused: connect  
  
Thanks,
-- Sam





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253643
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Table Rename

2006-09-20 Thread Sam Roach 
You were correct; I recreated the datasource and all works fine now. Guess
I've spent to much time looking at this computer screen. Thanks.

-- Sam


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 20, 2006 10:42 AM
To: CF-Talk
Subject: RE: 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 Server 2005.

Here is what I am trying.


sp_rename '#old_tablename#', '#new_tablename#'


I am receiving this error.

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection
refused: connect  
  
Thanks,
-- Sam







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4