Comments
Sort by recent activity
I'll email you a screen shot... / comments
I'll email you a screen shot...
oops, I just found it, but you have to right-click in the differences area to get the option. Glad it's still there. / comments
oops, I just found it, but you have to right-click in the differences area to get the option. Glad it's still there.
Correct, I was just posting a reply to Michelle's question. / comments
Correct, I was just posting a reply to Michelle's question.
* The most common mapping error we get, because of source control, are duplicate files.
"A duplicate definition for the table dbo.TableName has been found while processing the script database. . . . " / comments
* The most common mapping error we get, because of source control, are duplicate files.
"A duplicate definition for the table dbo.TableName has been found while processing the script database. . ....
I'll see if I can get an example of the triggers - and make sure that's really what I saw happening as I was in a hurry [image] / comments
I'll see if I can get an example of the triggers - and make sure that's really what I saw happening as I was in a hurry
And the resulting deploy script does this:
PRINT N'Altering permissions on [dbo].[GetWebinarEmailsAsFetchXmlValues]'
GO
GRANT EXEC ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]
GO
REVOKE EXECUTE ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]
which actually revokes the permission it just gave resulting in a real difference and creates a never ending loop of differences if you continue to run the deploy scripts one after the other. / comments
And the resulting deploy script does this:
PRINT N'Altering permissions on [dbo].[GetWebinarEmailsAsFetchXmlValues]'
GO
GRANT EXEC ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]
GO
REVOKE ...
(removed) / comments
(removed)
Yes, we are also thinking of using this method to store object definitions in source control. We'd like to use sql compare to compare our source control scripts to what's on a given server, however, sql compare marks the objects as different because what it gets from the server has CREATE and what it gets from source control says ALTER. That is the only difference. Is there an option to ignore these differences? / comments
Yes, we are also thinking of using this method to store object definitions in source control. We'd like to use sql compare to compare our source control scripts to what's on a given server, howeve...
Could you include the ability to select a snippet file from a network location? We'd utilize this feature to share snippets across our team. It is especially useful for things that need to stay identical such as stored procedure templates that will end up creating a new proc stored in source control.
thanks / comments
Could you include the ability to select a snippet file from a network location? We'd utilize this feature to share snippets across our team. It is especially useful for things that need to stay i...
Yes, that's what I meant...I was trying to describe the little button that is just above the main scrollbar in sql mgmt studio that you can click and drag to split your window. Same function.
I wrote this post to make people aware of the bug so they can avoid it, as it's not a very nice one to find, more than to complain about it. It's easy enough to work around. Good product overall. thanks / comments
Yes, that's what I meant...I was trying to describe the little button that is just above the main scrollbar in sql mgmt studio that you can click and drag to split your window. Same function.
I wr...