If the answer is "no", well, that's sad.
If the answer is "yes", then is there a list of 2005 features that will and
will not be available in MSDE 2005 ?
Thank you.
hi,
Marek wrote:
> If the answer is "no", well, that's sad.
> If the answer is "yes", then is there a list of 2005 features that
> will and will not be available in MSDE 2005 ?
> Thank you.
http://www.microsoft.com/sql/express/default.mspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Friday, March 30, 2012
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
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
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
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
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
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.
sqlie5 authentication issues
Hi
We are having a problem with authentication on our reporting server. If the
user connecting is using IE version 5.0 they get a not authorised to view
page error (see below). It works fine for this same user if they use a
machine with ie 5.5 or greater. Other users also have the same problem but
always only if they are using ie5.0. Does anyone no what is causing this? Teh
users connect to the server using the standard
http:<reportservername>/Reports interface. Thanks
ERROR MESSAGE......
You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials that you supplied because your Web browser is sending a
WWW-Authenticate header field that the Web server is not configured to
accept.
----
Please try the following:
Contact the Web site administrator if you believe you should be able to view
this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
----
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the
words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
topics titled About Security, Authentication, and About Custom Error
Messages.Meant to add the system is using windows authentication based on our domain.
"ag" wrote:
> Hi
> We are having a problem with authentication on our reporting server. If the
> user connecting is using IE version 5.0 they get a not authorised to view
> page error (see below). It works fine for this same user if they use a
> machine with ie 5.5 or greater. Other users also have the same problem but
> always only if they are using ie5.0. Does anyone no what is causing this? Teh
> users connect to the server using the standard
> http:<reportservername>/Reports interface. Thanks
> ERROR MESSAGE......
> You are not authorized to view this page
> You do not have permission to view this directory or page using the
> credentials that you supplied because your Web browser is sending a
> WWW-Authenticate header field that the Web server is not configured to
> accept.
> ----
> Please try the following:
> Contact the Web site administrator if you believe you should be able to view
> this directory or page.
> Click the Refresh button to try again with different credentials.
> HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
> Internet Information Services (IIS)
> ----
> Technical Information (for support personnel)
> Go to Microsoft Product Support Services and perform a title search for the
> words HTTP and 401.
> Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
> topics titled About Security, Authentication, and About Custom Error
> Messages.
>
We are having a problem with authentication on our reporting server. If the
user connecting is using IE version 5.0 they get a not authorised to view
page error (see below). It works fine for this same user if they use a
machine with ie 5.5 or greater. Other users also have the same problem but
always only if they are using ie5.0. Does anyone no what is causing this? Teh
users connect to the server using the standard
http:<reportservername>/Reports interface. Thanks
ERROR MESSAGE......
You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials that you supplied because your Web browser is sending a
WWW-Authenticate header field that the Web server is not configured to
accept.
----
Please try the following:
Contact the Web site administrator if you believe you should be able to view
this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
----
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the
words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
topics titled About Security, Authentication, and About Custom Error
Messages.Meant to add the system is using windows authentication based on our domain.
"ag" wrote:
> Hi
> We are having a problem with authentication on our reporting server. If the
> user connecting is using IE version 5.0 they get a not authorised to view
> page error (see below). It works fine for this same user if they use a
> machine with ie 5.5 or greater. Other users also have the same problem but
> always only if they are using ie5.0. Does anyone no what is causing this? Teh
> users connect to the server using the standard
> http:<reportservername>/Reports interface. Thanks
> ERROR MESSAGE......
> You are not authorized to view this page
> You do not have permission to view this directory or page using the
> credentials that you supplied because your Web browser is sending a
> WWW-Authenticate header field that the Web server is not configured to
> accept.
> ----
> Please try the following:
> Contact the Web site administrator if you believe you should be able to view
> this directory or page.
> Click the Refresh button to try again with different credentials.
> HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
> Internet Information Services (IIS)
> ----
> Technical Information (for support personnel)
> Go to Microsoft Product Support Services and perform a title search for the
> words HTTP and 401.
> Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
> topics titled About Security, Authentication, and About Custom Error
> Messages.
>
IE Scripts and Printing Error
hi i am using the RSS 2000 version with the service pack 2. it all works fine in my development machine and other test machines in the office but when i take it out into the real world and try to print IE says it cant run some scripts. i have checked the ie security settings and tried enabling all scripts and still the report viewer insists it cant run some scripts and gives me an error. does any one know where i can change settings to enable my reports to print? the computers i am working on are under a domain with its own security settings i know nothing about but if there is anything i can change on the client machine's IE configuration to enable scripts specific to reporting services to run that will be good to know.
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.sql
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.sql
IE Scripts and Printing Error
hi i am using the RSS 2000 version with the service pack 2. it all works fine in my development machine and other test machines in the office but when i take it out into the real world and try to print IE says it cant run some scripts. i have checked the ie security settings and tried enabling all scripts and still the report viewer insists it cant run some scripts and gives me an error. does any one know where i can change settings to enable my reports to print? the computers i am working on are under a domain with its own security settings i know nothing about but if there is anything i can change on the client machine's IE configuration to enable scripts specific to reporting services to run that will be good to know.
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.
Monday, March 19, 2012
Identity Seed
Hi guys,
Please is it possible in SQL SERVER any version (Prefferably 2005) to set my Identity seed to the current year so that when we are in 2008 it continues from 2008 ?
Best Regards
I'm not too sure why you want to use current year as the seed. Anyways, AFAIK this is not possible.
Can you explain your problem so that we can help you better ?
websyd:
set my Identity seed to the current year so that when we are in 2008 it continues from 2008
This defeats the purpose of an identiy column, Identiy columns are "dataless", they have no intrinsic meaning other than to uniquely identify the row within a table. And you can't do it, anyway.
What are you trying to do?
Friday, February 24, 2012
IDENTITY Column Insert
Hi,
Version: SQL Server 2000 Standarad Edition.
----
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyansits atomic. no problems with duplicate.|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
Version: SQL Server 2000 Standarad Edition.
----
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyansits atomic. no problems with duplicate.|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
IDENTITY Column Insert
Hi,
Version: SQL Server 2000 Standarad Edition.
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyans
its atomic. no problems with duplicate.
|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
Version: SQL Server 2000 Standarad Edition.
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyans
its atomic. no problems with duplicate.
|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
IDENTITY Column Insert
Hi,
Version: SQL Server 2000 Standarad Edition.
----
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyansits atomic. no problems with duplicate.|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
Version: SQL Server 2000 Standarad Edition.
----
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?
If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyansits atomic. no problems with duplicate.|||Hi
You will not get duplicates. When a row is inserted, the Identity value is
incremented. If that transaction rolls back, the identity value will not be
decremented and you will find 'holes' in the sequences. This is by design to
enable higher concurrency.
If you need an absolute guarantee of sequential numbers, you have to do it
through a trigger and thta implies holding locks that will hurt performance.
Issuing a SELECT with NOLCOK will result in uncommitted rows being returned.
In effect, you might be processing against rows that my not exist at a later
stage in your DB. Use with care.
Regards
Mike
"payyans" wrote:
> Hi,
> Version: SQL Server 2000 Standarad Edition.
> ----
> Does SQL Server Insert value to the IDENTITY column in one action, or does
> it INSERT other columns of the table and UPDATE the IDENTITY column as a
> separate statement, internally?
> If I issue an independent SELECT WITH NOLOCK on such a table, is there a
> possibility of getting wrong value for the Identity column anytime?
> Thanks,
> payyans
Sunday, February 19, 2012
identifying which license version installed
this is a stupid question but..I have a sql server installed, how can I tell
how it is licensed? Meaning per processor or per client? Thanks for your he
lpSELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>|||"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>
how it is licensed? Meaning per processor or per client? Thanks for your he
lpSELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>|||"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>
identifying which license version installed
this is a stupid question but..I have a sql server installed, how can I tell
how it is licensed? Meaning per processor or per client? Thanks for your help
SELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>
|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>
how it is licensed? Meaning per processor or per client? Thanks for your help
SELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>
|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
>
>
identifying which license version installed
this is a stupid question but..I have a sql server installed, how can I tell
how it is licensed? Meaning per processor or per client? Thanks for your helpSELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> > this is a stupid question but..I have a sql server installed, how can I
> > tell
> > how it is licensed? Meaning per processor or per client? Thanks for your
> > help
> >
> >
>
>|||"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> > this is a stupid question but..I have a sql server installed, how can I
> > tell
> > how it is licensed? Meaning per processor or per client? Thanks for your
> > help
> >
> >
>
>
how it is licensed? Meaning per processor or per client? Thanks for your helpSELECT SERVERPROPERTY('LicenseType');
If it is per seat you can also see:
SELECT SERVERPROPERTY('NumLicenses');
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"jennifer" <jennifer@.discussions.microsoft.com> wrote in message
news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> this is a stupid question but..I have a sql server installed, how can I
> tell
> how it is licensed? Meaning per processor or per client? Thanks for your
> help
>|||Thanks so much just found it in control panel
now I know 2 ways.
Jennifer
"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> > this is a stupid question but..I have a sql server installed, how can I
> > tell
> > how it is licensed? Meaning per processor or per client? Thanks for your
> > help
> >
> >
>
>|||"Aaron Bertrand [SQL Server MVP]" wrote:
> SELECT SERVERPROPERTY('LicenseType');
> If it is per seat you can also see:
> SELECT SERVERPROPERTY('NumLicenses');
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
> "jennifer" <jennifer@.discussions.microsoft.com> wrote in message
> news:58E2895C-8CAB-4142-BCA3-CAC7C9C91C64@.microsoft.com...
> > this is a stupid question but..I have a sql server installed, how can I
> > tell
> > how it is licensed? Meaning per processor or per client? Thanks for your
> > help
> >
> >
>
>
Subscribe to:
Posts (Atom)