Ok, first request: I have "Surround with square brackets []" turned on as well as "Prefix with owner/schema". This is how I like to write my sql statements, with those options. This is something I would like SQL Prompt to do though... Write now with the intellisense, when it brings up a list of the tables, it has "[dbo].[FooTable]" "[dbo].[BarTable]" etc... but for me to use the intellisense correctly with "type ahead", i have to actually type out the brackets. I would like it if SQL Prompt would not require me to type the brackets for the intellisense to work. If the intellisense table list is open I would rather it just allow me to type dbo instead of [dbo]. If I type just dbo, I would like it to replace it with [dbo]. Make sense? Also, since this is just the owner/schema, I would like to forego even having to type the dbo at all. I would like to just be able to type FooTable and then have it insert "[dbo].[FooTable]". As of right now the type ahead intellisense doesn't save me as much typing as i would like it to because I have to manually type the brackets and because I can't skip the owner/schema (even though I want the owner/schema in the resulting code). I hope this makes sense.
Another thing I would like to see is the storing of the settings in an ini or config file or something. I have SQL Prompt installed on a 120Gb Portable USB drive so that I can use it from different places. I currently develop on a minimum of 3 systems (Desktop, Laptop, Workstation). And so it would be nice to have the settings be file based, as then I would have the same settings and "Connections" from anywhere that I open the program. This would be much more useful for me.
One more feature I would like is for the program to be able to save a "Server Connection" instead of just a "Database Connection". It would be nice to be able to save connection settings for a server instead of for a database. Say i have server123 with 25 databases, but all my database logins are the same on that server. Right now SQL Prompt needs to save all 25 database connections. And each time I need to use SQL Prompt with a different database on that same server, I basically have to create a duplicate connection to the server with the only difference being the database name. But the username and the password are the same. So, for me, it would be nice to create a connection to the server with username "ABC" and password "123", and then have SQL Prompt try this login information for every database on that server that I try to connect to. And then if that login fails, it can prompt me to save a direct connection to the individual database that I am trying to connect to. Make sense?
Well, those are a few little things that I would like to see in SQL Prompt. I hope my descriptions made sense are and adequate.
Hi,
Another thing I would like to see is the storing of the settings in an ini or config file or something. I have SQL Prompt installed on a 120Gb Portable USB drive so that I can use it from different places. I currently develop on a minimum of 3 systems (Desktop, Laptop, Workstation). And so it would be nice to have the settings be file based, as then I would have the same settings and "Connections" from anywhere that I open the program. This would be much more useful for me.
One more feature I would like is for the program to be able to save a "Server Connection" instead of just a "Database Connection". It would be nice to be able to save connection settings for a server instead of for a database. Say i have server123 with 25 databases, but all my database logins are the same on that server. Right now SQL Prompt needs to save all 25 database connections. And each time I need to use SQL Prompt with a different database on that same server, I basically have to create a duplicate connection to the server with the only difference being the database name. But the username and the password are the same. So, for me, it would be nice to create a connection to the server with username "ABC" and password "123", and then have SQL Prompt try this login information for every database on that server that I try to connect to. And then if that login fails, it can prompt me to save a direct connection to the individual database that I am trying to connect to. Make sense?
Well, those are a few little things that I would like to see in SQL Prompt. I hope my descriptions made sense are and adequate.