Home > Archive > MS SQL Server > October 2006 > User defined functions









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author User defined functions
HDI

2006-10-24, 6:33 pm

Hi,

If I create a function in sql server 2005 ans saves it doesn't show in
the list.

What am I doeing wrong?

Thx

Hilary Cotter

2006-10-24, 6:33 pm

Can we see your code? Whenever you issue a create statement, the
function/view/table/object will be "compiled" and should show up within SQL
Server Management Studio.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"HDI" <hdinf@hotmail.com> wrote in message
news:1159791219.433377.212130@k70g2000cwa.googlegroups.com...
> Hi,
>
> If I create a function in sql server 2005 ans saves it doesn't show in
> the list.
>
> What am I doeing wrong?
>
> Thx
>



Tracy McKibben

2006-10-24, 6:33 pm

HDI wrote:
> Hi,
>
> If I create a function in sql server 2005 ans saves it doesn't show in
> the list.
>
> What am I doeing wrong?
>
> Thx
>


What is "the list"? Are you refreshing "the list"? How are you
creating the function?

--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
JXStern

2006-10-24, 6:33 pm

On 2 Oct 2006 05:13:39 -0700, "HDI" <hdinf@hotmail.com> wrote:

>Hi,
>
>If I create a function in sql server 2005 ans saves it doesn't show in
>the list.
>
>What am I doeing wrong?


Refresh the list!
(right click, select "refresh")

J.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com