In this case Paul's solution should be fine.

I thought you'd use the results (eg, the ID) for some further operations.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

If you explain what you want to do with the result, we might find another work-around?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Edited by - Frank Kalis on 11/04/2003 03:44:15 AM

I think, you've already answered your own question.

From BOL:

quote:

---

Scalar functions

Operate on a single value and then return...

RECONFIGURE command can only be run by sysadmins or serveradmins.

What makes you think, the Server is reconfigured?

What happened?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

...why?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17761&FORUM_ID=8&CAT_ID=1&Topic_Title=Random+Record+%26+NewID%28%29&Forum_Title=T%2DSQL might help

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you get hands on Inside SQL Server 2000 ?

Explains this all in depth.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, I had multiple instances running and lost track

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I suggest you first take a look at BOL fill factor -> fill factor

And maybe this one will also help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_2ri0.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

you mean something like

SELECT 

table_schema, table_name 

FROM 

information_schema.columns

WHERE

column_name = 'MsgDateReceived'



or 



SELECT 

s2.name 

FROM 

dbo.syscolumns s1 

JOIN 

dbo.sysobjects s2 

ON 

s1.id = s2.id 

WHERE 

s1.NAME='MsgDateReceived' 



or



SELECT...

I guess from both performance and security point of view you should go for a stored procedure.

Yes, of course, you'll have to pass your parameters to that procedure, don't worry...

quote:

---

When somebody proudly aligns himself/herself with an extremely arrogant person (such as Joe Celko), that suggests arrogance.

---