can u do this.

right click the server and click properties

please mention these details

Product

Product Version

so u can create a function from there and not from the script

STRANGE!!!!

I also agree with you. most of the site does have this functinality.

http://www.sql-server-performance.com

http://www.sswug.com

Thank You veru much

eventhough u don't have udf u should have that link in EM

Check this

EXEC dbo.sp_get_counties '''AR','TX'''

Can you see the  User define functions from the Enterprise Manager

Kishore is correct.

I think u are looking for Distinct command. check distinct command in BOL

Correct.

Give appropicate user account for the nesseary services. it works for me

Nice to s a person in a same boat

What u have to do is , Ensure the MSSQLServer & SQLAGent...

I think this is a permission issue. check the user permission

I am not sure what is your problems exactly. If u r looking for an example here it is

RESTORE DATABASE MyNwind

   FROM MyNwind_1

   WITH NORECOVERY

Change CustJobs.Inactive=False to  CustJobs.Inactive=0

this is the only change that i can see

u can set the rownum like in oracle. follwing article will give u some ideas

Find Min/Max Values in a Set

Thankx Frank,

But then I need to change all the quires which is not posible. I have to chage the column id content

Anyway Thankx for the idea