User profile for david connell

Hi David Thanks for your comments. I have some questions for you. Do you use a standard too to generate these embedded comments? If not why do you use ##SUMMARY etc? Which version of SQL Server are you using? Does anyone else (ie other companies) do similar things and if so do you know what? Regards David / comments

Hi David Thanks for your comments. I have some questions for you. Do you use a standard too to generate these embedded comments? If not why do you use ##SUMMARY etc? Which version of SQL Server are...

0 votes

Hi Rick, I like your thinking but nothing intentional from the SQL Doc end. I have spoken to Bart (one of the lead developers on SQL Dependency Tracker) and he said that if you exported the image out of Dependency Tracker as a meta file, you could in theory generate an image map that hooked up to the relevant HTML pages. This would be very time consuming but theortically possible. Sorry not to be more helpful. Regards David / comments

Hi Rick, I like your thinking but nothing intentional from the SQL Doc end. I have spoken to Bart (one of the lead developers on SQL Dependency Tracker) and he said that if you exported the image o...

0 votes

Hi Chris, For clarification, you will not get "Used By"s for objects that relate to a database that is not being documented. The way to get round this is to document something from that database eg a user that should be enough... Regards Michelle. / comments

Hi Chris, For clarification, you will not get "Used By"s for objects that relate to a database that is not being documented. The way to get round this is to document something from that database eg...

0 votes

Hi Andrew, I presume from your question you are refering to MS Help 2 (.HsX) I donot think that we will be supporting this style of help in the upcomming release 1.1. However there is a Microsoft utility called HxConv.exe that is meant to convert between CHM and HsX files. It is meant to do a reasonable job, however I have never used it, but it could be a useful tool. Hope that helps David Connell / comments

Hi Andrew, I presume from your question you are refering to MS Help 2 (.HsX) I donot think that we will be supporting this style of help in the upcomming release 1.1. However there is a Microsoft u...

0 votes

Hi Chris, Thanks for the comments... I am pretty sure that non-documented objects will be listed in the used/Used by section at the bottom of the object. However the item will not be hyperlinked as there is no object to link it to. Inter database depencies are not so clear cut. I think that if you document database a & database B at the same time then the inter-dependancy will be shown either as a link, if both objects are documented with out a link if the target object was excluded from documentation. Not at all! Because the link could only be found from the object that is being ignored So you would need to document at the same time the other database(s) where you know their to be dependancies. Thank you for explaining the global settings for filters... Regards David / comments

Hi Chris, Thanks for the comments... I am pretty sure that non-documented objects will be listed in the used/Used by section at the bottom of the object. However the item will not be hyperlinked as...

0 votes

Hi there, Great idea about sorting on by the columns. I'll put that forward. If you document two databases at once, the interdatabase dependancy will show up at the bottom of the pages on the generated report. (These are not displayed in the preview page). Please note that all links are disabled when viewing the preview page. (The only exception is editing the descriptions.) The tabs in the SQL Script are changed to 4 non-breaking spaces. I will go and double check that this does work as I have just mentioned. Thank you for your comments. Best regards David / comments

Hi there, Great idea about sorting on by the columns. I'll put that forward. If you document two databases at once, the interdatabase dependancy will show up at the bottom of the pages on the gener...

0 votes

Hi Chris, Thanks for you comments. 1) Yes column dependencies is on our wish list too. However I donot believe that it will not be covered in the upcoming V1.1 release. 2) On the tree view on the left hand side you can select checkboxes from anywhere in the tree. (eg on Views for a database.) Won't this give you the action you wanted? 3) Database modelling tool - I will pass your request on... Best Regards David / comments

Hi Chris, Thanks for you comments. 1) Yes column dependencies is on our wish list too. However I donot believe that it will not be covered in the upcoming V1.1 release. 2) On the tree view on the ...

0 votes

Hi Dave, I think that Brian is correct. I donot believe that SQL Server will cache the the system tables that define the database (unless you request the information loads and loads for that database). As a result SQL will be forced to go back to disk to retrieve the information. Because you are requesting the information from one SQL Server instance the information will be disk bound, and as a result the registering of databases on the same sql server instance will end up by being sequential. (I donot know what would happen if you put your databases onto two physically different disks? Also if you have multiple SQL Server instances on one physical machine, this may also suffer in the same way.) We are not pooling our connections, however we will only use one connection per registering each database. We are not using the threadpool in our SQL Compare Engine code. If you really want I can show you a way to pool connections. However I believe that in the past this level of optimization has caused considerable problems and Red Gate does not currently recommend it. Hope that helps David Connell / comments

Hi Dave, I think that Brian is correct. I donot believe that SQL Server will cache the the system tables that define the database (unless you request the information loads and loads for that datab...

0 votes

Hi there, Can you please do the following, 1) start up a DOS box 2) go to the directory that SQL Compare is installed in 3) type the following command C:Program Files\Red Gate\SQL Bundle 5\>RedGate.SQLCompare.UI.exe 2>error.log This should then copy the actual exception being generated into the file called error.log. 4) Please email me the error file. (david.connell@redgate.com) Thanks David / comments

Hi there, Can you please do the following, 1) start up a DOS box 2) go to the directory that SQL Compare is installed in 3) type the following command C:Program Files\Red Gate\SQL Bundle 5\>RedGat...

0 votes

Hi there, We have just run SQL Compare on a Windows 2000 Server SP4 system with SQL Server 2000 installed and it all worked fine. Have you got any information about the Exception that is being generated please. Regards David / comments

Hi there, We have just run SQL Compare on a Windows 2000 Server SP4 system with SQL Server 2000 installed and it all worked fine. Have you got any information about the Exception that is being gene...

0 votes

How can we help you today?

david connell

Comments