Activity overview
Latest activity by EnrightMcC
Nope. Like you said, the create schema needs to be a standalone statement. Today I learned something. :-) After exercising my google-fu, it's become very clear the CREATE statement has to be a stand-alone statement, or the very first statement in a batch. Thanks, EnrightMcC / comments
Nope. Like you said, the create schema needs to be a standalone statement. Today I learned something. :-) After exercising my google-fu, it's become very clear the CREATE statement has to be a st...
I see sql compare does something entirely different: IF SCHEMA_ID(N'staging') IS NULL EXEC sp_executesql N'CREATE SCHEMA [staging] AUTHORIZATION [staging]' GO But I'm still curious what's wrong with that SQL? I even tried putting it in a transaction but it throws a syntax error. / comments
I see sql compare does something entirely different: IF SCHEMA_ID(N'staging') IS NULLEXEC sp_executesql N'CREATE SCHEMA [staging]AUTHORIZATION [staging]'GOBut I'm still curious what's wrong with th...
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 (...
First of all, I apologize for my harsh reply. I uncharacteristically replied out of emotion, under the stress of a very busy day. That's no excuse, but that's my reason. You are correct, I consider this a bug, because of the design that I don't agree with. By setting up something to work for a subset of searches, but not work under others, I perceive as a problem. I believe there is a valid solution to allow both; and I'm pleased that Red Gate is putting it on the Big Board. I hope it will get chosen; and thanks for your reply. Regards, EnrightMcC / comments
First of all, I apologize for my harsh reply. I uncharacteristically replied out of emotion, under the stress of a very busy day. That's no excuse, but that's my reason. You are correct, I consid...
Wow. that has to be the worse answer I've ever heard. And what about the users who need to find something with square brackets? Not to mention every real search tool from regex on allows you to specify special characters when searching. Either by placing the character in square brackets, i.e. []], or utilizing an escape character, i.e. \], or doubling the character, i.e. \]. For you to say this won't be fixed is the first time I've ever been dissatisfied with Red-Gate. Shouldn't the real answer be "This is a free tool, and we're not going to pay developers to fix a product that we're not directly making money off of?" You can say it's working as designed, but that's putting lipstick on pig, so to speak. If you have a search feature and you can't use it to search for a literal string, then that's a bug. Ridiculous. / comments
Wow. that has to be the worse answer I've ever heard. And what about the users who need to find something with square brackets? Not to mention every real search tool from regex on allows you to sp...
Thanks! / comments
Thanks!
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...
In the mean time, is there a work around? / comments
In the mean time, is there a work around?
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...