Search
-
Re: Snippets
Hi there, No problem. We like to try to keep everyone happy. I didn't even realise it was. That's definitely a bug. SQL isn't generally case-sensitive so requiring these placeholders to be case-sensitive is very counter-intuitive. This is a result of the way SQL Prompt 3 works versus the way SQL Prompt 2 works. The latter… -
Re: Setup method?
Simon, In terms of achieving DRY, you do seem to have a lot of setup here, And that setup seems to be calling production procedures. Obviously I don't know about the underlying logic but if it were me, I would ask myself whether it really is necessary to call all those, or even any of them. If I understand this correctly,… -
Re: Abandon using migration scripts
Hi there, I'd like to add my two cents regarding migration scripts. We also have had a huge amount of trouble with migration scripts. A lot of our problems seemed to stem from the fact that our DB schema wasn't setting explicit constraint names for PK, FK and default constraints, so we had to write special SQL to try and… -
Re: SOLVED: 5.2.8.2 Login failed for user 'NT AUTHORIT...
Well knock me down with a feather! Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Query RESULTS are OK,… -
SQL Prompt 7 beta (now closed)
The stable release announcement can be found here. Beta closed - thanks to everyone who took part! This build of SQL Prompt includes:* Visual Studio 2015 support * Management Studio 2016 CTP2 support * User placeholders in snippets (UserVoice and UserVoice) * Tab coloring improvements (Blog post) * Find invalid object… -
Re: Automated Daily Backup
This is what I wrote to backup all databases on a daily basis. It's a single stored procedure that you can schedule whenever. It will create a control table that lists the databases and defines whether they should be backed-up and for how long to retain previous backups. By default, backup = Y and retention period = 7… -
Re: Editor performance very poor
LOL. Please don't let this be the start of a religious war... I must admit that I'm more of a tab man myself, but anyway. I've been able to identify two possible causes for this behaviour: (i) Our AST parser outputs ASTs where child nodes are implemented as singly-linked lists, which means you can only really walk them in… -
Re: Oracle connections via Secure External Password Store don't appear to work properly.
Hi @JeffCote00 Here you will get an answer Secure External Password Store It is often necessary to make connections to the database from shell scripts held on the filesystem. This can be a major security issue if these scripts contain the database connection details. One solution is to use OS Authentication, but Oracle 10g… -
SQL Prompt 6.4.1.164
SQL Prompt 6.4.1.164 - 15th January 2015 This build of SQL Prompt includes:* Execute current statement * Insert semicolons * Code highlighting * Use object definition case * Rename variables and aliases * Suggestions improvements * Qualify object names improvements * Remove square brackets * Nullability of columns * Choose… -
Re: Automated dB Restore
Here the stored proc I use. It was originall posted in www.sqlservercentral.com by Greg Larsen. I modified to work with SQL Backup. Take the output and paste it an new QA window to do the restore. -- build_restore_script 'MDSHC' create procedure build_restore_script @dbname sysname = '' --restrict restore statements to 1…
946 results