accent sensitive

Hello
just a little question :
in full text search, in SQL Server 2000, how to enable accent-insentive?
for exemple : if I seize "tele", I want to have results with "tl", "tele",
"tle" and "tel"
thanks for your answer!
a+
syl
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"lobrys" <REMOVE_MElobrys@.orange.com> wrote in message
news:uJKhJpmdFHA.2776@.TK2MSFTNGP10.phx.gbl...
> Hello
> just a little question :
> in full text search, in SQL Server 2000, how to enable accent-insentive?
> for exemple : if I seize "tele", I want to have results with "tl",
"tele",
> "tle" and "tel"
> thanks for your answer!
> a+
> syl
>

About SQL Profiler and query

Hi
i have enable SQL Profiler for my SQL2000 DB and view a "SQLTransaction" but
the TextData is always empty and my application name is JSQL.
This transaction duration is : 10516
The question are :
1- It's a normal that the "textdata" is always empty ?
2- The application name "JSQL" maybe JBOSS on my Apache server?
3- The duration of this transaction is too much ?
Thanks.
What are you expecting to see in the TextData column for the SQLTransaction
event? It's documented behaviour is to display "The savepoint or rollback
name, if provided.", according to SQL Server Books Online:
http://msdn.microsoft.com/library/en..._perf_79tf.asp
Given that it's not common to name savepoints or rollbacks, it's probably a
little unusual to expect to see much in SQLTransaction:TextData. Perhaps you
should be profiling a different event - if you post back with what you're
hoping to see, we can perhaps help by recommending a different event to
profile?
Regards,
Greg Linwood
SQL Server MVP
<io.com> wrote in message news:eu8ETkNnEHA.2764@.TK2MSFTNGP10.phx.gbl...
> Hi
> i have enable SQL Profiler for my SQL2000 DB and view a "SQLTransaction"
> but
> the TextData is always empty and my application name is JSQL.
> This transaction duration is : 10516
> The question are :
> 1- It's a normal that the "textdata" is always empty ?
> 2- The application name "JSQL" maybe JBOSS on my Apache server?
> 3- The duration of this transaction is too much ?
>
> Thanks.
>

About SQL Profiler and query

Hi
i have enable SQL Profiler for my SQL2000 DB and view a "SQLTransaction" but
the TextData is always empty and my application name is JSQL.
This transaction duration is : 10516
The question are :
1- It's a normal that the "textdata" is always empty ?
2- The application name "JSQL" maybe JBOSS on my Apache server?
3- The duration of this transaction is too much ?
Thanks.What are you expecting to see in the TextData column for the SQLTransaction
event? It's documented behaviour is to display "The savepoint or rollback
name, if provided.", according to SQL Server Books Online:
http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_79tf.asp
Given that it's not common to name savepoints or rollbacks, it's probably a
little unusual to expect to see much in SQLTransaction:TextData. Perhaps you
should be profiling a different event - if you post back with what you're
hoping to see, we can perhaps help by recommending a different event to
profile?
Regards,
Greg Linwood
SQL Server MVP
<io.com> wrote in message news:eu8ETkNnEHA.2764@.TK2MSFTNGP10.phx.gbl...
> Hi
> i have enable SQL Profiler for my SQL2000 DB and view a "SQLTransaction"
> but
> the TextData is always empty and my application name is JSQL.
> This transaction duration is : 10516
> The question are :
> 1- It's a normal that the "textdata" is always empty ?
> 2- The application name "JSQL" maybe JBOSS on my Apache server?
> 3- The duration of this transaction is too much ?
>
> Thanks.
>

About DBPROCESS

I'm connected to the db server but constantly is sending
to me "DBPROCESS is dead or not enable", after this I need
to reconnect the application. Any Idea? thx in advance.Hi Efrain.
Which version of SQL Server / Windows are you on?
What were you doing when this happened?
This is most likely a bug in SQL Server or possibly a hardware failure. You
should expect to see some information in the SQL Server error log - is there
anything there?
Probably the most direct action you can take is:
(a) Make sure your service pack/s are up to date - if the cause is a bug in
SQL Server, it might already have been dealt with in a service pack fix.
(b) Call Microsoft PSS - if it's not in a service pack fix & it's a bug you
won't get charged for the call.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Efrain" <malefrax@.yahoo.com> wrote in message
news:26cba01c38eb0$10d46890$a601280a@.phx.gbl...
> I'm connected to the db server but constantly is sending
> to me "DBPROCESS is dead or not enable", after this I need
> to reconnect the application. Any Idea? thx in advance.

about Db table cell setting

How do I enable multiline on data table rows (cells)?

When I press enter the cursor jumps to the next cell and no the next line in the same cell.

Thanks

Hi,

What version of SQL Server are you using, also what application are you using?

Visual Studio, Access, ASP Web App etc...|||

hi,

sql server 2005 express and standard edition.

Thanks