Re: object can't be accessed unless owner is specified - SQL 2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 16 Jul 2009 20:55:37 +0000 (UTC)
THE.Ronald (THERonald@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks for all your input. I think you're alluding to the user / login
orphan problem ? But this was restored to the same exact server,
overlaying the exsting database.
But using a third-party software? Which maybe first drops the existing
database...
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: THE.Ronald
- Re: object can't be accessed unless owner is specified - SQL 2000
- References:
- object can't be accessed unless owner is specified - SQL 2000
- From: THE.Ronald
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: Erland Sommarskog
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: THE.Ronald
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: Erland Sommarskog
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: THE.Ronald
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: Erland Sommarskog
- Re: object can't be accessed unless owner is specified - SQL 2000
- From: THE.Ronald
- object can't be accessed unless owner is specified - SQL 2000
- Prev by Date: Re: Cross DB ownership chaining (SQL2005 SP3)
- Next by Date: Re: object can't be accessed unless owner is specified - SQL 2000
- Previous by thread: Re: object can't be accessed unless owner is specified - SQL 2000
- Next by thread: Re: object can't be accessed unless owner is specified - SQL 2000
- Index(es):
Relevant Pages
|
