Activity overview
Latest activity by davegr
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.
SQL Tests not recognized
I have copied a database that has tSQLt tests defined in it to another SQL server. SQL Test would run these tests fine at the original location. After installing the DB on the new server I go to Ad...
Vault 7 Support
Hi,
We need to upgrade our Source Gear Vault installation to 7.1 in order to use it with Visual Studio 2013. Does anyone know if Vault 7.1 will work with the latest version of Source Control? Any ...
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...
Table Documentation
Before using SQL Source Control I would have one script file per object. The file would also contain comments related to function, change history, notes, author etc. The script file would be source...
Comments at start of procedure ignored
Hi,
If I create a SP as follows and then do an ALTER PROCEDURE {tab} SQL Prompt fills in the procedure code but leaves out the first comment. If the comments are moved after the CREATE PROCEDURE li...
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...
Column Picker on INSERT Statement
If I key in
INSERT INTO MyTable(
I get the colum the list of columns as suggestions but the Column Picker is not available. Selecting the columns individually is fine when there are only a few colu...