Viewing 15 posts - 46 through 60 (of 73 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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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,...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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?
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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....
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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. Even after...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
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...
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
August 2, 2002 at 2:26 am
Viewing 15 posts - 46 through 60 (of 73 total)