Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2005
Search options not deleted
user 2137
SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.
10
votes
Accepted
One of the Database Ownerhas been Removed and corresponding property changes in sql server
You have to change the ownership of each database that that user owns before you can delete the user.
Change ownership using SSMS or you can use T-SQL
use database_name
EXEC sp_changedbowner 'newo …
- 316