Search results for query: *

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

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

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