boolean fields displayed as true or false

I have a bit field in my data source that displays as true/false on my
report. I can't see how to set this so that it displays as 1 or 0. In
Visual Studio, can someone help?=iif (Fields!yourData.value = "True", 1, 0)
"beeyule" wrote:
> I have a bit field in my data source that displays as true/false on my
> report. I can't see how to set this so that it displays as 1 or 0. In
> Visual Studio, can someone help?

Bookmark Functionality and HTMLFragment

I have a report displayed within a frame. A different frame in the
frameset is posting parameter values to this report display frame.
The bookmarks on the report do not work when displayed within the
frame. The onclick javascript command is not created for the
bookmarks.
I have the following HTML configuration settings:
Format = HTML4.0
Toolbar = False
Parameters = False
HTMLFragment = True
If I set the HTMLFragment = false, the bookmarks work, but my
subreports are not rendered in IE (but the subreports are rendered in
Firefox), instead I get the typical red X indicative of a missing
image.
When I view the report via Report Manager, the bookmarks work
correctly. When I include the toolbar on the report, the bookmarks
work correctly (and I see the bookmark onclick code generated when I
view the source of the report).
Any help appreciated.The bookmarks will not work in fragment mode as the content is expected to
be inserted in another document. You shouldn't need fragment mode for the
frame. As for why the subreports are not showing, I don't understand why
(especially if you say it works in Firefox). Do you mean images? Subreports
are never replaced with a red X.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Potter" <drewpotter@.gmail.com> wrote in message
news:1115943049.364352.197320@.g49g2000cwa.googlegroups.com...
>I have a report displayed within a frame. A different frame in the
> frameset is posting parameter values to this report display frame.
> The bookmarks on the report do not work when displayed within the
> frame. The onclick javascript command is not created for the
> bookmarks.
> I have the following HTML configuration settings:
> Format = HTML4.0
> Toolbar = False
> Parameters = False
> HTMLFragment = True
> If I set the HTMLFragment = false, the bookmarks work, but my
> subreports are not rendered in IE (but the subreports are rendered in
> Firefox), instead I get the typical red X indicative of a missing
> image.
> When I view the report via Report Manager, the bookmarks work
> correctly. When I include the toolbar on the report, the bookmarks
> work correctly (and I see the bookmark onclick code generated when I
> view the source of the report).
> Any help appreciated.
>

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Blobs not displayed when printed programatically

Hey folks,

I have a report that I have created. It contains some graphical BLOB fields that are in a database. These blobs were simply dragged and dropped onto the report.

When I preview the report in Crystal Reports the BLOB fields are displayed. When I print the report programatically in VB .net the BLOBs are blank...

Any help would be much apreciated.
ThanksWhat type of image did you use?
Goto support section of this site and see if you find answer
www.BusinessObjects.com

Blank Report Displayed..

Hello All,
I am developing a software.in that sfotware i have to store a logo file(*.jpg)file in oracle 8i. to store logo file in a blob file when i link that table to crystal report 8.5 report become blank
please help me.

i follow these stape

1) I create a table. table name is test field as nm varchar2(20), logo blob
2)by using toad software load a jpeg file in a record & commited
3) in cryastal report, new report is created. system dsn is selected and connected to database
4) test table is added and nm & logo field are placed in detail section when i refresh that report it is a blank
please help me.

prasadMake sure you have records to the table you are referencing
Also do verify database; Uncheck the option Save data with Report

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Bkp Restore Failed

I am trying to restore backup and the system gives me error for LSN. No error no. is displayed but it seems that the system doesnot accept trn log restore.

My bkp strategy is:

Full Backup: weekly

Diff bkp: daily

T Log Bkp : every 2 hours.

But sometime I need to shrink Log file due to heavy growth. Hope that is not creating problem. The following is what i do for shrinking TLog file.

BACKUP LOG ABC TO ABC_BackUp

DBCC SHRINKFILE(ABC_Log, 500)

pL. guide why my restore fails.

you are right on the track... THe shrinking is creating the problem. shrinking log file step will invalidate the transaction log backup chain. So what you should have done after shrinking was take fullbackup of your database. If the transaction log size is the problem, then increase the frequency of the TL Backup. Now you have every 2 hourse, keep it every 15 min or so... it will control the size of the log and then there will be no need to shrink. If you are shrinking then the first step after the shrinking of log should be Full backup remember that.

Read follwing links

FileSize -How to stop the log file from growing
http://www.support.microsoft.com/?id=873235

FileSize -Log file filling up
http://www.support.microsoft.com/?id=110139

FileSize -Log File Grows too big
http://www.support.microsoft.com/?id=317375

FileSize -Log File issues
http://www.nigelrivett.net/TransactionLogFileGrows_1.html

FileSize -Shrinking Log in SQL Server 2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=272318

Madhu|||

Thanks. I tried restoring full bkp, diff bkp and trn bkp which is without any shrinkage and i get the same error.

ERROR:

The log in this backup set begins at LNS .....502600001, which is too recent to apply to the database. An earlier log backup
that includes LSN .....478700001 can be restored.

what is this error and why my restore fails.

|||I would recommend that you do a RESTORE HEADERONLY on all you backups and check the FirstLSN and LastLSN fields of your backup series. The values should not have any gaps. If there are, the backup would be invalid...more of like a "do 5 first after 4 and not 6" kind of thing is how I would explain LSNs|||

Thanks. When i try to exclude filed with gaps, i get the error:

System.Data.sqlclient.sqlerror: Invalid column name 'lightweight'

Following is the bkp procedure i follow;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pl. guide

|||

Thanks. When i see the LSN of my TLog bkp, the last 6 doenot match and hence i tried to restore the first files Full bkp - TLog - TLog - Diff bkp.

This gave me error:

Msg 207, Level 16, State 1, Procedure sp_MSremovedbreplication, Line 242

Invalid column name 'lightweight'.

Msg 3165, Level 16, State 1, Line 1

Database 'ABC' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.

Msg 3167, Level 16, State 1, Line 1

RESTORE could not start database 'ABC'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Que1 why my LSN of TLogbkps are not matching?

Que2 why i got the error as above?

Following steps i follow to take bkps;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pls. guide. Thanks in advance

|||

Thanks. When i see the LSN of my TLog bkp, the last 6 doenot match and hence i tried to restore the first files Full bkp - TLog - TLog - Diff bkp.

This gave me error:

Msg 207, Level 16, State 1, Procedure sp_MSremovedbreplication, Line 242

Invalid column name 'lightweight'.

Msg 3165, Level 16, State 1, Line 1

Database 'ABC' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.

Msg 3167, Level 16, State 1, Line 1

RESTORE could not start database 'ABC'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Que1 why my LSN of TLogbkps are not matching?

Que2 why i got the error as above?

Following steps i follow to take bkps;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pls. guide. Thanks in advance

Bkp Restore Failed

I am trying to restore backup and the system gives me error for LSN. No error no. is displayed but it seems that the system doesnot accept trn log restore.

My bkp strategy is:

Full Backup: weekly

Diff bkp: daily

T Log Bkp : every 2 hours.

But sometime I need to shrink Log file due to heavy growth. Hope that is not creating problem. The following is what i do for shrinking TLog file.

BACKUP LOG ABC TO ABC_BackUp

DBCC SHRINKFILE(ABC_Log, 500)

pL. guide why my restore fails.

you are right on the track... THe shrinking is creating the problem. shrinking log file step will invalidate the transaction log backup chain. So what you should have done after shrinking was take fullbackup of your database. If the transaction log size is the problem, then increase the frequency of the TL Backup. Now you have every 2 hourse, keep it every 15 min or so... it will control the size of the log and then there will be no need to shrink. If you are shrinking then the first step after the shrinking of log should be Full backup remember that.

Read follwing links

FileSize -How to stop the log file from growing
http://www.support.microsoft.com/?id=873235

FileSize -Log file filling up
http://www.support.microsoft.com/?id=110139

FileSize -Log File Grows too big
http://www.support.microsoft.com/?id=317375

FileSize -Log File issues
http://www.nigelrivett.net/TransactionLogFileGrows_1.html

FileSize -Shrinking Log in SQL Server 2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=272318

Madhu|||

Thanks. I tried restoring full bkp, diff bkp and trn bkp which is without any shrinkage and i get the same error.

ERROR:

The log in this backup set begins at LNS .....502600001, which is too recent to apply to the database. An earlier log backup
that includes LSN .....478700001 can be restored.

what is this error and why my restore fails.

|||I would recommend that you do a RESTORE HEADERONLY on all you backups and check the FirstLSN and LastLSN fields of your backup series. The values should not have any gaps. If there are, the backup would be invalid...more of like a "do 5 first after 4 and not 6" kind of thing is how I would explain LSNs|||

Thanks. When i try to exclude filed with gaps, i get the error:

System.Data.sqlclient.sqlerror: Invalid column name 'lightweight'

Following is the bkp procedure i follow;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pl. guide

|||

Thanks. When i see the LSN of my TLog bkp, the last 6 doenot match and hence i tried to restore the first files Full bkp - TLog - TLog - Diff bkp.

This gave me error:

Msg 207, Level 16, State 1, Procedure sp_MSremovedbreplication, Line 242

Invalid column name 'lightweight'.

Msg 3165, Level 16, State 1, Line 1

Database 'ABC' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.

Msg 3167, Level 16, State 1, Line 1

RESTORE could not start database 'ABC'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Que1 why my LSN of TLogbkps are not matching?

Que2 why i got the error as above?

Following steps i follow to take bkps;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pls. guide. Thanks in advance

|||

Thanks. When i see the LSN of my TLog bkp, the last 6 doenot match and hence i tried to restore the first files Full bkp - TLog - TLog - Diff bkp.

This gave me error:

Msg 207, Level 16, State 1, Procedure sp_MSremovedbreplication, Line 242

Invalid column name 'lightweight'.

Msg 3165, Level 16, State 1, Line 1

Database 'ABC' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.

Msg 3167, Level 16, State 1, Line 1

RESTORE could not start database 'ABC'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Que1 why my LSN of TLogbkps are not matching?

Que2 why i got the error as above?

Following steps i follow to take bkps;

Full bkp-Weekly
BACKUP DATABASE [abc] TO [abc_Backup] WITH INIT
RESTORE VERIFYONLY
FROM DISK = 'C:\Database Backup\User Databases\abc\abc_BackUp.BAK'

Diff bkp-Daily
BACKUP DATABASE [abc] TO [abc_BackUp] WITH DIFFERENTIAL;

Tlog bkp-Every 2 hr
BACKUP LOG [abc] TO [abc_BackUp];

Pls. guide. Thanks in advance