Prev: Performance problems after upgrading to 2005 from SQL 7
Next: Sql Server 200x Stress Tools?
From: Author on 15 Jul 2008 10:08
use [mydb]
go
sp_help dbo.myFunction

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

but the following executes with no problem.

use [mydb]
go
sp_help myFunction

I've noticed this problem for a long time with system stored
procedures, there must be a reason. Please give me a hint.

Thanks a lot.
From: sloan on 15 Jul 2008 10:40
sp_help '[dbo].[myFunction]'



?



"Author" <gnewsgroup(a)gmail.com> wrote in message
news:4b1abf92-e137-4cde-b83d-1ceb2d2ce51a(a)p25g2000hsf.googlegroups.com...
> use [mydb]
> go
> sp_help dbo.myFunction
>
> Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
>
> but the following executes with no problem.
>
> use [mydb]
> go
> sp_help myFunction
>
> I've noticed this problem for a long time with system stored
> procedures, there must be a reason. Please give me a hint.
>
> Thanks a lot.


From: Author on 15 Jul 2008 11:46
On Jul 15, 10:40 am, "sloan" <sl...(a)ipass.net> wrote:
> sp_help '[dbo].[myFunction]'
>
> ?
>

Same error. BTW, the db is SQL Server 2000. I tried executing this
sp_help like that in both Sql Query Analyzer and Sql Server Management
Studio, and I got the same error in both.

I guess no one has an answer to this mysterious situation.
From: Russell Fields on 15 Jul 2008 12:01
Author,

This works for me on both SQL Server 2000 and 2005.

sp_help '[dbo].[myFunction]'

So does:

sp_help "[dbo].[myFunction]"

For SQL Server 2000, the standard question might be 'which service pack or
which build is running on the server and same question for your desktop
tools.'

RLF



"Author" <gnewsgroup(a)gmail.com> wrote in message
news:9092ec05-ec38-450d-b4c6-309d0f4f10c3(a)l42g2000hsc.googlegroups.com...
On Jul 15, 10:40 am, "sloan" <sl...(a)ipass.net> wrote:
> sp_help '[dbo].[myFunction]'
>
> ?
>

Same error. BTW, the db is SQL Server 2000. I tried executing this
sp_help like that in both Sql Query Analyzer and Sql Server Management
Studio, and I got the same error in both.

I guess no one has an answer to this mysterious situation.


From: sloan on 15 Jul 2008 12:07
It worked for me (the code I gave you) for Sql2005.

That's all I got, sorry.


"Author" <gnewsgroup(a)gmail.com> wrote in message
news:9092ec05-ec38-450d-b4c6-309d0f4f10c3(a)l42g2000hsc.googlegroups.com...
On Jul 15, 10:40 am, "sloan" <sl...(a)ipass.net> wrote:
> sp_help '[dbo].[myFunction]'
>
> ?
>

Same error. BTW, the db is SQL Server 2000. I tried executing this
sp_help like that in both Sql Query Analyzer and Sql Server Management
Studio, and I got the same error in both.

I guess no one has an answer to this mysterious situation.


 |  Next  |  Last
Pages: 1 2 3 4
Prev: Performance problems after upgrading to 2005 from SQL 7
Next: Sql Server 200x Stress Tools?