How can we help you today? How can we help you today?
Elizabeth_Close_M1st
Activity overview Badges (0) Posts (3) Comments (5)

Activity overview

Latest activity by Elizabeth_Close_M1st

Thank you Sergio, we have created a Git repository on a network share and are working through the Octopus process. I appreciate your advice. E / comments
  1. Community
  2. SQL Prompt
  3. How to get Custom Filters over to Octopus for deployment
Thank you Sergio, we have created a Git repository on a network share and are working through the Octopus process. I appreciate your advice. E
0 votes
How to get Custom Filters over to Octopus for deployment
  1. Community
  2. SQL Prompt
We have several in-house databases that contain references to Linked Servers - which won't deploy within a transaction. I created filters so those objects are in a separate update.sql file without ...
2 followers 2 comments 0 votes
Hi Eddie - You are correct, It's in SQL Prompt. I deleted all linked servers from my local instance and wanted to find out which ones I really needed but Invalid Objects didn't see the linked server(s) being missing Thanks Elizabeth / comments
  1. Community
  2. SQL Prompt
  3. Invalid Objects or future enhancement
Hi Eddie - You are correct, It's in SQL Prompt. I deleted all linked servers from my local instance and wanted to find out which ones I really needed but Invalid Objects didn't see the linked serv...
0 votes
Invalid Objects or future enhancement
  1. Community
  2. SQL Prompt
I tried to use InvalidObjects finder to list DB objects that use a LinkedServer that either "doesn't exist" or "doesn't validate" ... is there another way (besides drop/recreate) that will find these?
3 followers 3 comments 0 votes
Errors occurred whilst parsing file C:\Users\closee\AppData\Local\Red Gate\SQL Source Control 5\WorkingBases\sxap3hvq.cic\Databases\OnlineBanking\_Initialization\02_CreateNewOnlineBankingDatabase.sql '' at line 107, column 69 '' at line 110, column 68 ***** This is line 107: ALTER DATABASE [OnlineBanking] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF, DIRECTORY_NAME = N'OnlineBankingDocStore' ) This is line 110: ALTER DATABASE [OnlineBanking] SET TARGET_RECOVERY_TIME = 0 SECONDS / comments
  1. Community
  2. SQL Compare
  3. SCC folder structure
Errors occurred whilst parsing file C:\Users\closee\AppData\Local\Red Gate\SQL Source Control 5\WorkingBases\sxap3hvq.cic\Databases\OnlineBanking\_Initialization\02_CreateNewOnlineBankingDatabase.s...
0 votes
SCC folder structure
  1. Community
  2. SQL Compare
I added a folder(CreateDB) and scripts inside the "Database" folder... using GIT outside SCC I committed the folder and scripts to master. Now I get a parse error every time I try to link or "ge...
3 followers 4 comments 0 votes
I'm not totally sure what you're needing, but at the top of the SQLDataCompare results pane there are tabs that let you view All Rows, Only in Left, Only in Right, and In both but different Also if you click any of the headers in the results pane the values will sort based on that column HTH! / comments
  1. Community
  2. SQL Data Compare
  3. Filter to differences of a single compare column?
I'm not totally sure what you're needing, but at the top of the SQLDataCompare results pane there are tabs that let you view All Rows, Only in Left, Only in Right, and In both but different Also if...
0 votes
I found that Migration script works for including DML steps / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. How to include additional script into SQL Source Control
I found that Migration script works for including DML steps
0 votes
Total activity
13
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5