Posts
Sort by recent activity
Format SQL, Apply Layout isn't working on CREATE SCHEMA following an IF NOT EXISTS
Why can't this code be formatted (Ctrl K+Y)?***IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'staging') CREATE SCHEMA staging;****Error in 'apply layout (format sql)'Script parsing errors (...
Special Character Search
I'm having difficulty searching for a right square bracket.When I search for: [servername.net], it matches on [servername.net, I don't want that. I want the right square bracket to be part of the s...
SQL Prompt glitch when SQL Server contains an invalid SYNONYM reference.
I had a SYNONYM defined in SQL Server that pointed to a server that no longer exists. SQL Prompt couldn't load suggestions (Error loading master) because the internal query
"SELECT object_id, OBJ...
Filter on command type
I would like to capture schema changes to a database. Unfortunately it's a staging database and check constraints are turned off, and on to allow simultaneous table loading.
DLM Dashboard sends an...
carriage return line feed problem?
I experienced this problem with both Refactor and SQL Prompt 4. After I formatted (or laid out) the SQL in a stored proc, it wouldn't compile. I received the error "Incorrect syntax near the keywo...