Activity overview
Latest activity by ivanrdgz
DBCC TRACEOFF 3604 messages going to the errorlog
Hi guys,
DBCC TRACEON / TRACEOFF 3604 messages are going to the error log every couple of seconds. It is a nightmare if you need to look for something in the error log. Is there anyway to prevent t...
eddie davis wrote:
Thank you for your reply.
The option to exclude SQL Prompt accessing SQL instances has been removed. Is this an option you would like to see returned to the product?
Many Thanks
Eddie
Definitely. For example, we have a policy again using any third party tool directly on production environment. Lame or no, but it is a policy we have to obey.
I did notice the improvement on speed but still need more time to test this release before I put a fight to abolish that policy, at least with respect to SQL Prompt [image] / comments
eddie davis wrote:
Thank you for your reply.
The option to exclude SQL Prompt accessing SQL instances has been removed. Is this an option you would like to see returned to the product?
Many Than...
My main question was how do I prevent SQL Prompt from accessing a SQL instance?
eddie davis wrote:
Thank you for your post into the forum.
There is no longer cache management in SQL Prompt V4.
The SQL Prompt caching mechanism was modified or improved with the release of SQL Prompt V4, so the cache management settings in Version 3 no longer apply.
If you are writing a query on a database while someone else is making changes to the structure of that database, the suggestions offered by SQL Prompt may become out of date.
For example, if someone has added several tables to the database while you have been connected to that database, these tables will not appear in the suggestions box.
To reload the database objects, on the SQL Prompt 4 menu, select Refresh Suggestions or press Ctrl + Shift + D. Any changes to the database structure will now be reflected in the suggestions box.
You should also refresh suggestions when you have created a new object in the current query, and executed that block of code. For example, if you create a table NewObject and execute the statement, then continue to write the query, the NewObject table will not appear in the suggestions box until you refresh the suggestions.
Refreshing suggestions applies only to the database to which you are currently connected.
SQL Prompt automatically refreshes a database's objects when you close down your query editor application, then re-open it and re-connect to that database.
I hope the above answers your question.
Many Thanks
Eddie
/ comments
My main question was how do I prevent SQL Prompt from accessing a SQL instance?
eddie davis wrote:
Thank you for your post into the forum.
There is no longer cache management in SQL Prompt V4.
The...
Cache management
In version 3.9 we used to have a cache management (or something of that kind) where we could setup witch SQL instances to ignore and other cache related settings.
In version 4 I only see "Refresh S...
My 5 cents tip (you might know it already, but just in case)
I like to combine the SQL Prompt code snippets with the SQL Server Management Studio templates. I always liked the template (kind of the same idea of snippets) but SSMS lacks the ability of "callin...
Restore Backup failed on a Active-Passive Cluster
Firstly I was very impressed with the speed and level of compression (300GB database was compressed into 45GB in just 20 minutes.
Then I tried to restore but after about 10 minutes it failed with a...
WITH COPY_ONLY option
Where on the wizard is this option? I can't find it when creating a backup.
At the last step of the wizard it does show the script but it is read-only, so I have to copy it and paste to SSMS, add t...