hm...not that I want to say, I'm fed up with such discussions...

But they remind me of

- Which programming language is superior?

- Which RDBMS is best?

- to NULL or NOT?

quote:

---

well after the sun burns out.

---

taking these for posting some broker...

My job doesn't require me to play around with database at all, but I simply do so.

Find yourself a task you want build a database solution for. If it...

... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TreatYourself.asp

Frank

http://www.insidesql.de

quote:

---

What about writing extended stored procedures that would drop in a message queue (MSMQ) or buy a similar product? If the apps...

CREATE TABLE tmpHtml

(Link varchar(100),

 LinkText varchar(100))

GO

CREATE VIEW vw_HtmlFormat

AS

SELECT "<A HREF=" + Link + " target="_blank">" +

       LinkText + "</A>"

FROM tmpHtml

GO

INSERT...

quote:

---

Anyone have additional suggestions (i.e. best way to capture the email in VB?, etc.).

---

not sure...

Well, db_ddladmin also include the DROP statement permission AFAIK. I'm not sure if this is what you or your company wants on a production server.

Frank

http://www.insidesql.de

A shot in the dark!

Add a varchar(xxx) column to your table, insert your links and do the 'HTML' preparing at your client application.

In case your looking for an equivalent...

quote:

---

Frank, how well does that self-documentation work?

---

the results are quite acceptable. No professional stuff,...

quote:

---

If you are using smalldatetime you could only use 20790606. What are the chances that they will be using...

Finally found this again

http://xforce.iss.net/xforce/maillists/otherlists.php

Advantage is, they describe and offer subscription facilities to many of the important lists in one place

Frank

http://www.insidesql.de

grmph, haven't calculated the page break!

Anyway, the above post goes into Jonathan's direction.

Frank

http://www.insidesql.de

I must confess I do really appreciate your 'nit-picking' style !!!

And please, don't get me wrong on this!

Looking forward to many clarifying ?!? posts!

Frank

http://www.insidesql.de

Yes, Steven, you're right. I remember, but prefer to forget. The browser interface is really a mess.

IMHO.

Frank

http://www.insidesql.de