Comments
Sort by recent activity
FIgured it out - you need to ensure server has CLR enabled and database has trustworthy on. Then it all works as expected. / comments
FIgured it out - you need to ensure server has CLR enabled and database has trustworthy on. Then it all works as expected.
Separate properties allow me to separate the various bits of information so you can then have some automated prcoessing of the meta-data. E.g. I could set a property name to a change request reference and the value would be some description of the change. It would be fairly easy to then get all the objects that were affected by a particular change. Right now I keep this information manually. Yes I could keep all this in one field and search the field for the change reference but this is error prone.
In the interest of doing more customer development and less tool development I'll use the MS_Description field for now and look forward to you adding support for other extended properties in a future release!
Thanks
Dave / comments
Separate properties allow me to separate the various bits of information so you can then have some automated prcoessing of the meta-data. E.g. I could set a property name to a change request refere...
Hi David,
I hope I'm wrong but SQL Doc only allows one to edit the MS_Description extended property. I don't see anything else that would let me add/change/delete other extended properties.
I seem to recall some feature requests along this line for SQL Doc.
Thanks
Dave / comments
Hi David,
I hope I'm wrong but SQL Doc only allows one to edit the MS_Description extended property. I don't see anything else that would let me add/change/delete other extended properties.
I seem ...
Hi Peter,
Thanks for the reply.
I'm not sure if I understand what you are saying. The first part about checking the script out of source control and adding comments is fine but comments from a CREATE/ALTER table script are not persisted in the database. They will only exist in the script file. If I go back to using a script file as my master then there is no need for SQL Source Control.
I have solved this by using the extended properties to store object information and wrote my own extended property manager so as to be able to maintain the properties efficiently.
Thanks
Dave / comments
Hi Peter,
Thanks for the reply.
I'm not sure if I understand what you are saying. The first part about checking the script out of source control and adding comments is fine but comments from a CREA...
Thanks Anu,
For now I just key in a SELECT statement to get the Column Picker and then after choosing the columns, change the code to an INSERT INTO statement. This at least saves the typing or selection of all the column names one by one.
I look forward to seeing this functionality added to a future release.
Regards
Dave / comments
Thanks Anu,
For now I just key in a SELECT statement to get the Column Picker and then after choosing the columns, change the code to an INSERT INTO statement. This at least saves the typing or sel...