Comments
Sort by recent activity
Hi tkdennis,
You're right, the text display is a bug. Looks like something is not getting escaped properly. I'll look into that.
The grid view is correct. As the results contains white space characters, the cell value has to be wrapped in quotes. Any quotes in the results are escaped using double quotes as well. This ensures that the output can be pasted into excel or other spreadsheet application.
A temporary work around would be to remove the new line from the end of your result string, paste the results into excel and then save the excel sheet to a text file. (Not idea, but we'll see what we can do about fixing the text output).
Cheers,
--
Daniel Kenyon-Jones
Software Engineer - DBA Tools / comments
Hi tkdennis,
You're right, the text display is a bug. Looks like something is not getting escaped properly. I'll look into that.
The grid view is correct. As the results contains white space charac...
Hi padwin, what you were seeing was a formatting error.
Multiscript was incorrectly returning the binary representation of the guid rather than the standard string representation.
The following script should demonstrate the issue:
DECLARE @guid UNIQUEIDENTIFIER ;
SET @guid = NEWID() ;
SELECT CONVERT(NVARCHAR(100), @guid) AS 'NVARVCHAR',
@guid AS 'UNIQUEIDENTIFIER',
CONVERT(BINARY, @guid) AS 'BINARY' ;
GO
Red Gate support should have been in contact with you and can provide you with a development build of Multi Script that has a fix for this issue.
Let me know if you have any further issues with this.
--
Daniel / comments
Hi padwin, what you were seeing was a formatting error.
Multiscript was incorrectly returning the binary representation of the guid rather than the standard string representation.
The following scr...
Can you run the query against the last 55 servers only?
--
Daniel / comments
Can you run the query against the last 55 servers only?
--
Daniel
Hi,
Is the application locking up (as in the ui stops working?) or does it just not return any more results?
If you leave it running for a few min do the SQL Queries time out?
Cheers,
--
Daniel / comments
Hi,
Is the application locking up (as in the ui stops working?) or does it just not return any more results?
If you leave it running for a few min do the SQL Queries time out?
Cheers,
--
Daniel
SQL Response uses .net remoting to communicate between the Client and the Alert Repository.
.net remoting can operate in two modes:
Secure - The connection is encrypted using the users credentials the Client is running as. This requires that both the client and AR machine recognise the credentials. This would work if both ends are on the same domain, or different domains with a trust link between them.
Non Secure - The connection is not secured or authenticated in any way
The two modes are not compatible. A Client configured to use secure remoting will not connect to an AR configured to use non secure remoting and vis-a-versa.
--
Daniel / comments
SQL Response uses .net remoting to communicate between the Client and the Alert Repository.
.net remoting can operate in two modes:
Secure - The connection is encrypted using the users credentials...
Can you ping/tracert the SQL Response Alert Repository machine from the machine you are running the client on?
The 'failed to respond' error is a network transport level thing. Either a firewall/NAT is blocking the connection, the Alert Repository isn't running or the IP address you are using isn't correct.
--
Daniel / comments
Can you ping/tracert the SQL Response Alert Repository machine from the machine you are running the client on?
The 'failed to respond' error is a network transport level thing. Either a firewall/NA...
Good to hear that.
Cheers,
--
Daniel / comments
Good to hear that.
Cheers,
--
Daniel
Hi,
I'm afraid this is something I'm going to have to chase up with a 3rd party component provider. The error is occurring in their code, so I am very limited in what I can do.
Regards,
--
Daniel / comments
Hi,
I'm afraid this is something I'm going to have to chase up with a 3rd party component provider. The error is occurring in their code, so I am very limited in what I can do.
Regards,
--
Daniel
Hi,
I'm assuming this is the same problem as you had earlier. I'm at a bit of a loss to explain it.
I've not seen a similar error raised on another machine.
Are you using the default windows screen dpi/font size?
Have you been having odd issues with any other software on this machine?
--
Daniel / comments
Hi,
I'm assuming this is the same problem as you had earlier. I'm at a bit of a loss to explain it.
I've not seen a similar error raised on another machine.
Are you using the default windows screen...
Hi,
If you're not getting a warning before the UI dies, then something sounds very wrong with the .net runtime. Restarting your machine would probably be a good idea.
Let me know if the issue is still occurring once you have rebooted.
Could you also send a zip of your client log files to the support@red-gate.com addresses with 'F0022546' included in the subject line (this is the support ticket number for your issue)
The client log file can be found under:
[User local profile]\Local Settings\Application Data\Red Gate\Logs\SQL Response 1
Cheers,
--
Daniel / comments
Hi,
If you're not getting a warning before the UI dies, then something sounds very wrong with the .net runtime. Restarting your machine would probably be a good idea.
Let me know if the issue is st...