Activity overview
Latest activity by Kazoo60
Work-arounds .... work :-) Thanks! / comments
Work-arounds .... work :-) Thanks!
Yes - from a right click on the DB in SSMS. Is there another way to launch it where the behavior would be different?
Thanks / comments
Yes - from a right click on the DB in SSMS. Is there another way to launch it where the behavior would be different?
Thanks
How are FK dependencies reported in "Used By"
I'm a new user of SQL Doc. I'm not understanding the dependency reporting. I have a master table called "Payment Type". The PK of that table is a FK on "Payment" . When looking at the "Used by...
Thanks @PeterG . I actually tried both script types but I totally missed the fact you need to select the table first - and then put in your script. Makes perfect sense now. Thanks so much for helping out! / comments
Thanks @PeterG . I actually tried both script types but I totally missed the fact you need to select the table first - and then put in your script. Makes perfect sense now. Thanks so much for he...
Thanks @AlessandroAlpi for helping out.
I finally sorted it out and it was definitely a "user error on my part" :-)
The problem turned out to be the fact I typed "All databases" in the "Database" field. In order to have the color apply for all databases just leave it blank. SQL Prompt will show "All databases" in a greyed-out color.
You can specify the local server as simply "(local)". In fact, if you put your machine name or a "." in the "Server/Group" field, SQL Prompt changes it automatically to "(local)" if that is how you connected. / comments
Thanks @AlessandroAlpi for helping out.
I finally sorted it out and it was definitely a "user error on my part" :-)
The problem turned out to be the fact I typed "All databases" in the "Database" ...
Committing migration scripts
I am having difficult figuring our migration scripts. (new user of SQL Source Control)
Please see image:
I added a column to an existing table (nullable), the populated it. Afterward I then set t...