.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

Error number: MSSQL_REPL-2147201016 and other animals (I jmade a boo bioo)

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
Hi guys,   Just experimenting with replication at the moment, and after trying to set a table as read only using the following: ALTER TABLE mytable WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK ( 1 = 0 )   (yes - I know now, that won't work) - I removed the constraint within managment studio, and subsequently mucked up the syncing. (clever eh???)   The whole thing is running on sql server 2005, publicher and subscribers all on the same box for the moment)   2 of the 4 subscriptions give the 2147201016 error, - complaining about a missing stored procedure - if I look in the stored procedures for the subscribed tables - it seems that all the dbo.msmerge procedures have gone bye bye!   also - the other 2 tables give another error: -------------- The schema script 'if object_id(N'[dbo].[ALBANKHOL]') is not null exec('ALTER TABLE [dbo].[ALBANKHOL] WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK( 1 = 0 ) ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) ---------------- (yes - table "albankhol" is the one I created the read only constraint on.   as mentioned, all subscribers and publisher are on the one database - so I don't think it;s a timeout issue     any ideas?

View Complete Post

More Related Resource Links

New column issue - Error number: MSSQL_REPL-2147199478



In merge replication we have following issue which appears from time to time in few subscriptions.

When I added new column to table by using following procedure:


sp_repladdcolumn @source_object = N'TABLE_NAME'

,@column = N'NEW_COLUMN_NAME'

, @typetext =N'tinyint null'  

, @publication_to_add = N'PUBLICATION_NAME'

, @from_agent = 0

, @schema_change_script = null

, @force_invalidate_snapshot = 0 

, @force_reinit_subscription = 0


replication for few subscriptions gets following error:

The schema definition of the destination table 'dbo'.'TABLE_NAME' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot

'Meter number is not registered ' error FedEx ship web service move to production



I want to integrate FedEx ship web service in my website. It works fine for local but for production it gives error. I changed test credentials by production credentials. also changed test url "https://gatewaybeta.fedex.com:443/webservices" by production url "https://gateway.fedex.com:443/webservices" But I am getting error that meter number is not registered. Please advice.

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

Need help with "ORA-01036: illegal variable name/number" error on SQLDataSource


I keep gettin this error on the Data Source. Any ideas on how to fix this?


<asp:SqlDataSource ID="sdsLastName" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
	<asp:controlparameter ControlID="ddType" DefaultValue="LAST_NAME"  PropertyName="SelectedValue"  ConvertEmptyStringToNull="true" />


DB-Library error msg (Number=10004, Severity=9, Function=dbopen)



I am using Named Pipes to create Alias of the Sql Server 2008 using CliConfg utility. Now whenever i try to connect to the server I receive 

DB-Library error msg (Number=10004, Severity=9, Function=dbopen) Unable to connect: SQL Server is unavailable or does not exist.  Connection is busy , error.

please help.


Bug: Valid number throws an overflow error.


I have a major problem. Things were going great until I came across this little bug(?) which has thrown a stick in my spokes. As I will demonstrate below, it seems that when defining certain numbers Visual Studio will throw an overflow error and I have no idea how to resolve this issue.


Dim T As ULong = 14774537964905701134 'Overflow error in the IDE

Dim M As ULong = ULong.MaxValue '(18446744073709551615) we are below the maximum value so it should work, right?


The one solution I have found is that we can use the following declaration instead.


Dim T As ULong = ULong.Parse("14774537964905701134")


However, to make matters even more complicated the value in question is unknown and must be compiled using CodeDOM so using the Parse method isn't an option. Unless there is some way I can determine if that value in particular will give me an overflow error. Any solutions or workarounds would be greatly appreciated, thanks for your time.

Regular Expression Validator error for masked SSN number


Hi all,

I need a small help.
Below given is the ASP.NET Regular Expression Validator that i am using to validate the SSN number being used in my project.

<asp:textbox id="txtSSN" runat="server"  size="14" onBlur="javascript:return mask(this.value,this,'3,6','-','Pri');" maxlength="9" AutoCompleteType="Disabled"></asp:textbox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="<span style='display:none'></span><img src='../images/arrow.gif' alt='Enter a valid 9 digit SSN number'>" ControlToValidate="txtSSN" ValidationExpression="^[0-9X]{3}[\- ]?[0-9X]{2}[\- ]?[0-9]{4}$"></asp:RegularExpressionValidator>

In this project the SSN number is masked before being displayed to the user.
Below given is the format for the display of the SSN number in the front end code

SSN NUMBER in the code behind            :     333-44-2222
SSN NUMBER displayed in textbox as    :     XXX-XX-2222


"unexpected error has occurred" when user enters letter in column of type number

I am testing the form validation on my edit form.  The column is of type number.  When I typed in a letter, instead of presenting me with a validation error, I got "An unexpected error has occurred."  I refreshed the page, entered a letter again, and this time was presented with a validation error.  I'm afraid this sort of thing will happen to my end users once I move to production.  Any idea what might cause this?
There are no mistakes; every result tells you something of value about what your are trying to accomplish.

Sharepoint Checked Out Word Document Cross Reference Error on Page number Only



I see the same error as RHABALA reported in an earlier thread, after I check out my Word Document from Sharepoint into Word 2010. 

When I Control-click on any of my Cross References to Page Number, they fail with the warning prompt, they seem to be incorrectly pointing at the Sharepoint path. But when I Control-click an any Cross References to Paragraph Numbers,  they still work. I've added my Sharepoint Site to the trusted list in Internet Explorer, as recommended in that thread, but no difference, the error persists.

Grateful for your assistance.


Merge replication metadata deletion error MSSQL_REPL-2147199402


I setup merge replication about 3 weeks ago between a few databases all running SQL 2008 SP1:

  • DB1 - This database is the publisher and distributor.
  • DB2 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB3 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB4 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB5 - This database is a read-only subscriber (-EXCHANGETYPE 2) to DB1.
  • DB6 - This database is a read-only subscriber (-EXCHANGETYPE 2) to DB1.

Everything was running fine, then suddenly one at a time the replication jobs for DB2, DB3, and DB4 all started reporting the error:

The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)

I was able to manually upload data from DB2, DB3, and DB4 to DB1 then reinitialize the subscriptions.  However, I don't understand why only those three subscriptions failed.  I have other merge replication jobs between the same SQL instances that are still running fine.  The only unique thing I can determine about the f

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


Handling 404 page not found with Error page



      How do i handle 404 page not found?

Inserting personal error message in ValidationSummary



I am creating a web form that requires a lot of validation. I use many of the validation control in asp.net already like RequiredFieldValidator and CompareValidator. 

My Problem: after my custom validation for the value entered return an error message, and I pressed enter key when the field is empty, my custom error message is overlapped by my ValidationSummary. 

Setting my custom error to visible = false on button click also does not seem to work as it requires for me to enter the value first.

This made me think, is there a way to insert my custom validation inside the ValidationSummary as an error message like for other validation control?

Thanks in advance

Embeb a variable number of videos


I need to provide some alternate content for my non-Flash users.

I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.

How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code.  But this seems inelegant.

Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=
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