Error when running RedGate SQL Backup Job in SQL Server 2005

I have 4 SQL Server 2005 production servers that I installed RedGate SQL Bac
k
up on. All but one run fine. The one that doesn't I get the below error.
Executed as user : AD-DomainName\UserName. SQL Backup job failed with
exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step f
ailed.
The back up is backing up to the AD server which is different than the
server the job runs on. It is a shared folder on the AD and the permissions
grant the owner of the job Full Access.
I do not know what else to do with this issue. It mirrors the other 3 that
work fine.
Any and all help is appreciated.
-ChrisChris,
SQL Server caches login information from active directory. The one
troublesome machine has apparently cached out of date AD information. In
David Grey's BLOG he discusses a similar problem (not with Red Gate) that
may help you resolve.
http://www.codefounders.com/communi...entication.aspx
RLF
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:2B7A5543-C258-4BA2-8CF4-BF2A7F4F1434@.microsoft.com...
>I have 4 SQL Server 2005 production servers that I installed RedGate SQL
>Back
> up on. All but one run fine. The one that doesn't I get the below error.
> Executed as user : AD-DomainName\UserName. SQL Backup job failed with
> exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step
> failed.
> The back up is backing up to the AD server which is different than the
> server the job runs on. It is a shared folder on the AD and the
> permissions
> grant the owner of the job Full Access.
> I do not know what else to do with this issue. It mirrors the other 3 that
> work fine.
> Any and all help is appreciated.
> -Chris
>

Error when perform an update on Immediate Updating Subscriber

I have transaction replication setup between two servers running SQL Server
2000 (standard edition). The subscriber is an immediate updating subscriber.
I am having an issue when I try to update two tables from the subscriber.
When I attempt to perform an update on either table, I receive an error like
the following:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near ')'.
Server: Msg 137, Level 15, State 1, Line 5
Must declare the variable '@.c120o'.
I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and cannot
see any problem with the trigger's syntax.
Any help anyone can provide would be greatly appreciated.
Michael Conway
Calltower, Inc.
Database Administrator
Can you post the name and schema of your problem article?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mconway" <mconway@.calltower.com.(donotspam)> wrote in message
news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>I have transaction replication setup between two servers running SQL Server
> 2000 (standard edition). The subscriber is an immediate updating
> subscriber.
>
> I am having an issue when I try to update two tables from the subscriber.
> When I attempt to perform an update on either table, I receive an error
> like
> the following:
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near ')'.
> Server: Msg 137, Level 15, State 1, Line 5
> Must declare the variable '@.c120o'.
> I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and
> cannot
> see any problem with the trigger's syntax.
> Any help anyone can provide would be greatly appreciated.
>
> --
> Michael Conway
> Calltower, Inc.
> Database Administrator
|||I am having the issue with two articles so I am going to post the schema for
both tables. I am posting the schema as it is in production. There are
spaces in some of the column names, and at first I thought that this was the
cause of the problem, however I removed the spaces in the column names and
still received the same error.
CREATE TABLE [dbo].[Accounts] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SSN] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Zip] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Grid] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Install Start Time] [int] NULL ,
[Install Duration] [int] NULL ,
[Sale Date] [smalldatetime] NULL ,
[Install Date] [smalldatetime] NULL ,
[Charge Back] [smalldatetime] NULL ,
[Who Entered] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[timeentered] [smalldatetime] NULL ,
[Lead Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead ID] [int] NULL ,
[Rep ID] [int] NULL ,
[Technician ID] [int] NULL ,
[Leadpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Reppaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Techpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead pay] [float] NULL ,
[Lead holdback] [float] NULL ,
[Lead bonus] [float] NULL ,
[Rep pay] [float] NULL ,
[Rep holdback] [float] NULL ,
[Rep bonus] [float] NULL ,
[Tech pay] [float] NULL ,
[Tech holdback] [float] NULL ,
[Tech bonus] [float] NULL ,
[AreaID] [int] NULL ,
[CC Number] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion ID] [int] NULL ,
[Kit ID] [int] NULL ,
[Shipping Vendor] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tracking Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Certificate Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Virtual Certificate] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Wiring] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Channels] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Structure] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Story] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Roof] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cable] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Home Type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ala Carte] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[General] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Local] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Payment Type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Receivers] [tinyint] NULL ,
[Payment] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Account Number] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R001] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R002] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R003] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R004] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Claim ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Owe] [float] NULL ,
[Tax] [float] NULL ,
[Collected] [float] NULL ,
[Autodebit] [tinyint] NULL ,
[Processed] [tinyint] NULL ,
[Submitted] [tinyint] NULL ,
[Paid] [tinyint] NULL ,
[Follow Up] [tinyint] NULL ,
[Processed Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Submitted Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Paid Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[collections] [tinyint] NULL ,
[campaignid] [int] NULL ,
[satelliteprovider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[basepackageid] [int] NULL ,
[programmingquote] [float] NULL ,
[dishlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[directlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[numbertvs] [int] NULL ,
[subscriberid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contactdate] [datetime] NULL ,
[progreceivers] [int] NULL ,
[progprovider] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[progpackage] [int] NULL ,
[progpromotionid] [int] NULL ,
[confirminstallation] [tinyint] NULL ,
[arrival] [datetime] NULL ,
[departure] [datetime] NULL ,
[arrivalcode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[departurecode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R005] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R006] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promo Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[confirminstalldate] [datetime] NULL ,
[received] [tinyint] NULL ,
[receiveddate] [datetime] NULL ,
[cancelled] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Fullfillment] [tinyint] NULL ,
[UpgradeID] [int] NULL ,
[leadreceivers] [float] NULL ,
[repreceivers] [float] NULL ,
[techreceivers] [float] NULL ,
[techmaterials] [float] NULL ,
[leadequipment] [float] NULL ,
[repequipment] [float] NULL ,
[techequipment] [float] NULL ,
[chargebackpaid] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[claimupdated] [float] NULL ,
[claimupdateddate] [datetime] NULL ,
[ScheduleSlotID] [bigint] NULL ,
[Warranty] [tinyint] NULL ,
[PreviousProvider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Gender] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Employer] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DOB] [datetime] NULL ,
[ReferralID] [bigint] NULL ,
[ReferralName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Installed] [tinyint] NULL ,
[OldKitID] [bigint] NULL ,
[OldPromotionID] [bigint] NULL ,
[ClaimID2] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OldUpgradeID] [bigint] NULL ,
[BoundType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[street2] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UpgradeOptions] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DriversLicense] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DLState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ChargebackReason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ConvertDate] [datetime] NULL ,
[ConverTempID] [bigint] NULL ,
[LastUpdate] [datetime] NULL ,
[LastUpdateEmpID] [bigint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Employee] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Inactive] [smallint] NULL ,
[Lead Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[user] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[password] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[expiration date] [smalldatetime] NULL ,
[street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[zip] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[state] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ssn] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead Rep] [tinyint] NULL ,
[Rep] [tinyint] NULL ,
[Tech] [tinyint] NULL ,
[links] [tinyint] NULL ,
[add] [tinyint] NULL ,
[update] [tinyint] NULL ,
[delete] [tinyint] NULL ,
[lookup] [tinyint] NULL ,
[scheduler] [tinyint] NULL ,
[accounts] [tinyint] NULL ,
[openticket] [tinyint] NULL ,
[openbilling] [tinyint] NULL ,
[leadcenter] [tinyint] NULL ,
[creditcard] [tinyint] NULL ,
[employee] [tinyint] NULL ,
[areas] [tinyint] NULL ,
[promotions] [tinyint] NULL ,
[promocodes] [tinyint] NULL ,
[makekits] [tinyint] NULL ,
[equipment] [tinyint] NULL ,
[payplans] [tinyint] NULL ,
[preferences] [tinyint] NULL ,
[commissions] [tinyint] NULL ,
[admin] [tinyint] NULL ,
[reports] [tinyint] NULL ,
[receivers] [tinyint] NULL ,
[export] [tinyint] NULL ,
[payments] [tinyint] NULL ,
[production] [tinyint] NULL ,
[route] [tinyint] NULL ,
[statistics] [tinyint] NULL ,
[status] [tinyint] NULL ,
[leadaccounts] [tinyint] NULL ,
[leadpayroll] [tinyint] NULL ,
[repaccounts] [tinyint] NULL ,
[reppayroll] [tinyint] NULL ,
[techpayroll] [tinyint] NULL ,
[techaccounts] [tinyint] NULL ,
[top] [tinyint] NULL ,
[installed] [tinyint] NULL ,
[pending] [tinyint] NULL ,
[cancelled] [tinyint] NULL ,
[chargeback] [tinyint] NULL ,
[reconciliation] [tinyint] NULL ,
[accounting] [tinyint] NULL ,
[receiveables] [tinyint] NULL ,
[reserviced] [tinyint] NULL ,
[rescheduled] [tinyint] NULL ,
[notscheduled] [tinyint] NULL ,
[channels] [tinyint] NULL ,
[churn] [tinyint] NULL ,
[r00] [tinyint] NULL ,
[missing payments] [tinyint] NULL ,
[deactivations] [tinyint] NULL ,
[disconnects] [tinyint] NULL ,
[salestax] [tinyint] NULL ,
[residuals] [tinyint] NULL ,
[exceptions] [tinyint] NULL ,
[servicecalls] [tinyint] NULL ,
[ra] [tinyint] NULL ,
[individualstatistics] [tinyint] NULL ,
[allstatus] [tinyint] NULL ,
[process] [tinyint] NULL ,
[campaigns] [tinyint] NULL ,
[adcampaignreport] [tinyint] NULL ,
[equipmentsalesreport] [tinyint] NULL ,
[missingcertsreport] [tinyint] NULL ,
[undepositedfunds] [tinyint] NULL ,
[Inventory] [tinyint] NULL ,
[TechArriveDepart] [tinyint] NULL ,
[TechInventoryReport] [tinyint] NULL ,
[btnR00] [tinyint] NULL ,
[btnNotes] [tinyint] NULL ,
[btnInvoices] [tinyint] NULL ,
[btnProgramming] [tinyint] NULL ,
[btnReceivables] [tinyint] NULL ,
[btnCreditCard] [tinyint] NULL ,
[btnBankInfo] [tinyint] NULL ,
[btnBilling] [tinyint] NULL ,
[btnContract] [tinyint] NULL ,
[btnService] [tinyint] NULL ,
[btnQuote] [tinyint] NULL ,
[quickbooks] [tinyint] NULL ,
[dataexport] [tinyint] NULL ,
[dataimport] [tinyint] NULL ,
[fake1] [tinyint] NULL ,
[fake2] [tinyint] NULL ,
[fake3] [tinyint] NULL ,
[fake4] [tinyint] NULL ,
[hours] [tinyint] NULL ,
[payrolladministrator] [tinyint] NULL ,
[servicepay] [float] NULL ,
[timeoff] [tinyint] NULL ,
[installation] [tinyint] NULL ,
[negativecommissions] [tinyint] NULL ,
[collections] [tinyint] NULL ,
[WarrantySalesReport] [tinyint] NULL ,
[EmployeeSalesReport] [tinyint] NULL ,
[CommissionsReport] [tinyint] NULL ,
[UserType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TextMessage] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[btnCreditCardView] [tinyint] NULL ,
[btnMoveToLead] [tinyint] NULL ,
[btnManualSchedule] [tinyint] NULL ,
[CancelledReasonReport] [tinyint] NULL ,
[ReferralsReport] [tinyint] NULL ,
[callbacknotes] [tinyint] NULL ,
[toptechs] [tinyint] NULL ,
[LeadLedger] [tinyint] NULL ,
[RepLedger] [tinyint] NULL ,
[TechLedger] [tinyint] NULL ,
[Forecasting] [tinyint] NULL ,
[UserLogin] [tinyint] NULL ,
[POs] [tinyint] NULL ,
[AddEquipment] [tinyint] NULL ,
[EquipmentInventory] [tinyint] NULL ,
[AdjustInventory] [tinyint] NULL ,
[EquipmentLookup] [tinyint] NULL ,
[Aging] [tinyint] NULL ,
[DishCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DirectCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesByVendor] [tinyint] NULL ,
[InstalledReceivers] [tinyint] NULL ,
[TopOffice] [tinyint] NULL ,
[RepInvoices] [tinyint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>
|||I tried unsubscribing to the publication. Then I removed any spaces in the
column names and changed any column names that were using reserved words.
Then I recreated the subscription and subscriber database. However, I still
received the same errors when I tried to update the two tables.
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>

ERROR SYMBOL

Hi All,
Just wondering if someone can help, in the SQL Server
Enterprise Manager Window on the left hand sides where it
lists the servers that you are currently connected to, next
to one of my servers I have a strange red zig zag like down
the side of it, does anyone know what this means.
Thanks PhilThis simply means you are currently connected. It is not an error, just a
poor choice for an icon :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"phil" <harlequintp@.blazemail.com> wrote in message
news:f07501c410d9$59385c30$a601280a@.phx.gbl...
> Hi All,
> Just wondering if someone can help, in the SQL Server
> Enterprise Manager Window on the left hand sides where it
> lists the servers that you are currently connected to, next
> to one of my servers I have a strange red zig zag like down
> the side of it, does anyone know what this means.
> Thanks Phil

error subscribing to publication

Hi All,
[CURRENT SET UP]
I have two SQL 2k Ent servers in two locations.
SVR1 has 2 publications (snapshot and merge) the SVR2 subscribes to.
SVR2 republishes these, so that a number of local MSDE clients can
subscribe to them.
SVR1 also has a number of local MSDE subscribers.
[PROBLEM]
Everything was working great, however this afternoon I tried to add a new
MSDE subscriber (through enterprise manager on my machine, as opposed to
SVR1) to SVR1 and got the following message ?
SQL Server Enterprise Manager could not retrieve information about the
publications from Publisher 'SVR1'.
Error 208: Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I really don't want to drop publications on this server, and so am trying
to find a way of solving this problem, rather than redeploying the
replication structure.
Any help in understanding or troubleshooting this would be greatly
recieved !
TIA.
Ranjeet.
oddly, if I script a subscription and run it, all is OK.
It appears enterprise manager in trying to enumerate the publications is
failing, and so preventing me from subscribing users through EM.
Does anyone know how the publications are enumerated - is there a view /
table / SP that exists for this ?
TIA
Ranjeet.