February 14, 2011 at 12:59 pm
I'm trying to run this sql statement.
ALTER AUTHORIZATION ON DATABASE::myDatabase TO sa
But it just keep going it doesn't finish executing.
The SQL service are running.
I'm trying to assign a owner to my database so I can build a DB Diagram.
I've also tried to set it DB properties inside File pages but its saids: "Set owner failed to database MyDatabase"
February 17, 2011 at 8:20 am
no answer 🙁
February 17, 2011 at 9:42 am
I didnt understand exactly what you are looking for.Can you breifley expalin ? what is the result you are getting? Is something like an error or what?
February 17, 2011 at 9:46 am
When I try to change the owner using the sql statement alter authorization y doesn't give any result, neither positive or negative. I just keep executing.
The database service is running. I don't know If i need to stop the service, so I can change the Database owner. I has take arroung ~10min or more, it just doesn't finish.
February 17, 2011 at 12:10 pm
- Is there any other connection connected to your database ?
- is there any blocking going on for that database ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply