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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

DROP CONSTRAINT AND ADD/MULTI TABLES PUBLISHER, PROBLEMS IN SUSCRIPC....

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
Sorry my terrible english,   I will try to explain my problem, I made some data changes at the publisher and I had to throw away the PK and FK cascading multiple tables. The problem I have is that these changes were trying to apply to the subscribers and can not do because it does not in order which I did step by step through the Publisher. subscribers now show me this error and does not synchronize anything, and takes 0.5 sec and gives the error infinitely I need help, which infinitely grateful Error messages: The schema script ' if exists (select * from sysconstraints where constid = object_id(N'[FinancieroAbonos_PK]')) if object_id(N'[dbo].[FinancieroAbonos]') is not null exec('ALTER TABLE [dbo].[FinancieroAbonos] DROP CONSTRAINT [FinancieroAbonos_PK] ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: http://help/MSSQL_REPL-2147201001 The constraint 'FinancieroAbonos_PK' is being referenced by table 'FinancieroAbonosContabilizacion', foreign key constraint 'FinancieroAbonos_FinancieroAbonosContabilizacion_FK1'. (Source: MSSQLServer, Error number: 3725) Get help: http://help/3725 Could not drop constraint. See previous errors. (Source: MSSQLServer, Error number: 3727)


View Complete Post


More Related Resource Links

Dynamically Drop and Create tables, overcoming 4000 charachter limit

  
We have a Navision SQL-server database for 7 companies. Each table starts with the name of the company. Except for the CompanyName-part, the tables names are equal. I made a Foreach loop that dynamically transfers tables/data from the the Navision-database to a staging-database. I also want to Drop and re-Create the tables dynamically. However, if I try to do that via an expression in a SQL Task, SSIS complains about the 4000 character limit. What is a better way to do this? I want to execute SQL-commands and have SSIS replace part of the tablename with the contents of a variable (being the name of one the 7 companies). I have no access to the Management Studio or the DB so I need it to be done within the package. What is the best way to do that?

NULL label doesn't appear on drop down or multi-select parameter.

  
Hi, I am using SSRS 2005 SP3. I have the following query that I use for my parameter: SELECT 0 AS c1, 'NOT Specified' AS c2 UNION SELECT 1 AS c1, NULL AS c2 UNION SELECT 2 AS c1, 'Test 1' AS c2 UNION SELECT 3 AS c1, 'Test 2' AS c2 Let's call my parameter prm1. The type of prm1 is string and it has "Allow null value" and "Allow blank value" options ticked. C1 is the value field and C2 is the label field for prm1. When I preview the report, and I didn't see NULL in my drop down list,  but that record has been shown as 1 (which is the value). I am wondering if this is a normal behavior of SSRS? It's not a big deal. I can replace NULL with something else, but I am just curious. Cheers, Uzzie

DataAdaptor/Dataset problems when no row present in database tables

  
Hi All, I'm trying to use a DataSet to maintain some rows for a table, and when I've finished my changes, send all changes to the database using a SqlDataAdapter.    I find if there are no rows in the table in the database then I am getting a 'Object reference not set to an instance of an object' when I try to access the table in the Dataset. Is there a way to work with a Dataset like this ie. I start off with an empty table and I wish to add rows, to access the structure of the table rows, build rows, then add them and do the update on the SQLDataAdapter. Thanks, Sinead Here is my code: protected SqlDataAdapter memberDA = new SqlDataAdapter(); protected DataSet memberDS { get { if (ViewState["memberDS"] != null) return (DataSet)ViewState["memberDS"]; else return new DataSet(); } set { ViewState["memberDS"] = value; } } protected SqlDataAdapter getDataAdapterForMembers() { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SiteDBConn"].ConnectionString; memberDA = new SqlDataAdapter("usp_GetMembers", conn); memberDA.SelectCommand.CommandType = CommandType.Stored

Drop extended property "MS_Description" of ALL tables and ALL columns

  
Hi,

Is there an easy way (a sql script) to drop the "MS_Description" of all tables and all columns in my database?

Regards,
Alejandroo

adding mor tables to datasource view causes writeback performance problems

  
Hi,

I've got a very strange behavior in one of our SSAS databases. We had performance issues so i've tried to put only the essential parts into one OLAP Database

the result is:

Just by adding more tables to the datasource view the writeback performance drops from 0,2sec to 3 sec. No changes to the cube, no changes to the dimensions.
The t-sql statement fired for the writeback remains the same.
Any idea?

regards,

Michael

Problems trying to format HTML tables

  

I have two one-line x 2-column HTML tables that I want to horizontally line with each other.  To be specific, here's the formatting I'm looking for:

                                 ----------------------------------------------------------------------------

                                 |                    Feet of Advance:  | [TextBox] ft                       | 

                                 ----------------------------------------------------------------------------

                                 |         

Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Drop tables by date it were created

  

Hi,

I have a large database that were used to archive tables before implementing structural change on it.

We had this database for years, I want to create a dynamic script to check today's date and drop any table in this database that were created 3 years or older.

Thanks


Drop tables where table name is a parameter

  

I'm trying to drop some tables and I created a curser to do so.

The table name is a parameter.

I get an error message when I run this code in the curser.

Is there any way to run this code in a different way.

I'm trying to drop databases as well where database name is a paramerter, can I do so?

 

 

Declare

 

@DatabaseName varchar(30)

Declare

 

@FullDatabaseName

Syntax to drop constraint if exists

  

what is the syntax to check to see whether a constraint exists?   Must a foreign key constraint be dropped from both tables?

  


How do I - pass multiple params from multi-select drop down on one report to another via action

  

Report 1 - 3 params:  @Status =Y,N  @FromDate, @ToDate.  Report one shows 2 cols (Status, Total). 

 @Status gets values from shared dataset - getStatus

Status      Totals
[Status]    [Total]
               [sum(Total)]

I created an action [Total] when clicked runs another report that accepts the same 3 params (Status, FromDate, ToDate) and works fine if i only select one of the status' from the status param drop down.

I am trying to create an action on [sum(Total)] that will run the same 2nd report with both status' selected.  Show it should show me details of all Y and N

The second report will work if i set the 2nd report @Status param to no default value.  But i want a user to be able to run the 2nd report by itself if needed so i set the @Status param to Get Values from a Query, which get the same dataset as report 1 which is getStatus.  It will not populate the 2nd report Status field when I do this.  I am forced to set it to no default values.  Is there a way to pass both the Y and N from report 1 to report 2 and still keep the drop down multi-select box on report 2 for Status?


MCP

Problems in deploying dimensions composed of related tables

  

Hello,

I have a new dimension with attributes from different related tables but when I try to deploy it, I get the error message "Errors in the high-level relational engine. The table that is required for a join cannot be reached based on the relationships in the data source view." I checked the DSV and I have these tables with relations! What am I doing wrong?

Thanks.


Multi-Column ComboBox that binds to it's Value and Display Members for the drop down

  
I'm looking for a MultiColumn ComboBox solution as well. I've seen a lot of people talking about using Templates and I have to admit I'm not entirely comfortable with using Templates yet in WPF.

What I'm looking for specifically is a ComboBox that simply shows a two column drop down that displays the values resolved from DisplayMemberPath and SelectedValuePath for each item of the bound ItemsSource of the ComboBox. Once one of the items is selected I'm looking for the SelectedValue only to be displayed in the Text area.


Below is a crude diagram to explain what I'm looking for.

 __________________________
|CODE3___________________|_|
|CODE1 | Display value 1 | |
|CODE2 | Display value 1 | |
|CODE3 | Display value 1 | |
 __________________________




I've fumbled around using RelativeSource and a few other things but nothing works so far. If anybody has a clue about different ways to implement this I would love to hear them. A quick example using templates would be wonderful but also note that I'm planning probably to make this a reusable control in our solution since this is a common paradigm in our UI that I wouldn't want to have to repeat on each Window or UserControl in various projects.

How to create Drop down list with multi select capabilty.

  

Hi All,

I want to create a multi selected drop down list using ASP.NET MVC 2.

Can anyone guide me.

How do i achieve it.

Please Help.


multi-language issue in mvc - soliving with routes / need a constraint !!

  

hi guys,


I am creating a multi language website with asp.net mvc 2.0

I tried to solve the problem with routes and I guess it will work just fine but I need some constraint inside my route;


here is my routes;

I have two routes;

            routes.MapRoute(
                    "IntegerBlogRoute",
                    "{Id}",
                    new { controller = "Blogs", action = "Index" },
                    new { Id = @"\d+" }
                );

            routes.MapRoute(
                "Default", // Route name
                "{language}/{controller}/{action}/{id}", // URL with parameters
                new { controller = "Home", action = "Index", language = "tr", id = UrlParameter.Optional } // Parameter defaults
            );


in 1st route, I do not need the language so it will pass without language. I am only excepting integer on this route as you could see on the id constraint.

what I need is that;

  • in the 2nd route, I need a constraint that specify language variable only can be en or tr. how can I write that?


thanks !


InfoPath 2010 Set field values of multi checkbox based on drop down selection

  

Hi,

I have a drop down with e.g values "Fruit", "Veg".I also have checkboxes - "Apple", "Pear", "Orange" ,"Tomato", "Potato". On selection of Fruit i want the checboxes applicable to fruit to be checked. I have a rule at the moment but can only get one checkbox to be ticked. How do i do multiple.

Thanks in advance.

 

 

 


Categories: 
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