The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
LifeAsBob
Wednesday, October 17, 2018
Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book
014.jpg
bob Links
JavaScript Examples
Oh, I have been to Ludlow fair and left my necktie God knows where, and carried halfway home, or near, Pints and quarts of Ludlow beer. - A. E. Housman
Wider View
Insert
Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
Temporary Database
Views
Backup
SQL Mail
DTS - Data Transformation Services
Memory
Security
Excel
Jobs SQL Agent
MSDE
Install
DBCC
User Management
System Databases
BCV
Deadlocks
Temp Tables
Find the physical se...
Enable xp_cmdshell
Intermittent Connect...
Connection String Pr...
Login Error ( State)...
Turn Default Tracing...
Re-index fails when ...
SMO AND DMO
Tracing of Errors
Extra carriage Retur...
Query to find Object...
Named Instance Port ...
Adding Domain Login ...
Rename Logical File ...
Error 3624 Delete st...
SQL DMO Error 21776
NetworkConnections
SQL Server Service m...
Trace Flags for Dead...
Change Server Name
Alternate to Count(*...
Windows OS
Insert Category
Will be added as a sub-category of, SQL Server
SQL DMO Error 21776
KB Article - 239133 SYMPTOMS When you run SQL Server Enterprise Manager wizards against objects owned by anyone other than yourself or the database owner (DBO), you may receive errors and the wizard may not complete successfully. Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Users collection. CAUSE The Enterprise Manager does not allow you to specify an owner. So, if you are not logged on as the object owner and the object is not owned by the DBO, the wizards will not find the object. WORKAROUND Use sp_changeobjectowner to change the owner of the table to the DBO, and then run the wizard again. Also see articles: KB 218172
bob Links