Posts
Sort by recent activity
tooltip meta data for schema_name
I don't know where sql prompt gets its meta data for the tooltips which are displayed when using functions but curiously....
...it says that schema_name returns an int!
This doesnt really bother me...
Bug in "Qualify Object Names" introduced bug in my code!
SELECT onfile.DealReference
dbo.DCA_Detail AS onfile
WHERE onfile.DealReference NOT IN (
SELECT DealReference
...
Why not just use visual studio?
I've been a happy and regular user of SQL Compare for a number of years. However my boss doesn't want to renew the licenses as he says Visual Studio (certain editions) can offer all the same funct...
Document All objects - command line support.
I'd like to use the command line option to periodically redocument databases. I note however that the objects to be documented are explicitly listed in the .sqldoc xml document. (I'm not sure the...