BCP out from warm standby DB

We are trying to BCP out of a warm standby, read only DB (logShip Secondary).
We put a hold on the restore job for Log Shipping, bcp out, then resume
Log shipping all using a login account with Sysadm priviledges(SQL
authentication). My question is can we do this with a login account(SQL
authentication) not having
Sysadm priviledges, and if so how?
Thanks.
My guess is probably. I would think that you would need an account with
enough privileges to stop and start the restore job itself as well as read
from the DB and write out a file somewhere.
Rick
"John" <John@.discussions.microsoft.com> wrote in message
news:3506E5E7-5D45-4F84-963E-E1D9079CDBAE@.microsoft.com...
> We are trying to BCP out of a warm standby, read only DB (logShip
Secondary).
> We put a hold on the restore job for Log Shipping, bcp out, then resume
> Log shipping all using a login account with Sysadm priviledges(SQL
> authentication). My question is can we do this with a login account(SQL
> authentication) not having
> Sysadm priviledges, and if so how?
> Thanks.
>
sql

BCP out from warm standby DB

We are trying to BCP out of a warm standby, read only DB (logShip Secondary)
.
We put a hold on the restore job for Log Shipping, bcp out, then resume
Log shipping all using a login account with Sysadm priviledges(SQL
authentication). My question is can we do this with a login account(SQL
authentication) not having
Sysadm priviledges, and if so how?
Thanks.My guess is probably. I would think that you would need an account with
enough privileges to stop and start the restore job itself as well as read
from the DB and write out a file somewhere.
Rick
"John" <John@.discussions.microsoft.com> wrote in message
news:3506E5E7-5D45-4F84-963E-E1D9079CDBAE@.microsoft.com...
> We are trying to BCP out of a warm standby, read only DB (logShip
Secondary).
> We put a hold on the restore job for Log Shipping, bcp out, then resume
> Log shipping all using a login account with Sysadm priviledges(SQL
> authentication). My question is can we do this with a login account(SQL
> authentication) not having
> Sysadm priviledges, and if so how?
> Thanks.
>

BCP out from warm standby DB

We are trying to BCP out of a warm standby, read only DB (logShip Secondary).
We put a hold on the restore job for Log Shipping, bcp out, then resume
Log shipping all using a login account with Sysadm priviledges(SQL
authentication). My question is can we do this with a login account(SQL
authentication) not having
Sysadm priviledges, and if so how?
Thanks.My guess is probably. I would think that you would need an account with
enough privileges to stop and start the restore job itself as well as read
from the DB and write out a file somewhere.
Rick
"John" <John@.discussions.microsoft.com> wrote in message
news:3506E5E7-5D45-4F84-963E-E1D9079CDBAE@.microsoft.com...
> We are trying to BCP out of a warm standby, read only DB (logShip
Secondary).
> We put a hold on the restore job for Log Shipping, bcp out, then resume
> Log shipping all using a login account with Sysadm priviledges(SQL
> authentication). My question is can we do this with a login account(SQL
> authentication) not having
> Sysadm priviledges, and if so how?
> Thanks.
>

Basics Question for Non tecnical people

Hi, Anybody can give me a link where I can find basic information about
SQLserver2000.
I mean information like how many records a DB can hold, those questions that
have no answer in the product overview or What are the advantages comparing
it to Oracle etc.
I need to talk to Non technical people, and those are pretty much the
questions they ask.
ThanksHi
There are plenty of case studies and information on the SQL server web site
www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
are looking at a new purchase.
As far as number of records, the capacity is really dependent on hardware
and design rather than the DBMS for both.
John
"Kenny M." wrote:

> Hi, Anybody can give me a link where I can find basic information about
> SQLserver2000.
> I mean information like how many records a DB can hold, those questions th
at
> have no answer in the product overview or What are the advantages comparin
g
> it to Oracle etc.
> I need to talk to Non technical people, and those are pretty much the
> questions they ask.
> Thanks|||John Bell a écrit :
> Hi
> There are plenty of case studies and information on the SQL server web sit
e
> www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
> are looking at a new purchase.
> As far as number of records, the capacity is really dependent on hardware
> and design rather than the DBMS for both.
> John
> "Kenny M." wrote:
>
About how many rows wich must be query as how much data cans I have in
SQL Server, according to Wintercorp, there is a firm that use SQL Server
for _ 20 To database...
A +
Frédéric BROUARD, MVP SQL Server, expert bases de données et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************