Comments
Sort by recent activity
Hi,
Please see this thread http://www.red-gate.com/MessageBoard/vi ... php?t=3850
Regards,
Tilman / comments
Hi,
Please see this threadhttp://www.red-gate.com/MessageBoard/vi ... php?t=3850
Regards,
Tilman
I've also got SQL2005 SP1 and I get all these. Could it be that you don't have sufficient permissions?
We currently can't show columns of system views in SQL2005. This is a known issue. We will try to fix it in a future version.
Regards,
Tilman / comments
I've also got SQL2005 SP1 and I get all these. Could it be that you don't have sufficient permissions?
We currently can't show columns of system views in SQL2005. This is a known issue. We will try...
Hi,
I do get the views in the information_schema schema, in particular, the 'columns' view is there. Could it be that you don't have sufficient permissions?
Regards,
Tilman / comments
Hi,
I do get the views in the information_schema schema, in particular, the 'columns' view is there. Could it be that you don't have sufficient permissions?
Regards,
Tilman
Hi,
Could you be a bit more specific. E.g. what is the statement you are writing? Which views would you expect, etc. Also, which version of SQL Server are you using?
Regards,
Tilman / comments
Hi,
Could you be a bit more specific. E.g. what is the statement you are writing? Which views would you expect, etc. Also, which version of SQL Server are you using?
Regards,
Tilman
Hi,
Thanks for posting. I'm afraid I can't reproduce your problem. Or maybe I don't quite understand what you are after.
My problem is that when I connect using user A that is the owner of schema A, I need to refresh the cache explicitly by using the cache management.
Why do you need to refresh the cache? Has the schema changed? Is the candidate list empty?
Howver, when I change connection, I can see that SQLPROMPT is refreshing the cache. My question is why do I need to refresh the cache when I change form connection to another?
One reason is, that if the new user doesn't have access to the database we don't want to display the objects. Is this causing a problem for you?
Regards,
Tilman / comments
Hi,
Thanks for posting. I'm afraid I can't reproduce your problem. Or maybe I don't quite understand what you are after.
My problem is that when I connect using user A that is the owner of schema ...
Hi Esio,
I've added a suggestion to our list.
Thanks,
Tilman / comments
Hi Esio,
I've added a suggestion to our list.
Thanks,
Tilman
Hi,
I think what you are encountering is the problem that we can't get information about parameters of system stored procedures in SQL Server 2005. I.e. when I do
exec sp_help
in SQL Server 2005 I don't get parameters, in SQL Server 2000 I do.
I'm afraid that is a limitation we can't get round at the moment.
Regards,
Tilman / comments
Hi,
I think what you are encountering is the problem that we can't get information about parameters of system stored procedures in SQL Server 2005. I.e. when I do
exec sp_help
in SQL Server 2005 I ...
I agree that Prompt 3 is too invasive. I am constantly having to hit escape to close the box or backspace to erase things that I did not want.
Bagging this product as usless to me. Very disappointing as I was enthused by Prompt 2 and it really was an aid to speeding up my work.
Sorry to dissappoint you and thank you for your comments. We are aware that the product needs improving in this area and will try to best to acommodate everyone's needs.
Regards,
Tilman / comments
I agree that Prompt 3 is too invasive. I am constantly having to hit escape to close the box or backspace to erase things that I did not want.
Bagging this product as usless to me. Very disappoi...
Hi Emmanuel,
Thanks for the feedback. I've added it to our list.
Regards,
Tilman / comments
Hi Emmanuel,
Thanks for the feedback. I've added it to our list.
Regards,
Tilman
Hi Emmanuel,
In general, the more valid your SQL is, the better Prompt works. So I'd advise you to always put the '*' and then replace it later with a specific column list.
Regards,
Tilman / comments
Hi Emmanuel,
In general, the more valid your SQL is, the better Prompt works. So I'd advise you to always put the '*' and then replace it later with a specific column list.
Regards,
Tilman