Viewing 15 posts - 46 through 60 (of 72 total)
Created your table in the 'pubs' database on the same server where I'm having the problems. Rebuilt the FTI using the neutral word-breaker settings. Executed the select statements and received...
November 5, 2003 at 4:47 am
The collation on my table/column is <database default> which means I'm using SQL_Latin1_General_CP1_CI_AS.
The query I posted in my last post with the AND clauses, returns the error message:
Server: Msg 7619,...
November 4, 2003 at 3:03 am
I'm running the English version of SQL 2000 SP2 (SQL Server 2000 SP2 2000.80.534.0 )
Single quotes work better via the Query Analyzer. Double quotes would be used if i'd be...
November 4, 2003 at 2:12 am
Well i tried a manual search via SQL Query Analyzer using the following statement:
select ctx_desc from dbo.item_tl
where contains(ctx_desc,'3.0')
...and the system returned the following error:
Server: Msg 7619, Level...
November 4, 2003 at 12:34 am
Here's just to let you know that it didn't work searching for 3"."0 and so I'm stuck where I started off from.
Anybody else got a cool suggestion?
November 3, 2003 at 1:14 am
Hi Ck
No "." in the noise.dat files (noise.enu, noise ena, noise.deu, etc.). Unless you meant something totaly different.
Will let you know if the trick with 3"."0 works. You see, I'm...
October 31, 2003 at 7:43 am
Hi Allen & Ed
Seems like Ed's jab in the right direction would be my solution (except SQL 7.0 doesn't need the fix in step 1, that is solely intended for...
July 22, 2003 at 7:43 am
Yes, that's basically what is happening.
I've got one SPID (from any individual database on the server) that connects to the tempdb and creates up to 100 database, table and/or...
July 21, 2003 at 12:04 am
Ok.
I'd agree on a normal basis, but other databases are timing out because of the problems with the tempdb.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what...
July 18, 2003 at 8:57 am
Sorry. Snipped out too much code...
Way up at the beginning I assign Set @nRowCount = @@ROWCOUNT...
Yes, I know that if I rollback the transaction that everything will be rolled back....
May 20, 2003 at 8:11 am
Yes I know the tempdb is recreated based on the size of the model database, but our tempdb wasn't being recreated. It just got stuck at 17 GB....
April 23, 2003 at 11:23 pm
Just an additional comment for pbirch.
quote:
That makes sense since the Temporary database is recreated each time the server starts.
April 16, 2003 at 12:27 am
Not allowing the tempdb to Auto grow is probably the most worst thing to do. Then things start getting really bad for your DB applications.
We had the same problem...
April 16, 2003 at 12:18 am
Another tidbit of information: The Auto Shrink option is not available for the following System databases: MASTER and TEMPDB.
Even if you switch the MASTER database to Full Recovery you...
April 14, 2003 at 7:24 am
I purchased both books mentioned and found both useful depending on what you want to do.
Rob Vieira's "SQL Server 2000 Programming" gives you a great overview. He has a humorous...
August 2, 2002 at 2:26 am
Viewing 15 posts - 46 through 60 (of 72 total)