Use this sp_changedbowner [ @loginame = ] 'login' [ , [ @map = ] remap_alias_flag ] -Bindu
Can we change the database owner without deleting and recreating the database? -Bzeebee
I want to monitor all user activity like sql's executed , tables created and dropped from the enterprise manager....and other update sqls executed...
Hi , I have a DTS Job that runs from the command prompt using dtsrun successfully... How ever when I schedule this dts run command from the Jobs...
thanks all for your help and information
we dont care about loosing the data from after the last backup.... Is it still reqd to have recovery model=full -bzeebee
Backup We have this database on two different databases ..Clustered by WIN NT One db has recovery model = simple...it works fine...the problem is...
On Our PRODUCTION SQL server we have Recovery Model = Full.. We need to change it to Recovery Model = Simple.... coz the transaction log is getting...
I did try re-installing ...this did not help....
Hi , I have a wierd problem...I installed SQL2000 Enterprise Edition. on my newly built local PC...I used to run a package earlier and it would...
Satya-I got this error when i executed this EXEC sp_droprolemember 'db_owner','user2' Server: Msg 15410, Level 11, State 1, Procedure...
user2 is the db_owner for another database 'BBB'....I only need to revoke db_owner/dbo perms from 'AAA'
Satya, I ran sp_helplogins user1 has the correct permissions to the database AAA User2 has additional permissions as user_name = 'dbo' and...
Can we use REVOKE to revoke DBO rights....from a user...if he is the db_owner? I am the owner of the db in sp_helpdb
I accidentally attached a database with another user as the database owner... How do i revoke the rights from this user without deleting him...Now...
Thanks Gaurav, Bambola and Luis for your valuable time to help me solve this issue..... -B
gaurav, the query returned the number of rows.. so now I need to use xp_sendmail to email me right? thanks
update stats worked when I user user.table_name thanks bambola ..I guess i overlooked that one.. luis I used this query you gave:- select si.rows,...
works fine.... job ran successfully ... queries run fine.... update stats does not work though...... i just need to get an email when the count of...
xtype = 'U' its definitely a table
Separate names with a comma.
