Re: Replication problems

From: pat (pat_at_discussions.microsoft.com)
Date: 09/10/04


Date: Fri, 10 Sep 2004 00:43:02 -0700

Hello Mr. Collins,

I went into the Windows Explorer under Tools (Extra) - Options
(Ordneroptionen) - View (Ansicht) - and the "Use Simple File Sharing"
(Einfache Dateifreigabe verwenden (empfohlen)) is already checked. And i do
not yet have any Publications in my Enterprise Manager.
I wanted to note that when this error with the System account occurs a
screen "Configure SQL Server Agent" appears where i can choose between "Yes,
configure the SQL Server Agent service to start automatically" or "No, I will
start the SQL Server Agent service manually". Here i checked the first one. I
hope this is right?

I posted it now also in the SQL Server - Replication newsgroup. I think this
is a general problem with my Enterprise Manager. I always created Databases
and their Tables from VS.NET because when i want to add new Tables to a
Database in the Enterprise Manager a similiar error to this error 1038 occurs:
An unexpected error happened during this operation.
[Microsoft SQL-DMO (ODBC SQLState: 42000) - Cannot use empty object or
column names. Use a single space if necessary.

Maybe could you help this that you know what went wrong in my Enterprise
Manager? It is inexplicable for me why this error during the Publication
occurs...:(

regards

patrick



Relevant Pages

  • RE: Transaction replication / Distribution agent
    ... I ran the snapshot agents for each of my 4 publications. ... "Vikram Kamath" wrote: ... > Because i think this is why the enterprise manager is not responding. ... when i run the distribution agent it says "the subscription ...
    (microsoft.public.sqlserver.replication)
  • Re: sql agent service
    ... In Administrative Tools -> Services, ... named SQLSERVERAGENT ... You can also find it in Enterprise Manager under Management ... and then go to SQL Server Agent. ...
    (microsoft.public.sqlserver.security)
  • Tidying up replication entries in Enterprise Manager
    ... I am trying to tidyup some remants of past publications. ... seem to be left is the publication itself and the snapshot part underneath ... SQL Server Enterprise Manager could not retrieve information about ...
    (microsoft.public.sqlserver.replication)
  • Re: Default Permissions
    ... If you use Enterprise Manager to choose the accountused to start SQL ... Server and SQL Server Agent then the permissions will all be granted to ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • MSDE & SQL Server Agent
    ... Can anyone tell me if the SQL Server Agent is included with MSDE? ... that Query Analyzer and Enterprise Manager are not included. ... I intend to use ...
    (microsoft.public.sqlserver.server)