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...
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...
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...
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...
I want to create an alert for the following condition - if the number of rows in a table Exceeds 2M it should send me an email... How can i do...
Hi , I am trying to covert batch jobs of sql 6.5 to job steps in Sql 2000 ...there is a step where I have to run a SQL query(located in a text...
Separate names with a comma.
