Comments
Sort by recent activity
Can you tell us if its an explicit permissions issue we could set in the db or is it due to redgate using a separate thread to connect to the db that doesnt have AD integrated mode available -- said another way, any work around? / comments
Can you tell us if its an explicit permissions issue we could set in the db or is it due to redgate using a separate thread to connect to the db that doesnt have AD integrated mode available -- sai...
i finally remembered to give you a screen shot of the issue i am having... however, it doesnt appear i can post it here - how do i get you the screen shot showing its bringing back more column lists than the table i am prompting for? / comments
i finally remembered to give you a screen shot of the issue i am having... however, it doesnt appear i can post it here - how do i get you the screen shot showing its bringing back more column list...
Brian, thanks for the response - as with most sql tools products i use, they always seem to have a hard time with large databases --
i look forward to the maturing of this product to the level of the other tools i have used in the past... (i would worry though, if the cache is read completely into memory upon connecting to that db; in my case, i may run out of memory before even getting the benefits of localized cached version of my db schema...)
thanks again.... / comments
Brian, thanks for the response - as with most sql tools products i use, they always seem to have a hard time with large databases --
i look forward to the maturing of this product to the level of t...
let me also put the cache issue another way...
i have peoplesoft fms with 40k tables and 30k views... it has yet to cache the db correctly and renders the intellisense partially useless... maybe i should consider this an application bug instead?
thanks again.... / comments
let me also put the cache issue another way...
i have peoplesoft fms with 40k tables and 30k views... it has yet to cache the db correctly and renders the intellisense partially useless... maybe i...
1) with regard to the competitor product (aqua data) please take a minute to download the trial and at least see what i am talking about -- even without looking at the competitor i am requesting the following featureset:
the ability to not have it cache my db schema to my hard-drive; the ability to have it not auto-invoke intellisense (only when i press the key combo should it invoke - this is a common feature in most intellisense installs) - lastly, when i invoke the intellisense it uses only the data at hand to give me the results...
example - i type the following:
SELECT * FROM PS_RD_
with the cursor placed right after the second underscore, i press the key combo to invoke intellisense, at this point it queries the SYSOBJECTS table (or whatever your code does) and only brings back objects starting with "PS_RD_" -- this appears very fast in the competitors apps and should be very fast since the name column of sysobjects is indexed....
2) with regard to the X. example in my previous post - the intellisense window shows the column name AND the table name it comes from when i invoke intellisense -- i will go back and get a screen shot of the issue....
thanks for your time on this request - i love the product but it has issues with databases that have objects in the several thousands.... / comments
1) with regard to the competitor product (aqua data) please take a minute to download the trial and at least see what i am talking about -- even without looking at the competitor i am requesting th...
no response from red-gate? / comments
no response from red-gate?
i am not in front of an xp machine right now - but approximately this...
c:\documents and settings\your profile name\application data\local...\....[the rest of the path in the message above]
or you can just search your harddisk for the xml file name too... / comments
i am not in front of an xp machine right now - but approximately this...
c:\documents and settings\your profile name\application data\local...\....[the rest of the path in the message above]
or you...
i see in this forum the copy/paste has been reported for a while as an issue in the options-snippit window... i see its still not fixed...
is there any workaround - can i put it in a file on the local disk that prompt reads from? i would hate to type the lines i have to paste... / comments
i see in this forum the copy/paste has been reported for a while as an issue in the options-snippit window... i see its still not fixed...
is there any workaround - can i put it in a file on the lo...
Look for the file:
SQL Prompt 3 Snippets.xml
in Vista its in:
C:\Users\YOURUSER-SAMACCOUNTNAME\AppData\Local\Red Gate\SQL Prompt 3to make it easy i created a snippit thru the options screen just to get it to create all the nodes... then i went into the xml file and replaced the <Code> text.... I tested using the CDATA tag so that the xml parser wouldnt trip over my sql - it worked great.....
<Code>
<![CDATA[
YOUR SQL SNIPPIT GOES HERE
]]>
</Code> / comments
Look for the file:
SQL Prompt 3 Snippets.xml
in Vista its in:
C:\Users\YOURUSER-SAMACCOUNTNAME\AppData\Local\Red Gate\SQL Prompt 3to make it easy i created a snippit thru the options screen just to...
Lurks, so you went from Xpress Apps to Imceda then to Quest.... you have had a turbulant ride...
I loved the speed ide tool - getting a key from quest when you move the software to a new machine is painful - they dont understand what a perpetual software license is - but i digress...
what i really liked was that it could read ahead and behind and figure out the table allias for intellisense - i liked that you could delay the intelli until you prompted for it -- i work on peoplesoft dbs often and the FMS db from peoplesoft has 40,000 tables - it chokes every app except speed...
i also liked the two dropdowns to change SERVER and DB in the same window - what an awesome feature...
if you are stil at quest - i hope you can do your magic there - if not, i cant wait to see what you build whereever you are at now... / comments
Lurks, so you went from Xpress Apps to Imceda then to Quest.... you have had a turbulant ride...
I loved the speed ide tool - getting a key from quest when you move the software to a new machine i...