columns description how to use it on QA

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

columns description how to use it on QA

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 14:54:45

how do you use columns description on QA? I want to type it in some description for my columns. I see this option on EM. Need to know how to do it on QA

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 14:58:52

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/565483ea-875b-4133-b327-d0006d2d7b4c.htm

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 15:07:07

exec sp_addextendedproperty @name = 'dada', @value = 'myfan'
(1 row(s) affected)

Went to EM, design table, columns-description..

Hasnt been changed. Any other ideas.

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 15:09:20

You aren't using it correctly. Check out the examples in the link.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 15:22:36

Getting an error this time

EXEC sp_addextendedproperty
@name = N'description', @value = 'Postal code is a required column.'
@level0type = N'Schema', @level0name = dbo,
@level1type = N'Table', @level1name = mytable,
@level2type = N'Column', @level2name = mytableid;
GO

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '@level0type'.

=============================
http://www.sqlserverstudy.com

X002548
Not Just a Number

15586 Posts

Posted - 2007-09-20 : 15:26:17

You would be waaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaay better off making your own data dictionary and joining to the system tables

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 15:28:05

Isn't it obvious from the error that you have a syntax problem? You are missing a comma! I'm very surprised that you couldn't figure that out on your own.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 15:29:13

quote:
Originally posted by X002548

You would be waaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaay better off making your own data dictionary and joining to the system tables

But you can use this as your data dictionary.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

X002548
Not Just a Number

15586 Posts

Posted - 2007-09-20 : 15:32:07

Really?

You'd like to bang against the catalog?

Never mind the limited use of it as to compared what you could build?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 15:32:13

i think im a bit tired thats why i didnt notice.

getting this msg now.

EXEC sp_addextendedproperty
@name = N'description', @value = 'Postal code is a required column.',
@level0type = N'Schema', @level0name = mydatabase,
@level1type = N'Table', @level1name = mytable,
@level2type = N'Column', @level2name = mytableid;
GO

Server: Msg 15600, Level 15, State 1, Procedure sp_addextendedproperty, Line 42
An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 15:33:27

Your schema is incorrect, not sure if that'll fix the problem though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 15:38:22

mydatabase/mytable/mytableid

database/table/column

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 15:39:27

You do not use your database name for the schema parameter. Look up schemas in BOL if you don't know what they are.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 15:45:55

i have tried with "dbo" before but it doesnt work either.

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 16:05:45

I'm not sure how else to help you as it is working fine for me.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 16:22:55

ok i got it working...

sp_addextendedproperty 'description', 'Blue',
'user', 'dbo', 'table', 'mytable', 'column', 'mytableid'
GO

1 row succeded
Went to the description field but it didnt do anything to it.

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 16:36:55

You aren't using the correct @name. It should be MS_Description.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 16:44:20

EXEC sp_addextendedproperty
'MS_Description', 'description',
'user', 'dbo', 'table', 'mytable', 'column', 'mytableid'
GO

Went to EM, empty description.

=============================
http://www.sqlserverstudy.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-20 : 16:51:50

IT WORKEDDDDDDDDDDDDDDDDDDDDDD
THJANKS

=============================
http://www.sqlserverstudy.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 16:53:17

You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources