Comments
Sort by recent activity
Have you logged into the server as the service account to check this? The service account is the context under which xp_cmdshell runs by default. alternatively, if you are on a later version of SQL, you can set a proxy for the xp_cmdshell, which might give you the context for licensing. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xp-cmdshell-proxy-account-transact-sql
It's possible that the install of Compare on the server is only for one account.
are you using the full path to the SQL Compare executable? can you post the commands? / comments
Have you logged into the server as the service account to check this? The service account is the context under which xp_cmdshell runs by default. alternatively, if you are on a later version of SQL...
Is SQL Compare installed on the server? The context for xp_cmdshell is a folder on the server. If you can run SQL Compare from the command line on the server, with the service account context, this should work. / comments
Is SQL Compare installed on the server? The context for xp_cmdshell is a folder on the server. If you can run SQL Compare from the command line on the server, with the service account context, this...
I would view this as a nice to have, and certainly a place where I could perhaps improve the code. I'd certainly like a good list that I could use to get counts of how often some of this is used, to show if this is a potential large scale problem.
These aren't necessarily performance problems (though they could be). These are often indicators or potential other problems that could cause the code to behave poorly. As such, this could be somewhat distracting when looking to solve a specific issue.
OTOH, I need to ensure if I modify the rules for SQL Code Guard, I can modify them here. I shouldn't have to say that sp_, or some generic rules needs to be an issue.
In looking at the feature, it can be hard to see the lines, especially if I am actually working on some other aspect of monitoring. I'd prefer to see that you have a list somewhere, or a button that says "CodeGuard Analysis" that would list all the places and rules that are an issue. However, in a large list, I might need to be able to ignore some of these. It's entirely possible that something like NOLOCK is a fundamental embedded code item in the application (say for a Dynamics database) and I can't change it. Don't want to be constantly reminded that I can't fix this. / comments
I would view this as a nice to have, and certainly a place where I could perhaps improve the code. I'd certainly like a good list that I could use to get counts of how often some of this is used, t...
The difference pane shows the differences since you can view them without actually selecting the object. When you select the "row", the differences are shown. That way you can decide what is happening with the object.
As Jessica mentioned, CTRL+click will go a little quicker. / comments
The difference pane shows the differences since you can view them without actually selecting the object. When you select the "row", the differences are shown. That way you can decide what is happe...
Could I get one that says "The Voice"? / comments
Could I get one that says "The Voice"?
Maybe badges like:
"Hub Contributor", "Hub Member", "Inquisitive" (asking a question), "Helper" (answer), etc. / comments
Maybe badges like:
"Hub Contributor", "Hub Member", "Inquisitive" (asking a question), "Helper" (answer), etc.
I'm not sure what you mean here. If you are using git, then you connect to your git repository. The TFS part doesn't matter. If you are trying to connect to the TFS git repository on the server, you're incorrectly setting this up. I use TFS online and the git interface with SQL Source Control. You should have a cloned repository on your local system that you setup as a git cloned repo from TFS. When linking to the database, choose Git, not TFS. / comments
I'm not sure what you mean here. If you are using git, then you connect to your git repository. The TFS part doesn't matter. If you are trying to connect to the TFS git repository on the server, yo...
Also, which SQL Source Control version? / comments
Also, which SQL Source Control version?
I wasn't sure what you were doing. Is there a reason you can't set a git repository on your machine that points to a remote in TFS? I haven't tried the git in TFS. I've used TFS or I've used git that points to the repo in TFS. / comments
I wasn't sure what you were doing. Is there a reason you can't set a git repository on your machine that points to a remote in TFS? I haven't tried the git in TFS. I've used TFS or I've used git th...
If you are using the git interface, that should be the URL you include. For example, I have the local path for my git repo.
For TFS, you should have entered the entire TFS url to your repo. This can include the /tfs item in your setup. Check that tab when your database is selected. / comments
If you are using the git interface, that should be the URL you include. For example, I have the local path for my git repo.
For TFS, you should have entered the entire TFS url to your repo. This ca...