March 20, 2002 at 1:13 pm
I need some help.
Could anybody tell me if there is a way to make a comment(remark) to a field in SQLServer7 table as we put a description in an Access database table's field?
May be SQLServer2K functionality can handle that?
Thank you in advance,
Alex
March 20, 2002 at 1:46 pm
From Books On-Line:
Description
Shows the text description of the selected column.
This can be accessed from Design Table in the Enterprise Manager.
Hope it helps.
March 20, 2002 at 2:05 pm
Thank you for your response,
But, I'm sorry, I didn't understand what do you mean. Please, read my topic carefully. All I need, to be able to put a comment(remark) to a field in SQLServer7 table in a design mode(if it's possible).
March 20, 2002 at 3:02 pm
Not in SQL 7, but in SQL 2000, in design mode, there is a place to enter a comment.
Steve Jones
March 20, 2002 at 3:06 pm
Thank you very much, Steve:
That's all I need.
Alex
March 20, 2002 at 3:33 pm
you are welcome. this is a handy feature, but I'm not thrilled with it's implementation in 2000. Can't get all the comments at once.
Steve Jones
March 21, 2002 at 7:34 am
Steve,
I was just wondering. May be you can suggest any way around. May be using SourceSafe...
I can see you saying "switch to SqlServer2K", but this is out of my responsibilities.
Thank you,
Alex
March 21, 2002 at 7:55 am
Probably the best you can do is just set up a table that parallels sysobjects - if you use the same objectID then you can enter a comment for anything, table, proc, function, etc. Build a view that joins your comments table with sysobjects. Then all you need is a way to edit it - either directly via EM or Access or build a mini app.
Andy
March 21, 2002 at 9:16 am
I agree with Andy, just do basically what Microsoft did in SQL 2000 and create a comments table with an id field that you store the object id of the table in for easy reference.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 21, 2002 at 9:20 am
I did this in v6.5, but used 2 tables. One for tables and one for columns to make notes. Basically objectname and comment fields.
Steve Jones
March 21, 2002 at 10:24 am
Ooh, I like, except with the objectname since you could potentially have two or more tables with same column name, just make sure you will be able to id which table goes with.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 21, 2002 at 10:28 am
Thank you all guys for your help & support. I will definitely use your teckniques.
Alex
March 21, 2002 at 1:29 pm
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply