Problem with INSERT INTO Temp Table on SQL 2000 using Linked Server to SQL 2005

I have a SQL Server 2000 linked to a SQL Server 2005 and I am attempting populate a temporary table on the 2000 server using INSERT INTO by executing a stored procedure on the 2005 server. If I just execute the stored procedure, the data is returened with no issues. If I try to Insert the data into the temporary table the process hangs and times out.

This returns the data with no issues:

EXEC @.RetVal = MyLink.MyTable.dbo.spGetValue @.string1

This hangs and has to be killed or times out:

CREATE TABLE #TempTable (Value DECIMAL(19, 10) NULL)
INSERT INTO #TempTable

EXEC @.RetVal = MyLink.MyTable.dbo.spGetValue @.string1
SELECT * FROM #TempTable

I tried adding SET REMOTE_PROC_TRANSACTIONS OFF as suggested in an earlier post, but this had no effect.

You need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

|||

Thanks for your reply.

MSDTC service is already running on both servers.

Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?

Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?sql

Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?

Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?|||I HAVE THE SAME PROBLEM AND BEEN LOOKING AROUND FOR A FIX FOR 3 MONTHS NOW. DOES ANYBODY KNOW HOW TO FIX THIS PROBLEM?

Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?

Problem with Full-text searching

I am getting this error message from SQL Server when attempting any full-text
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.
The service appears to be installed and running on Windows 2003 Server and
the error appears to be coming from stored procedures like
sp_fulltext_database. What do I need to check next to resolve this problem?
can you create your catalog or fulltext indexes through the wizard?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew" <wanhelp@.elca.org> wrote in message
news:F9513F7D-D058-4AEB-BC18-321BB05896A7@.microsoft.com...
>I am getting this error message from SQL Server when attempting any
>full-text
> catalog operation:
> Error 7619: Execution of a full-text operation failed. The parameter is
> incorrect.
> The service appears to be installed and running on Windows 2003 Server and
> the error appears to be coming from stored procedures like
> sp_fulltext_database. What do I need to check next to resolve this
> problem?
>
|||"Hilary Cotter" wrote:

> can you create your catalog or fulltext indexes through the wizard?
No. The wizard terminates after this error message appears.
|||This appears to be windows 2000. Can do any operations through tsql, such as
creating a table.
Can you try this for me
create database fulltextest
GO
use fulltextest
GO
sp_fulltext_database 'enable'
GO
create table fulltext
(pk int not null identity constraint pk primary key,
charcol char (20))
GO
sp_fulltext_catalog 'test','create'
GO
sp_fulltext_table 'fulltext', 'create', 'test','pk'
GO
sp_fulltext_column 'fulltext','charcol','add'
GO
sp_fulltext_table 'fulltext','start_full'
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew" <wanhelp@.elca.org> wrote in message
news:281B3353-53E0-48CF-85B4-559B3688217F@.microsoft.com...
> "Hilary Cotter" wrote:
>
> No. The wizard terminates after this error message appears.
>
|||"Hilary Cotter" wrote:

> This appears to be windows 2000. Can do any operations through tsql, such as
> creating a table.
> Can you try this for me
> create database fulltextest
The first step that broke was the one with sp_fulltext_database 'enable'. I
worked it out with a Microsoft support engineer, though.

Problem with Forms Security Extension Sample - RS 2005

I am attempting to deploy the sample Security Extensions. When I navigate to <machinename>/reports in IE, it works fine and I am able to register the administrator. The user exists in the table correctly, but I am unable to login as the user. It keeps going back to the same uilogon.aspx redirect page.

It appears to be a similar error as http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=289636&SiteID=17

However, I am using the machine name the entire name, never referring to it as localhost. Any ideas? Thanks!

*bump* Any help would be much appreciated. I've gone through all of the config code changes time and time again and everything is as it should be from the sample code.

Problem with Forms Security Extension Sample - RS 2005

I am attempting to deploy the sample Security Extensions. When I navigate to <machinename>/reports in IE, it works fine and I am able to register the administrator. The user exists in the table correctly, but I am unable to login as the user. It keeps going back to the same uilogon.aspx redirect page.

It appears to be a similar error as http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=289636&SiteID=17

However, I am using the machine name the entire name, never referring to it as localhost. Any ideas? Thanks!

*bump* Any help would be much appreciated. I've gone through all of the config code changes time and time again and everything is as it should be from the sample code.