Comments
Sort by recent activity
Hi Erik,
I assume you are talking about the SQL Server Central 400,000 Member Milestone prize? Did you get the email from them? If so it might be worth talking to them.
Regards,
Tilman / comments
Hi Erik,
I assume you are talking about the SQL Server Central 400,000 Member Milestone prize? Did you get the email from them? If so it might be worth talking to them.
Regards,
Tilman
Hi Pete,
Thanks for posting. You're not the first to request this and it's on our list of things to do.
Regards,
Tilman / comments
Hi Pete,
Thanks for posting. You're not the first to request this and it's on our list of things to do.
Regards,
Tilman
Hi,
SQL Keywords are getting capitalized with no problems, but db objects don't get changed to match how they're actually capitalized within the db itself, unless the candidate list pops up.
I've added a suggestion to our list.
When testing that, I realized that the auto-aliasing doesn't work, either, without the candidate list coming up.
Likewise.
Regards,
Tilman / comments
Hi,
SQL Keywords are getting capitalized with no problems, but db objects don't get changed to match how they're actually capitalized within the db itself, unless the candidate list pops up.
I'v...
Hi,
Afraid I still don't get it. Do you have other statements in your script which could somehow confuse Prompt? If so, could you send me the whole script?
Regards,
Tilman / comments
Hi,
Afraid I still don't get it. Do you have other statements in your script which could somehow confuse Prompt? If so, could you send me the whole script?
Regards,
Tilman
Hi,
sorry for the late reply.
I also find the capitalization annoying at times, but I would like the ability to set the capitalization for reserved words on an individual basis.
I've added a suggestion to our list.
pull my hair out every time it tries to format/suggest/etc when typing in comments (especially headers).
Not quite sure what you mean by 'headers'. Could you explain a bit more? (We are aware of an issue with comments inside stored procedures.)
I also find SQLprompt suggesting words within INSERT strings, such as:
INSERT MyTable (MyColumn) VALUES ('')
When I start typing within the single quotes, the suggestion box comes up.
I wasn't able to reproduce this. Could you give me the exact syntax where things go wrong?
Regards,
Tilman / comments
Hi,
sorry for the late reply.
I also find the capitalization annoying at times, but I would like the ability to set the capitalization for reserved words on an individual basis.
I've added a sugg...
Hi Janez,
Thanks I've added a suggestion to our system.
Regards,
Tilman / comments
Hi Janez,
Thanks I've added a suggestion to our system.
Regards,
Tilman
Hi Janez,
Yes, we changed the behaviour after a lot of people complained that Prompt was popping up too often, thereby getting in their way. (See this forum for related discussions.)
Regards,
Tilman / comments
Hi Janez,
Yes, we changed the behaviour after a lot of people complained that Prompt was popping up too often, thereby getting in their way. (See this forum for related discussions.)
Regards,
Tilman
Hi Janez,
Now, if write the following query (join of the first table with the second and the third):
select * from Visit v
inner join VisitProduct vp
on v.Visit = vp.Visit and v.Employee = vp.Employee
inner join VisitCustomer vc
on v.Visit = vc.Visit and v.Employee = vc.Employee
the SQL Prompt offers me the correct join condititon when I type the join statement for the table VisitProduct (second table). But, when I am typing join for the third table, SQL Prompt only offers me the join condition between the VisitProduct (second table) and VisitCustomer (third table), but it does not offer me the join condition between Visit (first table) and VisitCustomer (third table).
We did this on purpose to avoid cluttering things up too much with lots of join conditions. I've added a suggestion to our system, now. For the moment you could restructure your query, i.e. put 'Visit' in the middle, then you should get the correct suggestions.
And even the join condititon offered between the second and the third table only consists of only one field (e.g. vp.Visit = vc.Visit) and not the complete key.
That is because there is no actual foreign key relationship between VisitProduct and VisitCustomer.
Regards,
Tilman / comments
Hi Janez,
Now, if write the following query (join of the first table with the second and the third):
select * from Visit v
inner join VisitProduct vp
on v.Visit = vp.Visit and v.Employee = vp.Emp...
Hi,
I have pasted queries into a QA window and have had to wait until SQLPrompt finishes its snapshot of the master db. I have seen this slowdown on both small and large databases.
We scan the master database for system stored procedures and such. However, after the first time it should load this information from a file, which should be much faster.
Furthermore, closing a search/replace window takes time after hitting cancel. These slowdowns with QA detract greatly from the advantages of using SQLPrompt.
I was not able to reproduce your problem. Are you using the latest patch (available here http://www.red-gate.com/messageboard/vi ... php?t=4031)?
Regards,
Tilman / comments
Hi,
I have pasted queries into a QA window and have had to wait until SQLPrompt finishes its snapshot of the master db. I have seen this slowdown on both small and large databases.
We scan the m...
Hi,
I notice that you can only cache a DB if you open it in QA or Ent Man. if its possible I think a good option would be to manually add DB to cache. I work with servers that have over 200 db's and it would be nice to just type a few in without having to actually open QA for each.
Could you explain to me why you would want this? I don't see how caching a db without opening an editor is of any use to you.
also it appears the cache deletes upon closing. Keeping the cache would also be helpful. My DB's have around 5000 tables.
I think there is a misunderstanding here. What happens is this: When you first connect to a db, Prompt reads the schema and saves it in a file. The next time you connect to that db, Prompt reads the schema from the file (displaying a similar dialog) which should speed things up.
Regards,
Tilman / comments
Hi,
I notice that you can only cache a DB if you open it in QA or Ent Man. if its possible I think a good option would be to manually add DB to cache. I work with servers that have over 200 db's a...