Showing posts with label product. Show all posts
Showing posts with label product. Show all posts

Thursday, March 29, 2012

dropping default constraints

Hello

We've got a product which uses merge replication with anonymous pullsubscriptions.
At most custome sites it's running on SQL Server 2000, a few with SQL 2005, which is running wich replication compatibility level 80 due to .
As it happens, db schema changes. So I have to drop a column with a default constraint. First the constraint, then the column.
This works excellently on the publisher - but not on the subscriber Sad

The schema script 'exec sp_repldropcolumn '[dbo].[role_modul_rmd]', 'rmd_modul_enabled', 1' could not be propagated to the subscriber. (Quelle: MSSQL_REPL, Fehlernummer: MSSQL_REPL-2147201001)
Hilfe abrufen: http://help/MSSQL_REPL-2147201001
The object 'DF__role_modu__rmd_m__3119DB2C' is dependent on column 'rmd_modul_enabled'. (Quelle: MSSQLServer, Fehlernummer: 5074)
Hilfe abrufen: http://help/5074
ALTER TABLE DROP COLUMN rmd_modul_enabled failed because one or more objects access this column. (Quelle: MSSQLServer, Fehlernummer: 4922)
Hilfe abrufen: http://help/4922

What can bi done?

Thanks for your advice
Aline

We had this exact same problem.

First to recover your replication you can go in and drop the column manually on the subscribers. Then replication should recover.

This happens because replication does not deliver the commands in the correct order, it tries to drop the column first before droping the constraint which it cannot do. The only solution is to drop the constraint first then wait for everyone to replicate then try dropping the column.

Martin

Tuesday, March 27, 2012

dropping default constraints

Hello

We've got a product which uses merge replication with anonymous pullsubscriptions.
At most custome sites it's running on SQL Server 2000, a few with SQL 2005, which is running wich replication compatibility level 80 due to .
As it happens, db schema changes. So I have to drop a column with a default constraint. First the constraint, then the column.
This works excellently on the publisher - but not on the subscriber Sad

The schema script 'exec sp_repldropcolumn '[dbo].[role_modul_rmd]', 'rmd_modul_enabled', 1' could not be propagated to the subscriber. (Quelle: MSSQL_REPL, Fehlernummer: MSSQL_REPL-2147201001)
Hilfe abrufen: http://help/MSSQL_REPL-2147201001
The object 'DF__role_modu__rmd_m__3119DB2C' is dependent on column 'rmd_modul_enabled'. (Quelle: MSSQLServer, Fehlernummer: 5074)
Hilfe abrufen: http://help/5074
ALTER TABLE DROP COLUMN rmd_modul_enabled failed because one or more objects access this column. (Quelle: MSSQLServer, Fehlernummer: 4922)
Hilfe abrufen: http://help/4922

What can bi done?

Thanks for your advice
Aline

We had this exact same problem.

First to recover your replication you can go in and drop the column manually on the subscribers. Then replication should recover.

This happens because replication does not deliver the commands in the correct order, it tries to drop the column first before droping the constraint which it cannot do. The only solution is to drop the constraint first then wait for everyone to replicate then try dropping the column.

Martin

Friday, February 17, 2012

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

KeywordsMonth1Month2Month3Month4Keyword 11252427512Keyword 2456245671223

and

For Month 1

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx