.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

The subscription status of the object could not be changed

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Good day to all.. I have a problem. There are two sql servers with transactional replication Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) There was a table function without parameters, included in articles of publication. Then I had to change it with adding one parameter. I've changed it via alter function on the publisher. And then replication stopped with error message about invalid argument count in this function. I've decided to reinitialise subscribtion with new snapshot, but new snapshot can't be created ("The subscription status of the object could not be changed"). Then I've decided to drop this subscription and recreate it, but I can't drop it (same error - "The subscription status of the object could not be changed").. Dropping publication also was unsuccesfull. How I can repair replication now?

View Complete Post

More Related Resource Links

SSRS Subscription Management: Restart, Stop, View Status, update properties, etc

As SSRS admins, there are times when a user comes to us and ask: I didn't get my reported emailed to me today?or worst, a report subscription going to multiple people doesn't run and now you have lots of people missing their subscription - (suppose server crashed, or something happened).One idea of course would be to have the subscription owner re-schedule it to run now, or create a new -- but - i'm thinking - we should create a subscription adminstration tool.a .net app that queries the ssrs web service, gets a list of subscriptions in the ssrs system (or perhaps by folder) and then is able to 'restart a subscription', "stop a running one", 'view all subscription status, schedule, owner, etc' if I wanted to d this - what is the web service that I could use this for?and most importanly - has anybody dont anything like this that they can share?this is for ssrs 2005 & and I'm hoping 2008 can be called through the same .net app tool

Persistant Status Bar Notification ... error 'SP.UI.Status' is null or not an object

I want to show a status bar that needs to be persistent on a page. for this I used the following in my master page function ShowStatusBarMessage(title, message) { var statusId = SP.UI.Status.addStatus(title, message, true); SP.UI.Status.setStatusPriColor(statusId, 'yellow'); /* Set a status-color */ } HTML, call the JS method: <a onclick="ShowStatusBarMessage('Title'!','Awesome message!')"> Display Status Bar message! </a> ref: http://www.zimmergren.net/archive/2010/03/17/sp-2010-dynamically-displaying-messages-to-your-users-with-the-notification-and-status-bar-areas-in-sharepoint-2010.aspx   But what I want is to call the function on load. So I used pushed ny function to _spBodyOnLoadWrapper using _spBodyOnLoadFunctionNames.push("YourFunctionName");, it throws an error 'SP.UI.Status' is null or not an object Next I created and deployed a webcontrol and did a registerclientscript, that too gives me 'SP.UI.Status' is null or not an object // Define the name and type of the client scripts on the page. String csname1 = "AlertScript"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; // Check to see if the startup script is already registered. if (!cs.IsStartupScriptRegistered(cstype, csname1)) {

How to recognise obsolate object from isolated storage whose class has been changed?

<!-- [if gte mso 10]> <mce:style>


Our company is building a word add-in (document-level add-in) with visual studio 2008, word 2007 and VSTO 3.0 sp1

There is one issue that causes us a headache. It is related to obsolete objects in isolated storage.

In Word add-in we serialize object and save it to isolated storage. Later we can load that object from isolated storage and use it in our application.

The problem occurs in following scenario:

-We are working in Word add-in and save one serialized object to isolated storage

-Turn of Word add-in and change code of the class whose instance we have saved in isolated storage

-Work in word add-in again and load and deserialize object from isolated storage. This object is of obsolete class and code usually breaks here or later in code when we are trying to access changed content.

If this scenario happens, we will clear obsolete object from isolated storage. Issue is how to recognize that object’s class is changed?

We tried to recognize changes in the following ways:

·       &

Subscription Status: Not running???


I rebooted my pub and subscription server. Now Tx Replication Subscription Status is Not running? Why and how can i get to the bottom of this? I did receive an error Alert that i set up saying

The job failed. Unable to determine if the owner  of job xyz has server access (reason: Could not obtain information about Windows NT group/user "ME", error code 0x6fd. [SQLSTATE 42000] (Error 15404)).

Please guide.


how to get the status of an approval workflow of item using sharepoint object model ?



There is a list on which an approval workflow is associated,workflow starts when an item is added.The list is having anonymous access so anyone can enter an item,but the item needs to be approved by an approver.Hence,each item will have a status(e.g. approved,rejected etc.).

Now,I am creating a visual webpart.I want to display the list items in a grid.But I need to display only those items which are approved.I am using sharepoint object model,How can I filter the items based on the approval status.


Change Control - Who changed this object?

We have a team of DBAs. A maintenance plan was changed last week, we can see
a new modified date, but who made the change?
In the wider question - is it possible to log which users are making changes
to objects in SQL server 2005?
Gerry Hickman
London (UK)

Capturing status changed event in Task List


I currently have a custom workflow which was designed using SharePoint Designer 2007 that is attached to a document library.  As part of the workflow, a task is created in a Task List.  However, when the status of the Task in the Task List has changed, I have not been able to capture that event from within my SharePoint Designer workflow in order to continue with other actions within the workflow. 

Is there something that I need to do in order to be able to handle the status changed event in the Task which was initially triggered and created by my Document Library workflow?


Thinking about new C# method prototypes: object as dictionary

I recently had to write a small Flickr API. I know many .Net API for Flickr already exist but I needed one for a Silverlight application. Whatever, it's only about building some querystrings so I did it by myself. It's been an opportunity to think again about a classical question: how to pass parameters to a method ?

Imagine you have a generic method to call some Flickr functions.

C# Object Oriented Programming

So far in C# Essentials we have looked at the basics of programming in C# such as variable types and flow control. Although it would be possible to write a functional program using these techniques, there is much more to becoming a proficient C# programmer. C# is, above all, an object oriented programming language and as such any C# programmer will be expected to create object-oriented applications using this language.

Object Oriented Programming

Four core concept of OOP Object Oriented Programming. 1.Inheritance, 2.Polymorphism, 3.Abstraction and 4.Encapsulation

Object-Oriented Programming Concepts

This is the first in a series of articles describing the use of object-oriented programming techniques as implemented by the C# programming language. This series follows the C# Fundamentals tutorial that beginners are advised to read first.

Overview of SharePoint Object Model

SharePoint offers a set of structured server-side objects those are widely used to program SharePoint Applications. These objects are hierarchically arranged and you can drill down through the object hierarchy to obtain the object that contains the components of SharePoint Application you need to use in your code.

What is the difference between "dynamic" and "object" keywords?

Let's take a quick look at the object keyword first. I'm not going to talk a lot about it because it's been around since C# 1.0. This keyword is nothing more than a shortcut for System.Object, which is the root type in the C# class hierarchy. (However, as Eric Lippert pointed out in his blog post, not everything in C# derives from object.) This is a powerful mechanism, since you can assign almost any value to instances of this type.

How to bind GridView and DropDownList controls using DataTable object

In .net framework 2.0, you can load a DataTable in memory by consuming a data source using a DataReader. In this version you will find the flexibility in accessing the DataReader means write access code once and use again and again using DataReader. To see the functionality of DataTable consider an example that is created using VS2005.

Jscript error: Object does not support property or method


 Hi, i have little knowledge on javascript but i need to use this code get from somewhere for a jquery to work.

I face this "Jscript runtime error: Object does not support property or method" whenever im trying to run this page.

In my experience, im get this error msg 9 out of 10 times i use javascript in my system.

Im using Microsoft Visual web developer 2008, i wonder if this is related to my problem, i not sure there is anything i need to add as reference or update anything.

But anyway, in short, i just couldn't use javascript code when using this development tool because of this sort of error.

Anyway, it happen that last time i tried use the same type of jquery code in another project and it seems to work well without an error.

But now when im try to use it again in this recent project i created, it come out with this error and i have no idea how to solve it even look through google and this forum.

It doesn't really seems like its the code problem itself although im not sure, because any javascript code just couldn't work.

So below is my code that i need to use.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src=&quo

Pass ASP.NET membership identity object across domain?


I am trying to figure a way to SSO with ASP.NET membership and role model.

I can implement custom membership provider which consume web services hosting on a server.

With encryption of data. No problem.

But my question is, If I sign on a website with my provider, got my identity object on that application,

could I pass it to another website on another domain which use the same provider and by doing so, do not need to login again?

If this is possible, I am going to implement this solution. Please tell me what's your take on this.

Send object from one page to another



I want to create object in 1.aspx, and then send it to 2.aspx. This methods are bad, because:

1)Send object with url, like this:


This is not confidential.


Session["field1"] = "12345"; // set
Object foo = Session["field1"]; // get

This is bad too, because in 2.aspx this fields send to textboxes, and if user go to 2.aspx without 1.aspx, he'll see old data. 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend