All,
Forgive me for the length of this post, but I need a help resolving the root cause of a Full Text Catalog problem I recently had and hopefully finding an easier solution than the one I came up with. Here’s some background on the problem.
Our database as about 70 tables that are full text...
SQL 2000 Database.
I backed up and restored our production database to a test database on the same server and now the full text catalog, in test, is not working.
I tried rebuilding, repopulating, but its not working. When viewing the properties of the test catalog, it contains zero items.
Is...
We're having problem were one column in a table is being updated when it's not supposed to. We're trying to nail down why this is happening.
I would like to setup a trace on this table, but I'm having some trouble.
When I setup the trace; I'm saving the trace to a table (tracetable), I set my...
We're having problem were one column in a table is being updated when it’s not supposed to. We're trying to nail down why this is happening.
I would like to setup a trace on this table, but I'm having some trouble.
When I setup the trace; I'm saving the trace to a table (tracetable), I set my...
I found a work around for the problem. If I run this command from the VISTA machine:
netsh interface tcp set global autotuninglevel=disabled
the problem goes away.
I still curious why I only had this problem on one server. The servers appear to be setup the same, both have he same version of...
We've tried both NP and TCP/IP with the same results.
I also checked for server alias as well. There was one alias for named pipes, the alias name was the same as the server name.
Thanks for your replies. Here's alittle more info.
We have approximately 40 XP PRO client PCs that connect without any problem to Server 1. They are somewhat spread out at our facility, so they could be connecting through several different switches.
If I replace any of those PCs with a VISTA...
We having some strange performance issues with one or our SQL 2005 servers. Let me explain:
We have two Windows 2003 servers with MS SQL 2005 standard edition loaded. (server1, server2)
We have some workstations with XP Pro and some with Vista Ultimate loaded.
Using an XP PRO client machine...
Thanks Lbass that worked perfectly.
dgillz, the data comes from a Laboratory Information Management System. The trailing zeros had some signficance to them, but I'm not sure why.
Crystal 10, Sql 2005
I have float value I need changed to text. Here's the catch; the text that is displayed cannot have any extra trailing zeros. Example:
float = .0023 text has to equal .002
float = .002 text has to equal .002
float = .01 text has to equal .01
float = .1 text has to equal .1...
I did exactly as you suggested. I added another page header, so now I have page header a, b, and c. Page Header C is for all pages, Page Header B is for the Report Footer Sub Report only, and Page Header A is for the frist Sub Report.
I conditonally supressed Page Header A, with "onlastrecord"...
Ok, I'll try and explain better.
The report is for a laboratory and has one parameter which is sample number.
The report as two page headers,two group headers (Group Header 1a and b), details section and group footers are supressed, and a report footer. Group Header 1a is also supressed...
When I try your suggestion, page header a, which I want to show for the main report, is suppressed for the whole report. Page header b shows on all pages.
I'm not sure if the sub report in the group header is relevent or not, just though I would mention it. Thanks for your help.
Thanks Lb, But its not working. My page header is the main report. I have a subreport in the Group Header, and then another subreport in the Report Footer. By the way this is Crystal 10 on SQL server.
I have a subreport in the report footer. When the subreport prints, I would like to change a text field in the Page Header, which would be the title of the Subreport. I have other information in the Page header not related to the Subreport, so I dont want to use the report header in the...
I need to replace a server that has several SQL 2005 databases on it. I need do this without having to change any client ODBC settings or drive mappings, etc.. And with minimal downtime.
I'm thinking it might be easier to setup up the new server under a new name, and then transfer the databases...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.