Activity overview
Latest activity by pkmccarthy
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?
change in functionality request...
when i point sql prompt at a large database (peoplesoft FMS has 40,000 tables, peoplesoft HCM has 18,000 tables and peoplesoft CRM has 8,000 tables) -- the caching either takes forever or never fin...
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...
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...
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...