There are a lot of examples for the pubs database in BOL.

Like this for a stored procedure

USE pubs

IF EXISTS (SELECT name FROM sysobjects 

 ...

I assume you meant NT5 sp2 and not NT4 sp2, or?

Unless this isn't a typo, no matter what this issue is, you should really consider to apply some more recent...

After a while you'll get used to it. If I don't concentrate on it, I don't even notice.

However, is it an option to tighten you internet security setting or...

It is far simpler:

<!-- #include file="top.asp" -->



<%

Dim oRecSet

Dim oConn

Dim SQL

Dim szType

Dim lpszMsgID



Response.Clear



Response.Buffer = true 



Response.Expires = 0 



Set oConn = ConnectAttachment()

Set oRecSet = Server.CreateObject("ADODB.Recordset")



SQL="SELECT img FROM...

quote:

---

Does there exist a documentation which explains how the query optimizer works?

---

Can you spare some...

I can see it in QA when firing a SELECT * FROM master..syslogins and it is explicitely explained in BOL

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I haven't dived too much into Yukon stuff yet, but as far as I understand some new features, you can write database code in some CLR language, pretty much as...

quote:

---

Hi,

I have a Manager_Name field which contains first and last name (example: 'Pam Smith').

How can I write a query to...

Hm...after posting my answer I thought that maybe you should review your table design once more. Is there really a need for two column of that size?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Surely.

Yesterday evening I decided to write something on binary data and SQL Server. This way I don't need to generate traffic on the MS site, but rather here

Nice to see you've found a solution.

...as long as it works don't ask why

Frank

http://www.insidesql.de

http://www.familienzirkus.de