Comments
Sort by recent activity
Hey @kyle_vaske
could you please add further details? Please include the error stack trace (you should see the error in details clicking on the error link, if present) and also the repro step.
Are you replacing the database without re-linking it?
Thanks / comments
Hey @kyle_vaske
could you please add further details? Please include the error stack trace (you should see the error in details clicking on the error link, if present) and also the repro step.
Are ...
In addition to the @Grant's suggestion, if you have just a few linked server hard coded and if you can change the code, you could consider replacing them with synonyms (that point to the linked server objects).
I know, it's a refactor and it can be potentially massive, but I think that you'll get many advantages.
just my two cents,
cheers / comments
In addition to the @Grant's suggestion, if you have just a few linked server hard coded and if you can change the code, you could consider replacing them with synonyms (that point to the linked ser...
Yes @Grant, I'm totally with you. It's often a stressing-and-heavy work to do, but leaving the code as is leads to code smells sometimes :-).
[OOT]
I know that you agree with me (I really hope :-) ) when I say that whether we'd like to be more "DevOps", we should invest some effort in changing small chunks step by step, in order to get a real sandbox in development stage and, in this case too, give value to the customers (quicker releases, more test isolation and automation, and so on).
[/OOT] / comments
Yes @Grant, I'm totally with you. It's often a stressing-and-heavy work to do, but leaving the code as is leads to code smells sometimes :-).
[OOT]
I know that you agree with me (I really hope :-) ...
hey @...,
having the same object name is a problem if you don't specify the two part name (ex. Schema.Table). It works by default if you have the objects under the dbo schema (or the default one of the user which executes the script). It depends on how the script has been created. However, this should not work also after the restore. But if I got it, the second time you tried, the script ran successfully.
So, I guess that there was a "open transaction" problem. Something that created objects, not committed, or simply stuck in the middle on the, let's say, "first database". I know, it sounds weird, but I had similar problem. I could not see objects which were created and I had a database file corruption (or a disk failure I don't remember right now actually).
What do you think about this possibility? / comments
hey @...,
having the same object name is a problem if you don't specify the two part name (ex. Schema.Table). It works by default if you have the objects under the dbo schema (or the default one of...
hi GeoRewind,
I cannot understand why you need a comparison criteria like this one. Does this mean that you change the structure directly in production, so the target database drifts before you release? In a straight release strategy I'd expect a dev/test environment to be ahead than the production, regardless the date in which a column is changed.
If you change something in the target database, you can "merge back" the changes or resolve conflicts before release the new version of the database.
Did I get? / comments
hi GeoRewind,
I cannot understand why you need a comparison criteria like this one. Does this mean that you change the structure directly in production, so the target database drifts before you rel...
Rog wrote: »
Is there a way I can run this on specific objects instead of an entire database?
you're right, I confused that feature with "find unused items" in scripts.
You mentioned "it's breaking at the same place", which is? Right after the click?
In order to understand better, you could trace the commands using SQL Profiler. It could be some trouble in your user's permission set. / comments
Rog wrote: »
Is there a way I can run this on specific objects instead of an entire database?
you're right, I confused that feature with "find unused items" in scripts.
You mentioned "it's bre...
hi @Rog,
does this happen on all the objects you check? / comments
hi @Rog,
does this happen on all the objects you check?
Hi chenchen300,
you cannot ignore the name of the objects in that way. How can you say that they are "the same thing"? / comments
Hi chenchen300,
you cannot ignore the name of the objects in that way. How can you say that they are "the same thing"?
Hi @...,
did you try to check into the Windows log via Event Viewer? If you cannot open the SQL Compare UI, you may not be able to enable the verbose logging, so you need to start from scratch. Check the Windows logs and let us know.
cheers / comments
Hi @...,
did you try to check into the Windows log via Event Viewer? If you cannot open the SQL Compare UI, you may not be able to enable the verbose logging, so you need to start from scratch. Che...
hi @Tianjiao_Li,
thanks for the mention. That is my blog and the link you're suggesting summarizes the usage of the project I've posted in my previous post.
so, Thanks :-) / comments
hi @Tianjiao_Li,
thanks for the mention. That is my blog and the link you're suggesting summarizes the usage of the project I've posted in my previous post.
so, Thanks :-)