Comments
Sort by recent activity
Unfortunately that didn't work. I ran the commands and reset visual studio.
Just to note, %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.VSUI.dll" should be %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles(x86)%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.VSUI.dll"
Is there something else I need to do during the install? / comments
Unfortunately that didn't work. I ran the commands and reset visual studio.
Just to note, %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPro...
You will need to make a hot fix for the application to include this text
<HostApplication>
<Name>Microsoft Visual Studio Macros</Name>
<Version>10.0</Version>
</HostApplication>
<HostApplication>
<Name>Microsoft Visual Studio</Name>
<Version>10.0</Version>
</HostApplication>
in the file VSUI.AddIn
Thanks. / comments
You will need to make a hot fix for the application to include this text
<HostApplication>
<Name>Microsoft Visual Studio Macros</Name>
<Version>10.0</Version>
</HostApplication>
<HostApplication>
<...
I just installed VS2010 ultimate beta 2, and the SQL prompt menu is not showing. Do I need to reinstall SQL prompt or is there something I need to do with VS2010?
Thanks / comments
I just installed VS2010 ultimate beta 2, and the SQL prompt menu is not showing. Do I need to reinstall SQL prompt or is there something I need to do with VS2010?
Thanks
Got a new box and tryed this again (Winodws 7), I installed SQL Server 2008, Visual Studio 2010 (Beta 2) and then installed SQL Prompt, I get SQL prompt in SQL server management studio but I still do not see the SQL Prompt 4 menu in Visual Studiio 2010.
2 things to note are, I am running a 64 bit edition of Windows 7 Enterprise and I am running the client for SQL 2008 R2 CTP.
If any one has any ideas or command line suggestions to get SQL prompt into Visual studio I would be happy.
Note: It seems that SQL 2008 R2 CTP doesn't like SQL Refactor. Just FYI. / comments
Got a new box and tryed this again (Winodws 7), I installed SQL Server 2008, Visual Studio 2010 (Beta 2) and then installed SQL Prompt, I get SQL prompt in SQL server management studio but I still ...
Fixed, Thanks for that.
Perhaps that might be a good sticky note. / comments
Fixed, Thanks for that.
Perhaps that might be a good sticky note.
begin try
set @cmd = 'dbcc inputbuffer( ' + cast(@@spid as varchar) + ')'
insert into dbo.GenericTable
(
Event
,Parameter
,Syntax
)
exec
(
@cmd
)
end try
begin catch
set @errorMessage = error_message()
raiserror(@errorMessage, 18, 1)
end catch
Hi All,
I am wondering if there is any way to format the code like this, I would really like to have returns after exec statements when there are brackets evolved. / comments
begin try
set @cmd = 'dbcc inputbuffer( ' + cast(@@spid as varchar) + ')'
insert into dbo.GenericTable
(
Event
,Parameter
,Syntax
)
...
I have a question about formatting.
Can I do something like this
if @value = 1
or @value = 2
begin
end
Where the or's and and's are moved to another line seperately or is that outside the realm of SQL Prompt? / comments
I have a question about formatting.
Can I do something like this
if @value = 1
or@value = 2
begin
end
Where the or's and and's are moved to another line seperately or is that outside the realm of S...
We found out what was the issue, our IPS was blocking the traffic going through via WMI. So just remember even when you allow the traffic on your firewalls that something else may think it is not a good idea. / comments
We found out what was the issue, our IPS was blocking the traffic going through via WMI. So just remember even when you allow the traffic on your firewalls that something else may think it is not a...
Just to note we have tried IP, full URL and short NetBIOS naming.
Chris Spencer wrote:
Hi Adam
Apologies for this. I've looked into this error and the vast majority of online advice suggests that it's either a firewall or DNS issue.
It doesn't look like you've missed any ports on your firewall so it might be worth trying with ip addresses rather than the server names if you haven't already. I realise that with 90 servers this would only be a short-term solution but I believe it would confirm a DNS issue if there is one.
Also the page where I found this suggestion is full of useful WMI information - http://technet.microsoft.com/en-us/libr ... 92772.aspx
Please let us know if this helps.
Regards
Chris
/ comments
Just to note we have tried IP, full URL and short NetBIOS naming.
Chris Spencer wrote:
Hi Adam
Apologies for this. I've looked into this error and the vast majority of online advice suggests that ...
We are currently opening a support case with microsoft as our network is a bit more complicated then most. I will post any relevent information as to a fix just incase someone else gets the same issue when using WMI (RPC) over subnets within the same network with firewalls protecting the environments.
RPC Error 0x800706BA / comments
We are currently opening a support case with microsoft as our network is a bit more complicated then most. I will post any relevent information as to a fix just incase someone else gets the same is...