Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Monday, March 26, 2012

IE7 and SSRS Document Map

The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.

Reporting Services version is SQL2000.

Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.

Can anyone help or at least comment?

I have raised in a number of places...but no response.

The document map works when running against SQL 2005 - but that doesn't help my customers.

I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.

When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade

|||

User string agent utility doesn't work for me either.

At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.

|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||

Howdy,

We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.

Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.

|||

The document map does not display SQL Express Reporting Service reports from IE7 browsers.

I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.

|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||

It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=241461

where I logged this problem and got a "Won't fix" answer.

|||

I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000

This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.

|||

Have got an acknowledgement from someone at MS:

"Document map base its dynamic behavior on an htc file: TreeView.htc.

1) In IE6, when an html page includes an import namespace like the following:

<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>

It shows the document map correctly

In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response

2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.

It seems IE7 needs the content type set in order to import an htc correctly."

Can any one figure out a workaround based on this information?

|||

Does anyone had this issue in IE6?

I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?

|||

HELP, how do we implement this solution?

We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000

I see the virtual directory and can add text/x-component but what is the value we attached to it,

Or are we suppose to add this some where else?

|||

Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.

IE7 and SSRS Document Map

The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.

Reporting Services version is SQL2000.

Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.

Can anyone help or at least comment?

I have raised in a number of places...but no response.

The document map works when running against SQL 2005 - but that doesn't help my customers.

I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.

When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade

|||

User string agent utility doesn't work for me either.

At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.

|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||

Howdy,

We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.

Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.

|||

The document map does not display SQL Express Reporting Service reports from IE7 browsers.

I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.

|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||

It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=241461

where I logged this problem and got a "Won't fix" answer.

|||

I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000

This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.

|||

Have got an acknowledgement from someone at MS:

"Document map base its dynamic behavior on an htc file: TreeView.htc.

1) In IE6, when an html page includes an import namespace like the following:

<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>

It shows the document map correctly

In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response

2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.

It seems IE7 needs the content type set in order to import an htc correctly."

Can any one figure out a workaround based on this information?

|||

Does anyone had this issue in IE6?

I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?

|||

HELP, how do we implement this solution?

We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000

I see the virtual directory and can add text/x-component but what is the value we attached to it,

Or are we suppose to add this some where else?

|||

Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.

IE7 and SSRS Document Map

The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.

Reporting Services version is SQL2000.

Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.

Can anyone help or at least comment?

I have raised in a number of places...but no response.

The document map works when running against SQL 2005 - but that doesn't help my customers.

I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.

When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade

|||

User string agent utility doesn't work for me either.

At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.

|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||

Howdy,

We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.

Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.

|||

The document map does not display SQL Express Reporting Service reports from IE7 browsers.

I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.

|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||

It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=241461

where I logged this problem and got a "Won't fix" answer.

|||

I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000

This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.

|||

Have got an acknowledgement from someone at MS:

"Document map base its dynamic behavior on an htc file: TreeView.htc.

1) In IE6, when an html page includes an import namespace like the following:

<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>

It shows the document map correctly

In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response

2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.

It seems IE7 needs the content type set in order to import an htc correctly."

Can any one figure out a workaround based on this information?

|||

Does anyone had this issue in IE6?

I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?

|||

HELP, how do we implement this solution?

We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000

I see the virtual directory and can add text/x-component but what is the value we attached to it,

Or are we suppose to add this some where else?

|||

Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.

IE7 and SSRS Document Map

The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.

Reporting Services version is SQL2000.

Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.

Can anyone help or at least comment?

I have raised in a number of places...but no response.

The document map works when running against SQL 2005 - but that doesn't help my customers.

I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.

When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade

|||

User string agent utility doesn't work for me either.

At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.

|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||

Howdy,

We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.

Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.

|||

The document map does not display SQL Express Reporting Service reports from IE7 browsers.

I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.

|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||

It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=241461

where I logged this problem and got a "Won't fix" answer.

|||

I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000

This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.

|||

Have got an acknowledgement from someone at MS:

"Document map base its dynamic behavior on an htc file: TreeView.htc.

1) In IE6, when an html page includes an import namespace like the following:

<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>

It shows the document map correctly

In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response

2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.

It seems IE7 needs the content type set in order to import an htc correctly."

Can any one figure out a workaround based on this information?

|||

Does anyone had this issue in IE6?

I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?

|||

HELP, how do we implement this solution?

We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000

I see the virtual directory and can add text/x-component but what is the value we attached to it,

Or are we suppose to add this some where else?

|||

Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.

IE7 and SSRS Document Map

The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.

Reporting Services version is SQL2000.

Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.

Can anyone help or at least comment?

I have raised in a number of places...but no response.

The document map works when running against SQL 2005 - but that doesn't help my customers.

I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.

When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade

|||

User string agent utility doesn't work for me either.

At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.

|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||

Howdy,

We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.

Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.

|||

The document map does not display SQL Express Reporting Service reports from IE7 browsers.

I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.

|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||

It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=241461

where I logged this problem and got a "Won't fix" answer.

|||

I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000

This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.

|||

Have got an acknowledgement from someone at MS:

"Document map base its dynamic behavior on an htc file: TreeView.htc.

1) In IE6, when an html page includes an import namespace like the following:

<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>

It shows the document map correctly

In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response

2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.

It seems IE7 needs the content type set in order to import an htc correctly."

Can any one figure out a workaround based on this information?

|||

Does anyone had this issue in IE6?

I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?

|||

HELP, how do we implement this solution?

We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000

I see the virtual directory and can add text/x-component but what is the value we attached to it,

Or are we suppose to add this some where else?

|||

Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.

sql

Monday, March 12, 2012

Identity Not for Replication

Hi,
I am beginner in replication, I use a merge type replication
I have a Publisher on a Sql2000 Server
I have a Distributor on an other Sql2000 Server
And I have subscriber with laptop
I use a pull subscription
My question is I f my database have 1000 tables and I use only 60 tables in
my replication
Do I have to use Not for replication on all Identity column of the 60 tables
or all the 100 tables?
Thank in advance!
You only need to use it on the ones which are truly bi-directional, or where
the inserts will occur on both sides between syncs. For example if all of
your inserts occur on your publisher you will not need it. To be on the safe
side I would put it everywhere.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GC" <GC@.discussions.microsoft.com> wrote in message
news:78448474-E3B8-4449-8561-63B13AA33025@.microsoft.com...
> Hi,
> I am beginner in replication, I use a merge type replication
> I have a Publisher on a Sql2000 Server
> I have a Distributor on an other Sql2000 Server
> And I have subscriber with laptop
> I use a pull subscription
> My question is I f my database have 1000 tables and I use only 60 tables
> in
> my replication
> Do I have to use Not for replication on all Identity column of the 60
> tables
> or all the 100 tables?
> Thank in advance!
>
>
>

Wednesday, March 7, 2012

Identity Column values getting corrupted

I have bi-directional replication setup between SQL7 and SQL2000 and I have defined range for each publisher. Every thing has been working just fine and over time I have added several distribution agents for new tables for 2 way replication. In order to be sure both the databases get to do insert in their assigned range, I have a CHECK constraint with "NOT FOR REPLICTION" setup on each replicated table.

Just recently, I have encountered 2 tables for which the check constraint throws an error saying the application is trying to insert row that violates the check constraint. Upon doing DBCC CHECKIDENTI with NORESEED option, I find out that the identity column value is incorrect even though this column has the property "NOT FOR REPLICATION".

I have fixed the problem by running DBCC CHECKIDENT with RESEED option, but after a few days the identity column value gets corrupted again. Any ideas?

I don't think the application is doing insert with "SET IDENTITY INSERT" because a) the identity column is set with NOT FOR REPLICATION property and b)I have check constraints to keep the application from inserting in the wrong range.

Any help will be deeply appreciated. Thanks!

-A

What version of SQL Server 2000 are you running? In earlier versions there was a bug in the SQL engine such that under certain conditions the identity seed can be corrupted. This bug is fixed in SP3 and after.