[windows2000] Re: SQL Server Logins
- From: "Ray at work" <listray@xxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 17:13:29 -0400
Hi Andrew,
Try:
USE nameOfDatabase
EXEC sp_changedbowner 'TheLoginNameHere'
Ray at work
> -----Original Message-----
> From: windows2000-bounce@xxxxxxxxxxxxx
> [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Dogers
> Okay, after much to-ing and fro-ing, the messing about of our SQL
> server is almost complete :)
>
> Only one problem left now - the dbo user currently doesnt have a login
> assigned to it and I cant see how. The other user on the database i
> deleted and remade happily, but SQL server wont let me delete dbo for
> obvious reasons! :)
>
> Is there a way I can assign a login name to dbo?
********************************************************
This Weeks Sponsor StressedPuppy.com Games
Feeling stressed out? Check out our games to
relieve your stress.
http://www.StressedPuppy.com
********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
