Dear All

  I face the following Problem in sql server
  I install Sql Server 2000 in windows 2000 server ,All the query and procedure run successfully , my Problem is EnterPrise manager Database could not display the UserDefined function menu,

 Why the Sql Server not display (user Defined Function)

  i any permission will be need

 How to configure , if any one know it please Replay me

I have same problem since I moved from sql2000 to 2005.I use Query Analyser (sql server 2000)for manipulationg with functions.

 I type the following function in query analyser (Sql server 2000),
Query Analyser also generate an error

CREATE FUNCTION SalesByStore (@storeid varchar(30))
RETURNS TABLE
AS
RETURN (SELECT title from Suar )

Error message
   in correct syntax near Function

how to solve this problem

Regards
Arun

Hi Aruanachalam!

Did you upgrade from 7.0 to SQL Server 2000 or you just installed SQL Server 2000 only ?
Upto 7.0 there was no concept of functions. It was introduced in SQL Server 2000.
To avoid this -
[1] Detach databases
[2] Uninstall older version (7.0/6.5)
[3] Install SQL Server 2000
[4] Attach databases

For 2005 too, the same concept is applicable. Although, upgrades work fine but, some in some cases you find such troubles.

I hope this may help you.

-Som Dutt

The syntax is correct. Sometimes, depending on your technical platform and history, you have to add owner to the object as written below.
CREATE FUNCTION dbo.SalesByStore (@storeid varchar(30))
RETURNS TABLE
AS
RETURN (SELECT title from Suar )

I have run the same script and it worked. Problem is not with the Syntax!!