Comments
Sort by recent activity
Hi @Ravin,
The first picture, depicts the filter settings, and you've removed the users. The second picture, if I remember well, it's about the database comparison options file (described here).
Could you please check how the users are filtered in the filter.scpf file? You can find it into your SQL Source Control repository.
I think that the filter file is not configured correctly if you want to include users and roles. You should to check also the Users box. / comments
Hi @Ravin,
The first picture, depicts the filter settings, and you've removed the users. The second picture, if I remember well, it's about the database comparison options file (described here).
Co...
Hi @Ravin,
what do you mean with "when I try to deploy"?
what are you using for deploying your db? The image you posted belongs to SQL Source Control (if I get it correctly). / comments
Hi @Ravin,
what do you mean with "when I try to deploy"?
what are you using for deploying your db? The image you posted belongs to SQL Source Control (if I get it correctly).
Hi @CrossSlide,
reading the documentation , there is some notes to pay attention for. I don't think that trying to do the "known issues" things actually hangs the restore process, but maybe the list could help you in some way.
Another suggestion, since we're on Windows, could be to execute the comparison tool "as Administrator".
Last but not least, you can try to setup a log file, as described here, and look for any message on it.
Hope this will help you discovering the issue. / comments
Hi @CrossSlide,
reading the documentation , there is some notes to pay attention for. I don't think that trying to do the "known issues" things actually hangs the restore process, but maybe the lis...
Hey @shollingshead,
I guess this is not really related to the product. If you try to connect to Azure SQL Database using SQL Server Management Studio, are you able to connect via integrated security, since you're out of the domain with your local/roaming credential? / comments
Hey @shollingshead,
I guess this is not really related to the product. If you try to connect to Azure SQL Database using SQL Server Management Studio, are you able to connect via integrated securit...
Hi @bassofa,
not with one click, actually. Did you notice the "switch" button between the source and the destination database? You can compare S1.DB1.TB1 (-->) S2.DB2.TB2 applying only the additions/modifications and, then, switch and re-compare with S2.DB2.TB2 (-->) S1.DB1.TB1 only with deploying the additions/modifications. In both the comparison sessions, you must uncheck the "only in the right" objects (deletions).
hope this helps, / comments
Hi @bassofa,
not with one click, actually. Did you notice the "switch" button between the source and the destination database? You can compare S1.DB1.TB1 (-->) S2.DB2.TB2 applying only the addition...
Glad to get it! [image] / comments
Glad to get it!
So, despite you've the setting "show object definition" turned on, you cannot get the tooltip yet.
You can try the following:
- turn the setting off, restart SSMS, be sure that the tooltip not appears, turn the setting ON, restart SSMS and retry
- turn SQL Prompt off (disabling it), restart SSMS, turn it ON, restart SSMS and retry
- disable the SQL Server intellisense (you can do it from the Query menu)
doing that, you can look for the SQL Prompt log files.
what version of SSMS are you working on? / comments
So, despite you've the setting "show object definition" turned on, you cannot get the tooltip yet.
You can try the following:
- turn the setting off, restart SSMS, be sure that the tooltip not appe...
So is it working now? I didn't get :-) / comments
So is it working now? I didn't get :-)
Hi @GunNut37086,
could you please send us the screenshot of the tooltip you're getting?
The right documentation link for your version is this one.
As the note states, you can turn off the box, following the instructions in the Showing or hiding the object definition box section.
If you've accidentally turned it off, you should see the SSMS toolbox, if the SSMS intellisense is on, or even nothing. / comments
Hi @GunNut37086,
could you please send us the screenshot of the tooltip you're getting?
The right documentation link for your version is this one.
As the note states, you can turn off the box, foll...
Hi @mweis,
I've found this post (I dunno if it's the one you were speaking of). It seems that you can contact support in order to check the activation limit. / comments
Hi @mweis,
I've found this post (I dunno if it's the one you were speaking of). It seems that you can contact support in order to check the activation limit.