Re: Problems creating subscription...

I am looking at the code for sp_MSget_synctran_commands and this is what it
has around line 198

if @command_only = 0
select * from #art_commands order by id
else
select commands from #art_commands order by id
--

Do you have any really long table names?
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"LPR-3rd" <lreames@xxxxxxxxx> wrote in message
news:1168927021.980769.34300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Sooy....different problem....

I scriped the creation of the publication, it took 23 min to create it.
I scripted the creation of the subscription & received the following
message.......

Job 'R00S-SQLA-STOREMAIN-Storemain to 99-R99S-SQLA-449' started
successfully.
Warning: The distribution agent job has been implicitly created and
will run under the SQL Server Agent Service Account.
Msg 8152, Level 16, State 10, Procedure sp_MSget_synctran_commands,
Line 198
String or binary data would be truncated.
'ROUSES.COM\LarryDSI' is a member of sysadmin server role and cannot be
granted to or revoked from the proxy. Members of sysadmin server role
are allowed to use any proxy.


AHIA,
Larry...



.

Relevant Pages

  • Re: Problems creating subscription...
    ... I scriped the creation of the publication, it took 23 min to create it. ... 'ROUSES.COM\LarryDSI' is a member of sysadmin server role and cannot be ... granted to or revoked from the proxy. ...
    (microsoft.public.sqlserver.replication)
  • Re: how could i hide my finacial data to sa when i store them in sql server 2k?
    ... Where does the info reside? ... You can adde the user to db_denydatareader role and make sure that he/she is ... not a member of sysadmin server role. ...
    (microsoft.public.sqlserver.security)
  • Re: GK - Granting on all objects but not on JOBs ?????
    ... You have to be member of SYSADMIN server role or member of DB_OWNER role ... in MSDB database. ... procedures etc) and NOT on JOBs? ...
    (microsoft.public.sqlserver.security)
  • Re: Executing Jobs via a SQL Statement
    ... Note that you still need to be the owner of a job or a member of the ... sysadmin server role to start jobs with sp_start_job, ... SQL Server MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Basic Server Roles (security) question
    ... Are you member of sysadmin server role as well? ... > I want to add a consulting firm of ours to have full access to a ... > nothing I can find talks about this kind of granularity in security. ...
    (microsoft.public.sqlserver.security)