a server side trace, rather than running profiler, is actually very light weight and has minimal impact.

i personally use something like this, but it would rollover automatically based on size,...

isn't the patindex command like this, with % signs?

select

patindex('%http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html%', es_text),

ES_TEXT

from MultilingualText2

CREATE TABLE Table_Text

(Col1 TEXT)

INSERT INTO Table_Text

SELECT 'blah-blah' + 'http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html' UNION ALL

SELECT 'other stuff in the textfield' + 'http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html'...

virgil i hope this might help: fiddling wiht TEXT fields is tough...here's a procedure i wrote to do find and replace in TEXT fields. I know this works on huge...

i think what you want is to add the "title" attribute to your a href tag.

Click Here.

looks like this:

wow i could make an article on SSC over this...lots of questions below got my thoughts flowing.

VB6 can be used, but it was l8imited to 8000 chars due to the...

I'm not sure you have your arms around how SQL server uses ports.

SQL server cannot listen to multiple ports. one port per instance default is 1433, as you know, and...

Oleg I'm glad you found a solution here. this thread started back in 2005, and has produced a lot of great ideas and solutions. people find it and it often...

chburns (6/15/2009)

---

I am having a problem returning records in sql. I am trying to retrieve the first record in a table (chronologically), but when I use a min function...

Dorian Gray (6/15/2009)

---

I am at my wits end - any help will be appreciated. I have a tester connecting to a SQL2K5 db installed on my pc at work...

oops double post sorry folks...continue below

if your developers are on the same network, then I don't believe it can be done.

each instance of SQL server listens to one port...no problem.

a router can take traffic from...

alias? I'm not clear on your question. which alias are you referring to?

You might use port forwarding because you have 10...

port forwarding is not handled by SQL Server, it is typically handled by a router that establishes the firewall between your internal network and the internet.

here's a screen shot of...

An Identity column will not meet your requirement, since you need it to reset back to 1 with each claim number.

as you've probably already found, there's no inbuilt way...

Object:Deleted would be the dropping of a table, foe example. the default trace only tracks object level events: CREATE/ALTER/DROP of database objects (DDL)

you would need a DML trace(Data Manipulation)

I'm adding...