Search
-
Re: Databases start up 'In Recovery' in V5.4.0.22 (and 5.4.1.5)
Comment by epetro · · Home› Discontinued and Previous Versions› SQL Storage Compress Previous Versions› SQL Storage Compress 6A knowledgeable member of support has informed me directly that this is a known issue that is being investigated. As such, I thought I would post my resolution. Step 1: create stored proc on Master to assist OFFLINE / ONLINE operations against compressed database only. Step 2: create powershell script that can access the… -
Stack Trace
Hello I am using SQL 2008 MGT Console. Sql Prompt 4.0.2.27 I have the Master database set as the context of the query. When I click on the condition for the Left Join below, I get the stack trace below. SELECT r.database_id, session_id, t.text,d.name FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(sql_handle)… -
Format Error
Hi all, I want to buy prompt but when i tried to use it i get some errors. 1.When i open the settings menu and click the styles under format an exception occurs like above. Then when i want to layout a query "SQL prompt was unable to format this script beacuse some syntax errors were found while being parsed. The errors… -
Re: BUG: wrong update script for User-defined table types
I've been trying to raise another ticket but for some reason your system just stores it in my drafts. Anyway, this is what I wrote and the issue seems to be when a migration script needs to be run at the same time as a change to a UDTWhen sql compare is run and a migration script exists as well as a change to a User… -
Re: All values for Message.MessageTypeID
Hi Catalin, Below is an extract of the warning IDs and the messages we display within SQL Compare, I hope it helps. We can not guarantee that these IDs will not change in the future as we improve the product. Regards, David TargetUnsupportedSynonym The synonym {0} is not supported in the target database version.… -
XML Parsing Line1, character 58 semicolon expected
Discussion by pauldes · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsI am running a data compare where I have selected specific tables. I receive the following error when executing: XML Parsing Line1, character 58 semicolon expected And the following is a copy of the SQL generated by SQL Data Compare: /* Script created by SQL Data Compare version 5.2.0.40 from Red Gate Software Ltd at… -
Re: SQL Backup Service Keeps Hanging
Hi Peter This is the content (I've removed some of the information for security purposes): date/time : 2007-12-19, 11:13:24, 142ms computer name : user name : registered owner : operating system : Windows 2003 R2 x64 Service Pack 1 build 3790 system language : English system up time : 47 days 19 hours program up time : 1… -
Re: How do I use the SQL Response client across domains?
Hi Brian, here is the trace from Sharkwire. Something is definetley hathe ppening on port 7398 as I get some entries when trying to connect from client on differenet domain. Thanks No. Time Source Destination Protocol Info 1 0.000000 172.70.110.127 172.70.1.6 TCP 37240 > 7398 [SYN] Seq=0 Win=65535 Len=0 MSS=1380 Frame 1…
>1648 results