Comments
Sort by recent activity
I have a similar dev/production situation & ideally I would like to be able to configure SQLPrompt to never connect to certain servers - so that the authentication box never pops up for those servers.
Neil / comments
I have a similar dev/production situation & ideally I would like to be able to configure SQLPrompt to never connect to certain servers - so that the authentication box never pops up for those serve...
Ahah! It turns out that you're right. In the source database the name has a lower case U, but the DDL contains an upper case U ....
Of course when it got synchronised, the DDL created an SP in the destination database using the upper case version.
I was sure I'd checked that when I first saw the problem ... but it's an easy one to miss even when it's right infront of your nose.
Feel free to rename this topic's subject to 'Idiot User' rather than 'Bug Report' [image]
Many Thanks,
Neil / comments
Ahah! It turns out that you're right. In the source database the name has a lower case U, but the DDL contains an upper case U ....
Of course when it got synchronised, the DDL created an SP in the...
The SPs are owned by dbo in both databases both before and after synchronization. The synchronization is run from a saved SQL Compare project that uses sa logins to both databases. All other stored procedures in the database have the same ownership and do not have a problem. / comments
The SPs are owned by dbo in both databases both before and after synchronization. The synchronization is run from a saved SQL Compare project that uses sa logins to both databases. All other stor...