OK. I screwed-up. SS2005. I gave a user ownership of schema "db_owner" and now I can not change it back to what it was (unknown) so I can delete the user. So how do I change ownership of "db_owner" back to what it was so I can delete the user???
Thanks,
Michael
Hi guys,
I'm trying to write a script that will check is a MemberName belongs to the Db_Owner role and if it doesn't I then want to add that membername to the role. Does anyone know how to do this?
I have managed to list the Db_Owner MemberNames by using the sp_helprolemember stored procedure, and I can use the following:
SP_addrolemember 'db_owner' , 'ASPNET'
to add the membername to the db_owner role, it's just conditional only do it if it doesn't exist that is causing me grief.
Many thanks,
Damien
Hi,
I have granted db_owner to a user id. This userid was able to take a database offline, but when trying to bring the database up online, I got an error message 5011, user doens't have permission. Does anyone has any idea why? I read in books on line saying that db_owner fixed roles has permssion to set this database property. Thanks.
How to find out which NT group(s) an user belongs to? any ideas?
View 4 Replies View Relatedwe do get incidents saying user can't login even adding to the group.So is there any script to check which group the user xxxxx belongs to from SSMS?
View 2 Replies View Related
How do I get a particular user to be a choice under the db_owner role for a particular database?
The user is listed under logins and even shows to be the db_owner for the database under the database access tab of the login properties. This is SQL 2000.
Thanks,
David P.
Hi all,
I'm kinda stuck with the following issue and would apreciate some help with it.
Basically i need to have a user within SQL that has rights to restore databases and is the owner of that database so it can alter the data. The problem i face is that at this moment i see no other way then making that user either member of the server role "sysadmin" or "serveradmin".
Anyway, these roles have to much rights. I tried using the dbcreator role which will make a the needed user db_owner but only when a new database is created, not when a database is restored.
Tried to resolve this with a DDL trigger and then temporarily run as a user with serveradmin rights, however there is no system event for restore database, so that doesn't work either.
Anybody got any suggestions?
I am using SharePoint Services 3.0 (SP1) with default configuration options, which installs the Microsoft##SSEE instance of SQL to my local C: drive.
While attempting to relocate the files to another drive, I set one of the databases (as recommended) to Single User by using the SQL Server Management Express tool.
I cannot now reset that database to Multi User, even by executing the query
exec sp_dboption 'database_name', 'single user', ''FALSE'
again by using the Management Express Tool.
Can someone please help, in plain english???? Thanks
I usually xfer or move 7.0 to 7.0 database via import/export objects in EM or via detach/attach database referenced to its physical files. But how can I xfer DB from 6.5 to 7.0 providing that I have db1.dat and db1log.dat from our only 6.5 server which has crashed & need rebuild?
Do I have to have 6.5 installed on my server to load up this DB? Is there any alternative from doing that?
Thanks in advance,
Koann
Hi,
We have to copy data from files from Novell system to Sql sever 2000. I use DTS for that. The problem is that Novell system files(the way they are extracted) has end of file character. Because of this the DTS package fails. But if we open the file, get rid of the end of file character (looks like square in wordpad), the package runs fine.
Is there any way to make DTS identify this character as end of file and ignore it? We have hundreds of files to move on regular basis and some of the files are large (> 10 MB) so that we cannot open it or see it.
Any suggestion will be appreciated.
Hi All,Would someone give me an explanation on how SQL 2000 server backs up auser database? Is SQL server make a copy of user database first, andthen backup it up to a defined backup device? Or is it going straightto the defined backup device.Thanks,Bob.
View 1 Replies View RelatedI have user called DBA_USER he has db_owner access on (123DB) database ....
But when ever my machine restarted the user was getting access error (i.e.. you don't have access on this database) and i checked his access on that particular database his access got reverted back ....
Here my question is why this particular user getting this type of error ....
hi everybody.
Scenario
Company X has Sql server and domain x.com
so
on sql server
they have logins
XA
XB
XC
Back of database Production was done
database Production was restored in Company Y
use Production
select name from sysusers
name
----
XA
XB
XC
sp_dropuser 'XA'
Server: Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12
User 'XA' does not exist in the current database.
How to drop 'XA' ?
Hey,
I have a function that executes a query and fill the result in a dataset then return the row as following :
Public Function get_item_row(ByVal query, ByVal ordernum, ByVal theitemid, ByVal center) As DataRow
Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("conn"))
Dim adbooks As New SqlDataAdapter
Dim Str As String
Dim result As New DataSet
Dim MyDataRow As DataRow
adbooks.SelectCommand = New SqlCommand
adbooks.SelectCommand.Connection = conn
Str = "select * from " & query & " where ordernum=" & ordernum & " and theitemid=" & theitemid & " and center='" & center & "'"
adbooks.SelectCommand.CommandText = Str
adbooks.Fill(result)
If (result.Tables(0).Rows.Count > 0) Then
MyDataRow = result.Tables(0).Rows(0)
Else
MyDataRow = Nothing
End If
Return MyDataRow
End Function
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
then i am calling that function as following:
Dim MyRow As DataRow
MyRow = b_list.get_item_row(query, theorder_b, theitemid_b, center)
then i am adding that row to a datatable:
Dim updateTable As New DataTable
updateTable.Rows.Add(MyRow)
and then i am gettin the error!
plz help
thx
Hiba
sorry for short subject, it allows very less characters, seems like varchar(50)
Hi,
My questions is...
How to identify an object using its objectid. In profiler and activity monitor we see objects like
1:12345
1:2345:453454
and so on...
I am sure they are not tables or indexes and I guess they are something related to pages, rowids etc.,
how do i interpret these objects (ids) and point back to the table (if it belongs to any table)
to summarize what I want
how to identify the type of object is being shown in profiler/activity monitor
how to identify to which table/index that object belongs/associated
where can i get object name for any object id that is shown in profiler/activity monitor. some time it shows some object ids in 100s of thousands for which i don't see any entry in sysobjects/sysindexes
Thanks in advance
Hi,
We are using Microsoft Sequence Clustering both "manually" via Visual Studio (SQL Server Business Intelligence Development Studio) and "programatically" via AMO and ADOMD.NET (using C#). We use AMO to build and process the MiningModel, and ADOMD.NET (Microsoft.AnalysisServices.AdomdClient) to browse through results.
Everything is working fine except for a very important detail: we can't find where the MiningModel stores cluster membership. The MiningModel.Content contains a column NODE_SUPPORT which shows how many sequences there are in each cluster, but we can't find which sequence belongs to which cluster.
In Visual Studio, the Microsoft Sequence Cluster Viewer is able to show this in Cluster Profiles (a right-click on a cluster followed by Show Legend lists the sequences that belong to that cluster).
Question is: where does the Viewer get this information, and how can we get it via ADOMD? Or via AMO, if that's the case?
Would appreciate your assistance.
Kind Regards,
Diogo
Using Management Studio, when i create a new table/stored proc., the owner is always dbo. How do I change this when I create it? Also how to transfer it to another schema once it has been created?
Dear guys,
Is there a way to determine which partition belongs to which Filegroup name?
Nabeel
I am getting following error:
"The log in this backup set terminates at LSN 9566000024284900001, which is too early to apply to the database. A more recent log backup that includes LSN 986000002731000001 can be restored."
If I am missing to restore previous log backup file, how to find which LSN mapped to which log backup file (.trn file name)? Another word looking at LSN can we tell which log backup file is missing?
Using TSQL, I have a table that holds filenames of Pictures for products. Different products can be using the same picture. I need to select the filenames for a single product only if it does not exists for a different product.I have tried Where Exists (select FileName From Tbl where
Prod_Id = @var) AND NOT EXISTS(select FileName From Tbl where
Prod_Id != @var) In the Select Statement.
I need a query to list the tables in SQL sever with respective database they belong across databases.
I can obtain list of tables from Sys.Tables / Sys.Objects Views but how do I correlate to which DB a table belongs to?
The Sys.Databases View list the databases with their respective Ids. But, the DBID is not part of Sys.Tables / Sys.Objects Views.
Which View will allow me to fetch database to table mappings?
Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick
View 5 Replies View RelatedNew to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.
When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?
I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.
View 4 Replies View Relatedwhen i try to create an ER diagram in VB Web Server Express it tells me that You do not have the required permissions..
What's up?
I have a stored procedure that I believe is not executing as the specific db in question has no owner(shows as "unknown"). What is the solution?
View 1 Replies View RelatedHi,
I have a database which contains 5 db_owner. If I need to remove two of them (they have left the company and are not being replaced) so db_changedowner is out of the question.
What is the proper way to do this?
Do I need to transfer their ownerships to one of the existing db_owner?
I recently registered my hosted database server on my pc. When I ran aspnet_regsql.exe the table created have dbo as schema, but when I create a news table throught stored procedure it has my username as schema.When I buildt my site on my pc all tables have dbo as schema.How do I make all tables on my hosted server db have same schema?Thanks The very Newbie
View 6 Replies View RelatedHi All,
Question:
Why would the user other than sa need the db_owner rights?
Hi,
I have a database which has two db_owner (dbo and a user).
The user has left the organization a while ago.
Can I remove him or do I need to replace him?
What will happen if I remove him?
Do I need to keep dbo there also?
is there a command that can change a login role to db_owner in all thetables, or do i have to use{USE table_nameEXEC sp_adduser 'login name'EXEC sp_addrolemember 'db_owner', 'login name'}for each of the tables ?thanks
View 1 Replies View RelatedIf I on a remote hosting server have db_owner rights, do I then also havedb_securityadmin and db_dlladmin rights?BRGS, TCHillII
View 1 Replies View RelatedIm duplicating a database by running the script below. This works fine. My only problem is that the dbo user does not by default have any role memberships in the new database hence no access. I have tried using sp_addrolemember but dbo is not a valid user for this procedure. Adding dbo to the db_owner role through the sql2005 MS works fine, but I would very much like to script this. Any suggestions?
--copy databaseuse master;alter database polaris_regular set single_user with rollback immediate;DROP DATABASE polaris_regular;backup database polaris to disk = 'c: mppolarisbak.bak' with INIT,format;restore filelistonly from disk = 'c: mppolarisbak.bak';restore database polaris_regular from disk = 'c: mppolarisbak.bak'with move 'polaris' to 'C:Datapolaris_regular.mdf',move 'polarisLog' to 'C:Datapolaris_regularLog.mdf';