Register  |  Login




Advertisement

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

Question

Status: Open Points: 250 Time: 13:01 - Feb 19, 2008  

georgemathew2

RETRIEVE THE PROPERTIES OF OBJECTS IN MSSQL 2005

I WANT TO GET THE PROPERTIES OF ALL THE SQL OBJECTS LIKE Backup Devices,Rule,Full Text Catalog,Full Text Services,Language ETC..
HOW CAN I RETRIEVE IT USING SMO OR BY THE QUERY



Categories

Answer Discussion
Tutorials

 

egarobar

Date:: Jan 30, 2009

Time:: 05:18

If you have access to SQL Server Enterprise Manager, open the database you need and examine the tables whose names begin with 'sys' (e.g. sysobjects) until you find what you need. Enterprise Manager gives you the ability to construct queries which you can then copy and use again later if you need.

To access EM the command should be something like -
C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"

admin

Date:: Mar 24, 2009

Time:: 09:48

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

nicholascage

Date:: Sep 26, 2010

Time:: 01:05

If you have access to SQL Server Enterprise Manager, open the database you need and examine the tables whose names begin with 'sys' (e.g. sysobjects) until you find what you need.

http://www.neu92.com/

egarobar

Date:: Oct 01, 2010

Time:: 16:08

The above message is spam!

Answer this Question

New User

Email:

Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

Tutorials cannot be submitted until the Answer Discussion is complete.

Submit answers in the Answer Discussion area

Ask a Question

Have a new question? Ask!

You have 100 characters to use



Top Experts

View More

Rank

Expert

Points

1.

nidhi

10354

2.

oracleofDelphi

6493

3.

rcastagna

5596

4.

LAGM

4848

5.

PeterNZ

3487

6.

gonzalo

2840

7.

Mason

2770

8.

jgivoni

2303

9.

xarcus

1820

10.

Anpanman

917

Become an Expert

Register today to share your knowledge with the community and be recognized and rewarded for your contributions.


Register Here




"Psst, Quomon is a great site. Pass it on."     Tell a Friend  |   Link To Us  |   Save to Delicious  |   Digg! Digg it



Language Options

English:

www.quomon.com

Español:

www.quomon.es