Red Gate forums

is it possible to set some probability of column values?

Mona — Wed, 19 Jun 2013 08:35:56 GMT

is it possible to set some probability of column values in data generator?

RE: SQL Error 17

petey — Wed, 19 Jun 2013 08:20:30 GMT

Could you please check in the registry

HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\LOCALDEV

if there is an entry for 'SQLServerName'?

how to generate data using view columns?

Mona — Wed, 19 Jun 2013 07:40:32 GMT

i want to generate data using view columns not the table.
but when i create new project all the tables are there in left pane but not the views, plz suggest me some solution?

Also is it possible to generate data like my real time data using data generator?

Refresh failed. Unexpected token.

zimzum — Wed, 19 Jun 2013 07:36:39 GMT

Hi!

I got error at click button "refresh" on tab "check in":

Code:

Parsing failed with message SyntaxError. Unexpected token '" markupId="' (Line 2, Col 55) symbol Id.
CREATE FORCE VIEW mysch.zz_tmp (zz) AS

select '<a class="addAnswer" href="javascript:void(0);" markupId="111">' zz
from dual
;

I think it is because of my custom attribute "markupId".

Our project have some views, which contains html code. We can`not remove it

P.S.: i use version: 1.0.0.707

RE: Issues with Monitored Server connections v3.4.1.4

JoeGT — Tue, 18 Jun 2013 23:06:25 GMT

Hi Eddie

I have followed the instructions in your link to check WMI. (minus the screenshots)

Testing WMI

At the command prompt, run:
wbemtest

In the Windows Management Instrumentation Tester dialog box, click Connect.

In the Namespace box, type \\myserver.example.com\root\cimv2 where myserver.example.com is the name of the
Windows server you are attempting to monitor.

Under Credentials, enter the Windows account you are using to monitor the server and the password. This is the account listed under Credentials on the Monitored serverspage in SQL Monitor (Configuration > Monitored servers).

Click Connect.
Click Query and enter the following query:
SELECT Name FROM Win32_Service
Click Apply. You should see a list of results similar to those shown below:

If connection fails and an "Access Denied" error message is displayed, see WMI Troubleshooting and WMI Isn't Working!.

I get exactly the same issue when I try these tests with the error:

"User credentials cannot be used for local connections"

So back to my question - is the issue that I cant have the Base Monitor running on a host server that belongs to an SQL cluster and use domain account credentials ie. the base monitor is running on the instance that I am monitoring and that instance is the member of a cluster.

Cheers

Joe

SQL Error 17

cpetrich — Tue, 18 Jun 2013 21:14:59 GMT

I registered a named instance <servername>\LOCALDEV. I used the wizard.

Backup failed, complaining it couldn't find the server. Note that the server name is NOT LOCALDEV\LOCALDEV

See below

I have no idea why it is trying to connect to a server named <instancename>\<instancename>

Thank you

SQL Backup log file 7.1.0.72

-SQL "BACKUP DATABASE [License_Apps] TO DISK = 'T:\FileTransfer\SGN2SGN\_License_Apps.sqb' WITH ERASEFILES = 1b , CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, INIT, THREADCOUNT = 3, COPY_ONLY "

----------------------------- ERRORS AND WARNINGS -----------------------------

6/18/2013 1:27:48 PM: Backing up License_Apps (full database) on LOCALDEV instance to:
6/18/2013 1:27:48 PM: T:\FileTransfer\SGN2SGN\_License_Apps.sqb

SQL error 17: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Server : LOCALDEV\LOCALDEV
Windows authentication
6/18/2013 1:28:06 PM: Failed to connect to SQL Server instance: LOCALDEV\LOCALDEV

RE: Generic Question: Redgate vs Visual Studio

Evan Moss — Tue, 18 Jun 2013 16:42:45 GMT

Hi Rogue,

You might want to check out this document: https://www.dropbox.com/s/n0t6xctln3agy8a/Agile%20vs%20SSDT.pdf

There's a two week free trial of SQL Connect available here: https://www.red-gate.com/dynamic/products/sql-development/sql-connect/download

Thanks,
Evan

RE: 3.4.1.4 Installer error 0x800b0110

PDinCA — Tue, 18 Jun 2013 16:34:17 GMT

That's true, Priyasinha, James is handling this.

The 3.3.0.270 installer was downloaded without incident. There's definitely something in the 3.4.1.4 exe that Sophos doesn't like the look of. Microsoft Security Essentials OK'd it, though.

Reverting to 3.3 was the only solution.

Note to self (and others), "When verification of an installer download gives this error, DO NOT continue - you will have to uninstall the product to get a working version".

RE: SQL Prompt causing VS 2012 crash on exit

adam0101 — Tue, 18 Jun 2013 15:24:16 GMT

I think this same problem is causing SSMS 2012 to crash on exit as well. This is the error I see in the event viewer:

Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0020001, exception address 76CD4B32
Stack:

I think it might be related to this issue: http://connect.microsoft.com/VisualStudio/feedback/details/336844/static-variable-in-native-method-causes-exception-c0020001-during-process-exit

RE: The "Duplicate object name has been found" C# Exception

ghendric — Tue, 18 Jun 2013 14:37:08 GMT

Has this bug been resolved in the latest version of SQL Prompt?