Comments
Sort by recent activity
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...
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...
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...
Thanks! / comments
Thanks!
In the mean time, is there a work around? / comments
In the mean time, is there a work around?
Only one version installed. Here is the info from SSMS Help--> About
Microsoft SQL Server Management Studio 10.50.4000.0
Microsoft Analysis Services Client Tools 10.50.4000.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.17041
Microsoft .NET Framework 2.0.50727.5477
Operating System 6.1.7601
Windows 7 Professional
No other plugins installed. / comments
Only one version installed. Here is the info from SSMS Help--> About
Microsoft SQL Server Management Studio 10.50.4000.0
Microsoft Analysis Services Client Tools 10.50.4000.0
Microsoft Data Access ...
Yep, that did it. Thanks to patrickortuso and David Pond. Deleting the DM key seems to have done the job. / comments
Yep, that did it. Thanks to patrickortuso and David Pond. Deleting the DM key seems to have done the job.
I experienced this today when I tried to upgrade to SQL Search 2. When I click on the button I receive the error listed in the OP.
What is the status of this?
Can you provide a link to reinstall a previous version?
FYI my log info is:
15:29:37.187|Info |RedGate.SIPFramework|1 |Red Gate SSMS Ecosystem host connecting to SSMS.
15:29:37.187|Info |RedGate.SIPFramework|1 |RedGate.SIPFramework version: 1.0.1.2025 / comments
I experienced this today when I tried to upgrade to SQL Search 2. When I click on the button I receive the error listed in the OP.
What is the status of this?
Can you provide a link to reinstall a ...