Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cburns70

    SQL 2000 Full Text Population problem, need better resolution than the

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

    Full Text catalog Production to Test Database not working.

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

    SQL Profiler, How setup trace to monitor one table.

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

    SQL Profiler, How setup trace to monitor one table.

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

    SQL 2005 Performance problem/question

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

    SQL 2005 Performance problem/question

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

    SQL 2005 Performance problem/question

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

    SQL 2005 Performance problem/question

    Thanks George, We had consider that possibilty as well. Unforunatly trying to connect use the IP address doesn't resolve the problem.
  9. cburns70

    SQL 2005 Performance problem/question

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

    SQL 2005 Performance problem/question

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

    Converting a Float to text with conditions

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

    Converting a Float to text with conditions

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

    How to change title in Page Header when Report Footer prints?

    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!
  14. cburns70

    How to change title in Page Header when Report Footer prints?

    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"...
  15. cburns70

    How to change title in Page Header when Report Footer prints?

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

    How to change title in Page Header when Report Footer prints?

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

    How to change title in Page Header when Report Footer prints?

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

    How to change title in Page Header when Report Footer prints?

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

    Replacing SQL 2005 server

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

Part and Inventory Search

Back
Top