You can execute almost all T-SQL commands dynamically.

I would write your query including your subquery first in plain T-SQL and translate it then into dynamic sql.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

You should read sp_dboption in BOL. I guess most folks here consider it bad.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, identities can and almost always will have gaps, but that's what I meant with can easily be done when presenting the data, that is at the client

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sure thing that a skilled person might get access this way or another, but you can prevent the vast majority of part-time crackers and hackers from trying. And that's better...

I guess the only to enforce this, is to automatically create a thread when the first newsletter is delivered. And even then you should factor in the 'human factor' that...

Read the article and judge then.

Image data is for binary data in general!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Take a look at the image data type

Sorry Jeremy, another standard link from me

You should read this, Andrew

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

That's what I really like about your replies, Jonathan!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

It was slow during the morning hours here, but now it's ok, or?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Well, as the majority of members here seem to come from the US, I'd suggest using the american date formatting convention.

FWIW

Frank

http://www.insidesql.de

http://www.familienzirkus.de

From time to time even I have to work.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I'm sure Brian Kelley will also respond. In the meantime take a look at http://www.sqlsecurity.com. Especially at the featured links on the homepage. They lead to some interesting white papers...

Did I ever mention I hate horizontal scrolling

SELECT @@version returns here in full

...

Are you sure you're looking both ways at the same server?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

So using IE6 how can I turn it off???

Frank

http://www.insidesql.de

http://www.familienzirkus.de