Wrox Programmer Forums
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 7th, 2007, 03:53 AM
Registered User
Join Date: Aug 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default change table to dbo

when i'm trying to run my page i got an error saying invalid object .
I found out that that error crept in because my table is not a dbo table ..
Can someone help me by telling how can i change a table with the database name to dbo table .....
Or should i create all tables ....
if i create a table on the server i get dbo one only...
But if i import tables from local to server then i'm not getting dbo tables...
can someone please help

Old August 7th, 2007, 07:41 AM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

Log into Enterprise Manager and right click on the table and select properties and change the user to dbo.

When you import your tables make sure that your CREATE statements create the table as:

CREATE TABLE [dbo].[tableName]

Otherwise the user you use to connect to SQL will become the owner, not dbo.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Similar Threads
Thread Thread Starter Forum Replies Last Post
valid dbo; permission to impersonate dbo est BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 5 February 21st, 2007 04:44 AM
Mark change in a table stealthdevil Access VBA 3 October 23rd, 2006 10:40 AM
how to change owner instead of DBO beetle_jaipur SQL Server 2000 1 April 6th, 2006 08:44 AM
Problem with insert new row in *.dbo table dimeanel Pro VB.NET 2002/2003 1 January 23rd, 2006 12:05 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.