Comments
Sort by recent activity
The only way to run a very large SQL script in SSMS is to break up the script into small sections with COMMIT statements. This means that you have to parse the script with a utility and insert COMMIT<return>BEGIN TRANSACTION lines.
As transactional integrity may be compromised then you will have to take full backup before running the script of course. / comments
The only way to run a very large SQL script in SSMS is to break up the script into small sections with COMMIT statements. This means that you have to parse the script with a utility and insert COM...
I find that alias selection seems to work OK. Set Auto Insert / Enable alias assigment ON. If you type a statement from Northwind:
SELECT * FROM [Categories] AS C,[Employees] AS E
then place your cursor back into the statement to the *, type c. and you will have
SELECT c.* from [Categories] AS C,[Employees] AS E
you will find only fields referring to Categories are displayed as choices. / comments
I find that alias selection seems to work OK. Set Auto Insert / Enable alias assigment ON. If you type a statement from Northwind:
SELECT * FROM [Categories] AS C,[Employees] AS E
then place your ...
Apologies but I had already found previously that your temp tables example also worked OK. Could you please refresh the cache by deleting the contents of the folder C:\Profiles\<user name>\Local Settings\Application Data\Red Gate\SQL Prompt 3 and try again please / comments
Apologies but I had already found previously that your temp tables example also worked OK. Could you please refresh the cache by deleting the contents of the folderC:\Profiles\<user name>\Local Se...
Thanks for pointing this out - I have placed this in our bug database as SP-1223 and will get back to about developments. / comments
Thanks for pointing this out - I have placed this in our bug database as SP-1223 and will get back to about developments.
You can do this by looking at SQL Prompt Options/Connections and look on the Login Credentials tab, and creating a New connection to SQL Servers and databases. / comments
You can do this by looking at SQL Prompt Options/Connections and look on the Login Credentials tab, and creating a New connection to SQL Servers and databases.
Unfortunately you have to keep the cache refreshed. This is necessary as caching in real time would slow Prompt to a crawl if you have any number of databases and large scripts to trawl through constantly. / comments
Unfortunately you have to keep the cache refreshed. This is necessary as caching in real time would slow Prompt to a crawl if you have any number of databases and large scripts to trawl through con...
Did you use the 'Refresh All' button from the SQL Prompt Cache Management dialogue box?
You should also have the 'Refresh the cache when opening a new query editor instance' ON too. / comments
Did you use the 'Refresh All' button from the SQL Prompt Cache Management dialogue box?
You should also have the 'Refresh the cache when opening a new query editor instance' ON too.
Unfortunately you have to be a member of a group that has read access to this table in order for Prompt to work. / comments
Unfortunately you have to be a member of a group that has read access to this table in order for Prompt to work.
When you have created the diagram you have the option on the right of the screen to add/remove foreign keys. You also have options on the menu bar to translate constraints into objects and display Filegroup and system dependencies. These are optional for clarity reasons. In this way you can display the database in any way you wish. / comments
When you have created the diagram you have the option on the right of the screen to add/remove foreign keys. You also have options on the menu bar to translate constraints into objects and display ...
Unfortunately there isn't a way to increase the font size directly - but there is a method to zoom into the diagram to examine it on the screen. You can also change the number of pages on which the diagram will be printed, thereby changing the font readability. / comments
Unfortunately there isn't a way to increase the font size directly - but there is a method to zoom into the diagram to examine it on the screen. You can also change the number of pages on which th...