Red Gate forums

Maintenance Window

Luis Martin — Wed, 22 May 2013 00:49:51 GMT

This is a suggestion.

Actually we can set maintenance window i.e from 11pm, 5 hours.
May be is more useful working time:
From Monday to Friday, 6am to 10pm and nothing on weekends or Monday to Friday, 6am to 10pm and Saturday from 6am to 1pm and nothing on Sunday.

Just a thought.

RE: Smart Assembly Failed

jf3000 — Tue, 21 May 2013 21:58:45 GMT

There is no crash, it says it builds the assembly yet it doesnt build the assembly.

The only option I have set in SA in the error reporting. Its only just started happening. It used to work on the previous apps, I just figured there was a bug somewhere.

RE: Found new bug when using "Add object existence check" option

JohnnyT — Tue, 21 May 2013 20:48:58 GMT

Here is a simple scenario for you to reproduce this error. Hope this helps.

Code:

-- Create identical TestA and TestB databases
create database TestA ;
go
use TestA ;
go
create default [dbo].[empty_number] AS 0 ;
go
create table dbo.Table1
(
column1 char(10) not null,
column2 int not null
) ;

execute sp_bindefault N'dbo.empty_number', N'dbo.Table1.column2' ;
go

create database TestB ;
go
use TestB ;
go
create default [dbo].[empty_number] AS 0 ;
go
create table dbo.Table1
(
column1 char(10) not null,
column2 int not null
) ;

execute sp_bindefault N'dbo.empty_number', N'dbo.Table1.column2' ;
go

-- Now drop the "column2" in Table1 in the TestA database.
use TestA ;
go
execute sp_unbindefault N'dbo.Table1.column2' ;
go
alter table dbo.Table1 drop column column2 ;
go

-- Now use SQL Compare 10 to generate a script to make TestB match TestA. Be sure to
-- check the "Add object existence checks" option before generating the script.
-- Run the generated script on the TestB database and see the error.

Crash of WebDev.WebServer40.exe on Snapshot

MrT — Tue, 21 May 2013 16:43:32 GMT

I'm trying to profile an ASP.net MVC application (VS Development Server)but when I try to take a snapshot the webserver process crashes (error log below).

I'm using VS2012 11.0.50727.1 and Ants 7.4.0.41

Any help would be gratefully received.

Thanks
Richard

Faulting application name: WebDev.WebServer40.exe, version: 10.0.40219.1, time stamp: 0x4d5f345a
Faulting module name: diasymreader.dll, version: 8.0.50727.5420, time stamp: 0x4ca2cdf7
Exception code: 0xc0000005
Fault offset: 0x0005436c
Faulting process id: 0x1ee8
Faulting application start time: 0x01ce563d88bcd142
Faulting application path: C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\WebDev.WebServer40.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework\v2.0.50727\diasymreader.dll
Report Id: ec688b30-c230-11e2-b982-001c4277449c

RE: Profiling a different machine

jessica.ramos — Tue, 21 May 2013 15:58:24 GMT

Ah, so sorry about this inconvenience. Remote profiling is on our feature request list though and I've also shared your reply with the team--thanks very much for the feedback!

RE: ANTS Crashing ASPNET Dev IIS Server on Profiler Launch

dom.smith — Tue, 21 May 2013 15:35:40 GMT

Hi Josh,

Sorry for the delay in replying while I was on vacation last week.

If I understand your comments correctly, your problem is with ANTS Memory Profiler 7.4, not ANTS Performance Profiler. I'm afraid the Memory Profiler doesn't currently support Silverlight 5, and there's also a known bug where (as you say), the add-in in Visual Studio 2012 launches the wrong version of the Web Development server.

Both of these issues were fixed in the recently-released ANTS Performance Profiler 8.0 and we'll endevor to get these fixes into the earliest betas of ANTS Memory Profiler 8.0 once we open that beta program shortly.

RE: SQL Compare SDK removing users from database

chris.brown — Tue, 21 May 2013 15:08:22 GMT

The solution to this issue is to loop through the objects in the database, ensure you set all the users .Selected = false then the SQL compare will completely ignore them.

RE: Wrong line numbers in stack traces

edevis — Tue, 21 May 2013 14:56:25 GMT

Hello,

I am currently having the same issue using version 6.8.0.117. Line numbers sometimes seem to be incorrect by one or more lines. I have created a little repo that illustrates the problem:

Download

Use build config 'Release_Obfuscated' which automatically creates the obfuscated assembly using the supplied .saproj file.

What I have found out is that setting 'Control Flow Obfuscated' level changes the returned line numbers. I dont know if all levels should support the decoding, but I found no statement telling me otherwise.

Registrering fails for database with federation

evaluator — Tue, 21 May 2013 12:48:50 GMT

I am evaluating MySQL Compare.

When trying to compare two databases where one contains a federated table (using the FEDERATED database engine), registering fails for the database containing the federated data (not for the other), aborting the comparison operation.

Only a portion of the MySQL Compare error message fits the screen:

Code:

The foreign data source you're trying to reference does not exist. Data source error: error: 1142 'SELECT command denied to user 'fedUser'@...

Accessing the sole federated table in MySQL Workbench 5.2.47 which uses "fedUser" as user in its connection works fine. It clearly exists and data is retrieved. So why is MySQL Compare complaining about this?

The connection method is TCP/IP for the problematic database containing the federated table; SSH for the other database.

SQL Monitor v3.4 has been released.

priyasinha — Tue, 21 May 2013 12:44:54 GMT

SQL Monitor v3.4 is now available to download from http://www.red-gate.com/products/dba/sql-monitor/

What�s new in this release?

� Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
� There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel (not available in IE7 and IE8).
� Log files can be retrieved from the �Configuration -> About� page.

For more information, see the release notes.

Find out more or contact us:

Read more about SQL Monitor 3 and its key features.
Report any issues and raise questions on the support forum or email us at support@red-gate.com.