Recent content by cburns70

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...

I changed the alias to this: Server alias = server1 Network Libray = TCP/IP Connection properties = server1,1433 Still having same problem though.

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 George, We had consider that possibilty as well. Unforunatly trying to connect use the IP address doesn't resolve the problem.

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...

That got it, Thanks! The main report does have records but only in Page Header C. I really appreciate all your help, its working prefectly now!

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...