Posts
Sort by recent activity
Outcome column on Jobs tab is misleading
I'm confused. After I manually start a backup job a few minutes later the Outcome column reports successful but if I look in the Inprogress tab the backup job is still Running...isnt that misleading?
Is the copying of backups to a network location separate?
When the "Copy Backups To Network Location" option is used, Is it run on a thread separate from the actual backup process?
It seems to me that it would be preferred that copying the backups would h...
Use of file location tags in "Copy backup to network locatio
Can I use the file location tags in the "Copy Backup To Network Location" option? Originally I would like to organize my backups by year-month-day. I have a finite amount of local storage and organ...
Will databases be deleted if folder is based on date?
In the backup wizard, step 3 of 6 under the Backup location section:
If this is my Folder specification: C:\000\<DATETIME yyyy_mm_dd>\ AND I turn on the "Delete existing backup filies in this folde...
Feature Suggestion WHERE clause suggest...
I think it would be cool if SQL Prompt would offer where clause suggestions based on existing indexes for that table.
My thought is it would help users write more efficient and faster T-SQL when th...
Column Ordinality
Is there an option in SQL Compare that will inspect the column ordinality between two tables... so that if the destination columns are not in the same order as the source tables a script can be gen...
Add A Column To A Table With ExtendedProperty
I use this snippet when I want to add a column to a table and want to add a blurb about this columns purpose.
Getting into the habit of using the ExtendedProperty also allows me to use SQLDoc to cr...
GROUP BY Feature Request / Enhancement
Hello,
I wanted to suggest an enhancement to your SQL Prompt product.. which I *LOVE* by the way!
If I type
SELECT City, State From Addresses
and I begin to type GROUP BY and press the space bar .....
Control final position of cursor in Snippet Manager
Is there a way that I can tell the cursor to finish in a certain position after I invoke the snippet or will it always end up at the end of the snippet i just inserted?
Printing Code Snippets...
Is there a way I can print out the list of code snippets so that I have them as a reference?
Thanks