Red Gate forums

RE: JavaScript errors after upgrade

chefi_d — Wed, 16 May 2012 21:40:01 GMT

Hi Chris, I downloaded the latest build and run the SQL monitor installation from Sql Monitor_3.0.0.1593.exe. The installation was quick and successful, according to the final message. I tried to load the SQL monitor web page, but it didn't show. Then, I noticed that both Base and Web services were stopped. I started them and then SQL monitor page showed up. I checked the Base and Web services versions in About section and both still show 3.0.0.1575. Also, some of my databases still show as Offline there. I checked the Windows Application error logs and didn't notice any related errors. Please advise.

DEFECT: 5.3.2 - Script as ALTER shows as modified

PDinCA — Wed, 16 May 2012 19:30:43 GMT

When we right-click in Object Explorer and either "Modify" or "Script as ALTER", SSMS gives us the script and there's no "*" to show a modified script exists in the window.

However, hovering over, say, a UDF or SP, then right-click and take the SQL Prompt "Script as ALTER" option, it produces the same script but it leaves a "*" as if I had made a modification, which I haven't.

This is confusing and inconsistent with SSMS behavior.

Please fix (should be a simple thing )

RE: Installation does not detect MSSQL

sderrico — Wed, 16 May 2012 19:08:18 GMT

RE: Weighted Data ...

eddie davis — Wed, 16 May 2012 18:48:21 GMT

Hi SydOpera

I have added the details of this forum post to Feature Request SDG-721.

This feature request is now marked for review. I cannot guarantine the success of the feature request submitted or if approval is given what future version of SQL Data Generator your weighted data request will appear in.

Many Thanks
Eddie

Table-valued parameters not included in prompt

ewhipple — Wed, 16 May 2012 18:38:07 GMT

Howdy, again. When I create a stored procedure or function with a table-valued parameter, the parameter variable is not offered in SQL Prompt prompts.

For example:

Code:

CREATE PROCEDURE MyProc @table_parm1 tt_ID_list READONLY
AS

SELECT *
FROM

Code:

CREATE FUNCTION MyFunc(@table_parm1 tt_ID_list)
RETURNS TABLE
AS
RETURN SELECT * FROM

In both examples, when completing the FROM clause, @table_parm1 is not listed in the prompt.

Have I missed something in my configuration, or is this not supported?

I'm using SQL Prompt 5.3.2.2 with SSMS 2008 on Windows 7 64-bit. The server is SQL Server 2008 non-R2 on Windows Server 2008 R2 64-bit.

Microsoft SQL Server Management Studio 10.0.5500.0
Microsoft Analysis Services Client Tools 10.0.5500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5456
Operating System 6.1.7601

No prompting for columns of UTT table variables

ewhipple — Wed, 16 May 2012 18:17:36 GMT

Howdy, all. When I'm working with a table variable of a user-defined table type, SQL Prompt does not offer the variable's columns in the prompt.

Here's an example. When I typed the FROM clause, table variable @foo was properly included in the prompt. When I went back to fill in SELECT clause, "f" was the first prompt item, but it listed no columns. I typed "f." by hand, and only IDENTITYCOL, ROWGUIDCOL, and my snippets list were prompted, no columns.

Code:

DECLARE @foo tt_ID_list

SELECT f.id
FROM @foo AS f

And here are the type definitions

Code:

CREATE TYPE t_imis_id FROM varchar(10) NULL

CREATE TYPE tt_ID_list AS TABLE(
ID t_imis_id NULL,
AUTOSEQN int IDENTITY(1,1) NOT NULL PRIMARY KEY
)

(If instead I give @foo an explicit, local definition, prompting works correctly as usual.)

Is this a configuration issue, or a bug, or does SQL Prompt not yet cover this situation?

I'm using SQL Prompt 5.3.2.2 with SSMS 2008 on Windows 7 64-bit. The server is SQL Server 2008 non-R2 on Windows Server 2008 R2 64-bit.

Microsoft SQL Server Management Studio 10.0.5500.0
Microsoft Analysis Services Client Tools 10.0.5500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5456
Operating System 6.1.7601

RE: SQL Monitor 2.3.0.333 Causing CPU Spikes

chrisk5 — Wed, 16 May 2012 18:10:22 GMT

I believe that when the Base Monitor service re-establishes contact with a monitored entity it will run some quick data connection tests to ensure that it has contact. However, the spikes that you describe do sound out of the ordinary.

Would it be possible for you to send me the SQL Monitor error logs, as described in this document, by emailing support@red-gate.com and quote the ticket number F0060280 in the subject line:
http://www.red-gate.com/supportcenter/content/SQL_Monitor/help/3.0/SM_LogFiles

Filter Compare list prior to starting the Compare

berokke — Wed, 16 May 2012 18:09:37 GMT

I would like to be able to filter the compare prior to running the actual compare. There are times I only want to compare stored procedures and I do not want to go through all the tables or other objects.

I recently inherited an application. The databases are set up on 6 servers and none of the databases match even though they are used by the same application. There are tables in some databases that are only data tables used for crunching numbers. There are thousands and I do not need SQL Compare to run through each one - in fact, I get memory errors when trying to run the compare.

It would be useful to be able to compare stored procedures or selected list of tables in order to develop a common structure used by all.

Thanks!

RE: Search Capability Limited to 150 Maximum Results

yar229 — Wed, 16 May 2012 17:31:11 GMT

Well, here it is patched for max 400 results.
Unpack files to "x:\ProgramData\Red Gate\SQL Search\Active" and "x:\ProgramData\Red Gate\SQL Search\Source" overwriting existing System.Data.SQLite.dll

SQLSearch_SQLite_patched_for_limit_400.zip

RE: Schema owned by a role - Deployment Error

eddie davis — Wed, 16 May 2012 17:16:32 GMT

Hi Ohm

Quick update for you. Sadly your bug SC-5584, did not make into SQL Compare V10.2 released earlier today. I am sorry if I raised your expectations on fixing this problem.

Hopefully this bug will be fixed in the near future.

Many Thanks
Eddie