Forums

This topic is locked

SQL Database Problem

Posted 01 May 2007 10:59:52
1
has voted
01 May 2007 10:59:52 Ian Bateman posted:
I have just moved my SQL database to a server with another host. All my database tables are now showing in Dreamweaver with the user id in front of the table name. So now tbl_Customers is showing as TonyGrey.tbl_Customers.

How do I get it back to where it was? I don't relish the prospect of re-coding all my pages ... Help

Ian

Replies

Replied 07 May 2007 23:31:14
07 May 2007 23:31:14 Lee Diggins replied:
Hi Ian

Can you make TonyGrey user the dbo for the database? Not sure if this will fix the problem for you, you might have to do a replace tbl_ TonyBrey.tbl_ in your pages.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Reply to this topic