[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,


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.
To Unsubscribe, set digest or vacation
mode or view archives use the below link.


Other related posts: