Sql Server 2008 r2 invalid object name sys.procedures

Question

0.00/5 (No votes)

See more:

Hi All,

I am using mssql2008 r2 version. I saw the query sys.Procedures to get procedure list but that query giving me invalid object name sys.procedures

this repeats for sys.objects also .. anybody know whats the problem?? My Version???

hai.. I got issue for sys.objects, sys.procedures , sys.all_objects.... I need to know y its happening .. I know the querys to retrieve ...

Thanks,
Sarathkumar.N

Posted 8-Jan-13 20:20pm

Sarathkumar Nallathamby

Updated 9-Jan-13 1:28am

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shek124 · Answer 1 · 2013-01-08T20:28:00

Solution 2

SQL

Select * from Sysobjects where type='p'

Posted 8-Jan-13 20:28pm

shek124

Comments

Sarathkumar Nallathamby 9-Jan-13 7:27am

hai.. I got issue for sys.objects, sys.procedures , sys.all_objects.... I need to know y its happening....

**Zoltán Zörgő** · Answer 2 · 2013-01-08T20:25:00

Solution 1

Try this one:

SQL

SELECT NAME FROM SYS.ALL_OBJECTS WHERE type='P'

Posted 8-Jan-13 20:25pm

Zoltán Zörgő

Comments

Sarathkumar Nallathamby 9-Jan-13 7:27am

hai.. I got issue for sys.objects, sys.procedures , sys.all_objects.... I need to know y its happening....

Zoltán Zörgő 9-Jan-13 7:55am

I don't know either. Above query work fine on an SQL 2008R2 Std. What is the error message you get?

Sarathkumar Nallathamby 10-Jan-13 7:37am

I Got invalid object name sys.Procedures,.. sys.objects also same error..

Zoltán Zörgő 10-Jan-13 8:06am

Are you admin?

Sarathkumar Nallathamby 10-Jan-13 8:22am

lol..Nope.. asp.net Developer only.. Y buddy??

Zoltán Zörgő 10-Jan-13 8:35am

My question is regarding, if you run your query with proper privileges on the database?

Sarathkumar Nallathamby 10-Jan-13 23:21pm

lol .. Sorry Zorgo.. Ya i am using with privilege only...

Zoltán Zörgő 11-Jan-13 1:35am

You have not told us something really important. This should work.

Sarathkumar Nallathamby 11-Jan-13 3:09am

I am working on full privilege only.. But its not working to me... Well I am in sql server 2008 R2.. can u guess why it happens???

Zoltán Zörgő 11-Jan-13 3:19am

I have tested it with 2008R2 also. add a use master before the query. Please make a screenshot of your whole SQL Managemnt Studio after running the query, and upload it somewhere.

Sarathkumar Nallathamby 11-Jan-13 4:56am

Hi,
SELECT @@Version
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) sp3.. This is my Version.. did u get ?? But i still get error...

Zoltán Zörgő 11-Jan-13 5:14am

Brother! You have SQL Server 2000, not 2008!!!
Try Select * from Sysobjects where type='p', not sys.sysobjects, use exactly as it is written here.

Sarathkumar Nallathamby 21-Jan-13 7:50am

ya.. But in my machine the name showing that 2008r2 only...

Zoltán Zörgő 21-Jan-13 8:08am

You typed this: "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48", Didn't you? Well, this tells us that you have v2000.

Sarathkumar Nallathamby 22-Jan-13 0:07am

ok fine... But while i am seeing in startpage its showing LIk sql 2008 r2 only.. Then how it possible????

Zoltán Zörgő 22-Jan-13 2:17am

What startpage? Of SQL Management Studio? That's a management tool, not really much to do with the sql server version.

Sarathkumar Nallathamby 22-Jan-13 2:34am

Start page means start menu . It showing sql 2008 r2 i opened && @@Version Means it showing like Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) sp3... That Pretty confusing me... Pls help me..

Zoltán Zörgő 22-Jan-13 2:46am

Sorry, I can't see your screen. Try this method: http://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/

But I would believe the @@version...

Sarathkumar Nallathamby 22-Jan-13 2:49am

ya i too believe in @@Version .. SO that oly i got confused buddy.. Because after 2005 sys.objects will work i knew.. so only i posted.. well Thanks for ur help..

Sarathkumar Nallathamby 12-Jan-13 0:14am

Hey dude. I know this query .. but above 2005 sys.objects have to work know .. y not working .. thats my question..?

Zoltán Zörgő 12-Jan-13 2:41am

Sorry, but I have enough of you. You say you have 2008R2, than you paste a 2000 version, than you say you have 2005. And you don't want to upload a screenshot somewhere. I can't help you, since you don't collaborate...