How can we help you today? How can we help you today?
fatherjack2
Activity overview Badges (0) Posts (84) Comments (135)

Comments

Sort by recent activity
Ah, I see. Thanks for that. I was looking via TortoiseSVN, thats where I was surprised to see that the file had gone. Thanks / comments
  1. Community
  2. SQL Source Control EAP
  3. Dropped objects just disappear
Ah, I see. Thanks for that. I was looking via TortoiseSVN, thats where I was surprised to see that the file had gone. Thanks
0 votes
Right, start typing and the New button appears - I was looking for a new button from the start as I had read through all the items to check already! / comments
  1. Community
  2. SQL Source Control EAP
  3. Links to TortoiseSVN and Windows folder
Right, start typing and the New button appears - I was looking for a new button from the start as I had read through all the items to check already!
0 votes
yup, followed those and got it working but I was looking for something that had to be done with subversion, thinking it was a separate application that would need installing. The line about Tortoise saying its a 'client for subversion' seems to indicate they are separate products when actually its rolled into Tortoise / comments
  1. Community
  2. SQL Source Control EAP
  3. first thoughts
yup, followed those and got it working but I was looking for something that had to be done with subversion, thinking it was a separate application that would need installing. The line about Tortois...
0 votes
I have deleted the folder where the repository was located and rebuilt it. I have returned to SSMS and started Source Control on the database. The link to the repository works successfully but switching to the Commit Changes tab results in a dialog titled "This is a temporary dialog" with the text Failed to update: SharpSvn.SvnException: Repository UUID 'e3a8354f-0353-a94f-b89c-8fc2087489bf' doesn't match expected UUID '3e7b7a4f-28c4-b142-b0ed-1070618b4111' ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1466, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1080, offset:32 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1143, offset:51 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1142, offset:46 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1129, offset:50 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1126, offset:4 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1312, offset:18 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 750, offset:45 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 749, offset:77 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 621, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 620, offset:104 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1507, offset:83 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1373, offset:18 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 215, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1205, offset:143 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1204, offset:6 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 958, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 956, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1453, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1359, offset:117 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 149, offset:11 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 186, offset:137 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 930, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1633, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1002, offset:500 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1006, offset:109 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1008, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1010, offset:13 --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action) at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token) and I cannot get past this. If i click OK the commit tab is empty and if i refresh the page it causes the same error. The same happens on the Get Latest tab too Jonathan / comments
  1. Community
  2. SQL Source Control EAP
  3. first thoughts
I have deleted the folder where the repository was located and rebuilt it. I have returned to SSMS and started Source Control on the database. The link to the repository works successfully but swit...
0 votes
after a further 20 minutes I gave up and hit cancel. I then got this: Failed to update: #oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\d9ddd418-18cd-4fae-addb-56fc697c555f\Views\dbo.ASRSysCV100#Zzprofessional_Qualifications#Default_Users.sql 'line 5:120: unexpected token: ["#Zzprofessional_Qualifications#Default_Users",<735>,line=5,col=120] [char=128]' ---> cZ: Errors occured whilst parsing file C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\d9ddd418-18cd-4fae-addb-56fc697c555f\Views\dbo.ASRSysCV100#Zzprofessional_Qualifications#Default_Users.sql 'line 5:120: unexpected token: ["#Zzprofessional_Qualifications#Default_Users",<735>,line=5,col=120] [char=128]' ---> line 5:120: unexpected token: ["#Zzprofessional_Qualifications#Default_Users",<735>,line=5,col=120] [char=128] --- End of inner exception stack trace --- at #oEc.#7Jf.#t.#B3.#sKf() at #oEc.#7Jf.#gKf(Action action) --- End of inner exception stack trace --- Server stack trace: at #eEc.#fEc.#t.#izb.#j5f() at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink) Exception rethrown at [0]: at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action) at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token) / comments
  1. Community
  2. SQL Source Control EAP
  3. first thoughts
after a further 20 minutes I gave up and hit cancel. I then got this: Failed to update: #oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\allenj\Local Settings\Application Dat...
0 votes
Yeah, I would say we had a noticable performance hit while I was linked to a database. I got a phone call from a user about it. Its only a test server but they never complain about perf on that normally. The CPU trace was bouncing down from 100 rather than up from 0. I eventually cancelled the SC connection and had an error I have logged elsewhere. / comments
  1. Community
  2. SQL Source Control EAP
  3. Possible Server Performance hit
Yeah, I would say we had a noticable performance hit while I was linked to a database. I got a phone call from a user about it. Its only a test server but they never complain about perf on that nor...
0 votes
depends how you measure big ... 10k objects in sysobjects. No idea what the size would be of an empty copy though. Some of the 'programmability' objects are pretty complex though. It finished not long after I completed the post, probably about 6-7 minutes in total. / comments
  1. Community
  2. SQL Search 1 Beta
  3. progress bar
depends how you measure big ... 10k objects in sysobjects. No idea what the size would be of an empty copy though. Some of the 'programmability' objects are pretty complex though. It finished not l...
0 votes
Ah, great spot CodantiM, I did indeed have that selected and now that it is unchecked things are not locking up with a self join on the biggest table. Many thanks. RedGate - it may be worth adding a note to the UI by the Columns with matching data types check box that indicates it could cause performance issues on large tables..? And/Or maybe getting the suggestion dialog to display a note that it has timed out trying to match all columns and is showing an abbreviated list after maybe 10s or so?? Thanks again Jonathan / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Application crash
Ah, great spot CodantiM, I did indeed have that selected and now that it is unchecked things are not locking up with a self join on the biggest table. Many thanks. RedGate - it may be worth adding ...
0 votes
Hi CodantiM, Thanks for the info. When I check for updates I get told that there are No updates available ... how did you get hold of 4.0.3.12?! I have now also tried it on tables with fewer rows: columnspacetime to countspaceload list 114..............1s 277..............15-18s 326..............35-40s on the last one the list doesnt show to screen but the cursor becomes available for editing. This list would be enormous 326x326=106k suggestion rows! 2 things: 1 - there is a definite increase in the time as the column count grows and I think that when I am working with the 368 column table I am just seeing an extension of the series above (368x368=136k suggestions) 2 - my PC is not showing the 277 table anywhere as quickly as yours shows 232. Do you actually mean immediately or is it just nice and quick!? I cant test exactly as I cant find any tables between the 114 and the 277 at the moment. regards Jonathan / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Application crash
Hi CodantiM, Thanks for the info. When I check for updates I get told that there are No updates available ... how did you get hold of 4.0.3.12?! I have now also tried it on tables with fewer rows: ...
0 votes
I'll give it a go Brian. The SQL Prompt menu is in SSMS and the tray icon is there, object suggestions pop up and the Ctrl + ... key combinations work. The About SQL Prompt details says v 4.0.3.10 is on the PC. I'll get back once I've uninstalled and reinstalled. Jonathan / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Application crash
I'll give it a go Brian. The SQL Prompt menu is in SSMS and the tray icon is there, object suggestions pop up and the Ctrl + ... key combinations work. The About SQL Prompt details says v 4.0.3.10 ...
0 votes
Total activity
298
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
79