permissions for drive where data is

Using SS2000 SP4. I have an account called "sqlserver" that I use to start
the SQL Server service and the SQL Server Agent service. This account is an
admin account in sql server. I moved a database from one drive to a new
drive. The database came up as read-only. The permissions on both drives are
the same.
Any ideas why the database came up read-only?
Thanks,
--
Dan D.I just tried to detach the database again in code and got messages like these:
Running UPDATE STATISTICS on all tables
Updating dbo.dtproperties
Server: Msg 3906, Level 16, State 1, Line 1
Could not run BEGIN TRANSACTION in database 'promo2007' because the database
is read-only.
I then tried to take the database offline in EM and it said the database
didn't exist. I then tried to rename the MDF file and I was able to.
Can I create a new database with the same name, detach it and put the
original MDF file in place and attach it again?
Thanks,
--
Dan D.
"Dan D." wrote:
> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is an
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives are
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.|||I ran the reattachment again and it was okay.
--
Dan D.
"Dan D." wrote:
> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is an
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives are
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.

permissions for drive where data is

Using SS2000 SP4. I have an account called "sqlserver" that I use to start
the SQL Server service and the SQL Server Agent service. This account is an
admin account in sql server. I moved a database from one drive to a new
drive. The database came up as read-only. The permissions on both drives are
the same.
Any ideas why the database came up read-only?
Thanks,
Dan D.
I just tried to detach the database again in code and got messages like these:
Running UPDATE STATISTICS on all tables
Updating dbo.dtproperties
Server: Msg 3906, Level 16, State 1, Line 1
Could not run BEGIN TRANSACTION in database 'promo2007' because the database
is read-only.
I then tried to take the database offline in EM and it said the database
didn't exist. I then tried to rename the MDF file and I was able to.
Can I create a new database with the same name, detach it and put the
original MDF file in place and attach it again?
Thanks,
Dan D.
"Dan D." wrote:

> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is an
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives are
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.
|||I ran the reattachment again and it was okay.
Dan D.
"Dan D." wrote:

> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is an
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives are
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.

permissions for drive where data is

Using SS2000 SP4. I have an account called "sqlserver" that I use to start
the SQL Server service and the SQL Server Agent service. This account is an
admin account in sql server. I moved a database from one drive to a new
drive. The database came up as read-only. The permissions on both drives are
the same.
Any ideas why the database came up read-only?
Thanks,
--
Dan D.I just tried to detach the database again in code and got messages like thes
e:
Running UPDATE STATISTICS on all tables
Updating dbo.dtproperties
Server: Msg 3906, Level 16, State 1, Line 1
Could not run BEGIN TRANSACTION in database 'promo2007' because the database
is read-only.
I then tried to take the database offline in EM and it said the database
didn't exist. I then tried to rename the MDF file and I was able to.
Can I create a new database with the same name, detach it and put the
original MDF file in place and attach it again?
Thanks,
--
Dan D.
"Dan D." wrote:

> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is a
n
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives a
re
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.|||I ran the reattachment again and it was okay.
--
Dan D.
"Dan D." wrote:

> Using SS2000 SP4. I have an account called "sqlserver" that I use to start
> the SQL Server service and the SQL Server Agent service. This account is a
n
> admin account in sql server. I moved a database from one drive to a new
> drive. The database came up as read-only. The permissions on both drives a
re
> the same.
> Any ideas why the database came up read-only?
> Thanks,
> --
> Dan D.

Permission to view only jobs

Hi
what are the permissions to be given for sql user if I
want him to see only jobs listed in the jobs section
under sql agent.
I tried giving ready only permissions on msdb & execute
permissions on sp_help_jobhistory. But still user cant
see the jobs listed.
Help will be appreciated.
Thanks,
ManojPlace him in the TargetServersRole role in msdb. He will not be able to
create or alter jobs, but can see them all.
Russell Fields
"Manoj Gadhia" <manoj.gadhia@.upbna.com> wrote in message
news:178501c47bd2$4efdc8e0$a601280a@.phx.gbl...
> Hi
> what are the permissions to be given for sql user if I
> want him to see only jobs listed in the jobs section
> under sql agent.
> I tried giving ready only permissions on msdb & execute
> permissions on sp_help_jobhistory. But still user cant
> see the jobs listed.
> Help will be appreciated.
> Thanks,
> Manoj|||Thanks
It worked Great
Manoj
>--Original Message--
>Place him in the TargetServersRole role in msdb. He
will not be able to
>create or alter jobs, but can see them all.
>Russell Fields
>"Manoj Gadhia" <manoj.gadhia@.upbna.com> wrote in message
>news:178501c47bd2$4efdc8e0$a601280a@.phx.gbl...
execute[vbcol=seagreen]
>
>.
>

Permission to start/stop logreader and distribution agent

Hi all!
SQL Server 7.0, NT 4.0
I have distribuition server, whose only role is to be a
distributor, there are no user databases on it. I want to
create login on that server, a login which can only check
the status of logreaders and distribution agents, and to
start or stop them, everyrhing in EM Console - Replication
Monitor. Some users will be able to register Distributor
server in their EM Console using this login.
Does anybody have an idea how to do this?
TIA!
ArminFrom BOL:
users that are not members of the sysadmin fixed server role can monitor
replication if they are defined with the replmonitor role in the
distribution database. A system administrator can add any user to the
replmonitor role, which allows that user to view replication activity with
the Replication Monitor node in SQL Server Enterprise Manager; however, the
user will not be able to administer replication.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you very much for your answer, Kevin!
But I have a problem - there is no replmonitor role in
distribution database, at least I can not see it. Maybe
this role exists in SQL2K, not in SQL 7.0?
Best regards,
Armin

quote:

---

>--Original Message--
>From BOL:
>users that are not members of the sysadmin fixed server

---

role can monitor

quote:

---

>replication if they are defined with the replmonitor role

---

in the

quote:

---

>distribution database. A system administrator can add any

---

user to the

quote:

---

>replmonitor role, which allows that user to view

---

replication activity with

quote:

---

>the Replication Monitor node in SQL Server Enterprise

---

Manager; however, the

quote:

---

>user will not be able to administer replication.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and

---

confers no rights.

quote:

---

>
>.
>

---

Permission Issues running DTS from Agent

We have a DTS which loads files using FTP to another
server. This will be used by app groups and will be run
via click of button using sp_start_job,

Somehow the userid running the job gets "not sysadmin to
run cmdshell.." Top fix that, we granted it to execute the
xp_cmdshell and also created a proxy account for SQL Agent
which is an admin on server and sql. However, still we get
permission errors like "...The needed permission is
missing to run command shell.." Please help . The DTS is
being called from SQl Agent job and we don't want an admin
ID to be used .Do you have 'exec master.dbo.' in from of xp_command... :confused: