Activity overview
Latest activity by austrianfoodispuke
prevent unique constraint from being scripted?
I am creating a script that will drop database objects.
However, it is including unique constraints in the script.
The problem is, the next time the database is created, the constraints are differe...
"authenticate" popup despite disabling sqlprompt
I'm getting this whenever I switch to one particular tab.
Why is this occuring when I have specifically disabled prompt on the menu?
It's driving me nuts
e.g.
SELECT ...
FROM tableA A
INNER JOIN tableB B on A.ID = B.ID
LEFT OUTER JOIN tableC C ON C.val = B.val
would show a simple diagram showing 3 tables (no columns) with lines linking A to B, B to C
perhaps also showing the aliases of the tables and the IDs with which they're linked
[I guess you could always extend this so clicking on any table highlights output columns within the text] / comments
e.g.
SELECT ...
FROM tableA A
INNER JOIN tableB B on A.ID = B.ID
LEFT OUTER JOIN tableC C ON C.val = B.val
would show a simple diagram showing 3 tables (no columns) with lines linking A to B, B to ...
quick ER diagram from script
I'm currently working with an unfamiliar db and would at times be aided by the ability of viewing an ER diagram of the query.
SSMS does not seem to have such functionality, can this be added to pro...
table/view data sample (similar to table/view def'n preview)
Is it possible to get it to pop up some sample data when viewing the table definition, with the options for
select top X <optional> * from table order by newid() <optional>
cache the result <optional>
hover over table/view to popup defn (same as typing it out)
When you type a table name out, you can set the option to view the table or view definition.
Why can't this happen when just hovering over it?
I keep having to go and edit the table name to get it ...
GROUP|ORDER BY to filter by useable values rather than all
after GROUP BY or ORDER BY
why can't prompt show you a list of only those values which are valid?
This is especially annoying when you have to add a case statement in or are using other complex logic
It's just running the "sqlcompare.exe -blah -blah -blah" tool
It runs ok, but one of the scripts is causing it to fail and I don't know which one.
Using the /verbose switch does not help either / comments
It's just running the "sqlcompare.exe -blah -blah -blah" tool
It runs ok, but one of the scripts is causing it to fail and I don't know which one.
Using the /verbose switch does not help either
generate script execution order from cmd?
does this tool have a cmd interface?
if so:
can you use it to generate the run order of a bunch of sql scripts (views, funcs, procs)
The database I mentioned will run standalone.
The parts we add are not depended on by the standalone part.
e.g. we might have views, procs, functions that use all this
Perhaps think of it like a wrapper.
There are releases from the 3rd party company (who someone else looks after) which are frequently applied to the db - we don't see this until it is in production.
I want to take the latest version of the db (including any 3rd party updates) and add the latest verison of all of our 'extensions' currently under development'
Everything appears to work, get the db, restore, get our code from source control, populate the tags.
But when I do a sync between the newly copied version of prod (now in dev) and the scripts we have (ordered in folders), I'm not getting a combination of "prod+scripts" instead I just get "scripts". It is dropping everything that is not in the "scripts" folders.
I don't understand why this should be as when using the GUI you can select from the 4 groups:
Identical in A and B
Only in A
Only in B
Different in A and B
So why is using "/sync" causing it to drop stuff? / comments
The database I mentioned will run standalone.
The parts we add are not depended on by the standalone part.
e.g. we might have views, procs, functions that use all this
Perhaps think of it like a wr...