Comments
Sort by recent activity
Very good point James, it totally slipped my mind that I ran my native backups with the WITH COPY_ONLY option so as to not break the SQLBackup chain.
Essentially my first step was to accept that SQLBackup was my main backup tool and I had the native backups as a safety net.
Jonathan / comments
Very good point James, it totally slipped my mind that I ran my native backups with the WITH COPY_ONLY option so as to not break the SQLBackup chain.
Essentially my first step was to accept that SQ...
Guant,
When I converted to SQLBackup I migrated each database at a time with the native backup and the SQLBackup jobs both running and once I was happy with the SQLBackup set up I stopped the native ones. Obviously I had to schedule them apart for performance and file access reasons and also for my own reasons I had the backup files generated in a different location. I had this parallel run system for maybe two or three days per database before I switched to solely SQL Backup.
Good luck with your project.
Jonathan / comments
Guant,
When I converted to SQLBackup I migrated each database at a time with the native backup and the SQLBackup jobs both running and once I was happy with the SQLBackup set up I stopped the nativ...
Tanya,
I'm afraid to say that I have been declined permission to send you the database schema by the vendors. [image]
Jonathan / comments
Tanya,
I'm afraid to say that I have been declined permission to send you the database schema by the vendors.
Jonathan
OK, a little more on the way to get the error:
Open SSMS
Connect to server
open windows explorer to locate sql file
drag file into ssms
select database from drop down list
click into script and descend through script to line 1154.
moving to line 1155 causes the Microsoft .Net Framework error message box and the unhandled exception with Details and Continue buttons
-Whilst below 1155 the message box returns whenever the cursor is moved up, down, left or right (by keyboard or mouse).
-Once the cursor moves above 1155 the errors do not appear.
-If the SSMS application loses focus to another application the errors do not reappear until the focus returns to SSMS
I hope this helps track the bug a little.
Is the error detail worth sending?
Edit:-
the error actually only pops up when in the script editor section, nothing happens when the cursor is in the results section, in the toolbars or object browser
Jonathan / comments
OK, a little more on the way to get the error:
Open SSMS
Connect to server
open windows explorer to locate sql file
drag file into ssms
select database from drop down list
click into script and des...
Hi Tanya,
At the moment I can confirm that the problems are only evident when I am connected to one particular database and open one particular script (as I need to execute that script on this database!).
I have not tried connecting to a different database with the problem query but I can run other queries against the 'problem' database without the error.
The database stats are:
293 tables
Size:
reserved
11029648 KB
data
5365056 KB
index_size
5447928 KB
unused
216664 KB / comments
Hi Tanya,
At the moment I can confirm that the problems are only evident when I am connected to one particular database and open one particular script (as I need to execute that script on this data...
Tanya,
System:
Core2 Duo 2.33
4GB RAM (although is 32bit so only 3.25 used)
since I closed the offending sql file SSMS has worked fine with SQL Prompt working well too.
Will send db schema in due course
Jonathan / comments
Tanya,
System:
Core2 Duo 2.33
4GB RAM (although is 32bit so only 3.25 used)
since I closed the offending sql file SSMS has worked fine with SQL Prompt working well too.
Will send db schema in due c...
OK, rebooted and all was fine. WAS fine!
now have unhandled exception:
Error Message:
Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.
Object reference not set to an instance of an object.
Error Detail:
... is 558 lines long. Where should I send it?
I chose Continue ...
repeated error message box displays
had to crash out of sql file (hit esc and click on close button for sql file alternately and you get in between error messages).
SQL file was 2812 lines long and had been drag/dropped from windows explorer to SSMS empty query window
Jonathan / comments
OK, rebooted and all was fine. WAS fine!
now have unhandled exception:
Error Message:
Unhandled exception has occurred in a component in your application. If you click Continue, the application wil...
Getting this more and more ...
Message text says '...do not have permission ...'
Error detail says:
Exception of type 'System.OutOfMemoryException' was thrown.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Data.SqlClient.SqlBuffer.get_Value()
at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
at System.Data.SqlClient.SqlDataReader.get_Item(Int32 i)
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.a(SqlDataReader , IDictionary`2 , IDictionary`2 , IDictionary`2 )
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.a() / comments
Getting this more and more ...
Message text says '...do not have permission ...'
Error detail says:
Exception of type 'System.OutOfMemoryException' was thrown.
System.OutOfMemoryException: Exceptio...
Just emailed support@redgate.com with txt file as out of Memory now occurring in SSMS Object Details viewer.
Edit:
SQL Prompt4 has totally ceased to prompt whilst editing SQL
Edit2:
5 mins later - Perhaps predictably, SSMS has now crashed.
Jonathan / comments
Just emailed support@redgate.com with txt file as out of Memory now occurring in SSMS Object Details viewer.
Edit:
SQL Prompt4 has totally ceased to prompt whilst editing SQL
Edit2:
5 mins later - ...
Tanya,
Thanks for the application but what are the special characters that arent allowed in the snippet names?
The reason that I ask is this:
I have one that was called b_r
I have run the import and it returned a 'successful' message
when I start typing 'b_' the snippet popup show the full snippet but when I hit enter only 20 lines of it are placed on the SSMS script editor.
I havent restarted the PC totally yet but have closed SSMS and SQL Prompt4 several times with no change in behaviour.
EDIT:
OK, rebooted PC and problem still exists.
Further investigation seems to be that the snippet is streamed to the editor as far as the $ symbol in a UNC reference. The line references a backup location "...-- N'\\Backup1\backups$\sql\..." but after typing the snippet shortcut I only get "...-- N'\\Backup1\backups" on the editor document.
I have changed the snippet name from "b_r" to "backupr" and this hasnt made any difference. Changing the $ to "...-- N'\\Backup1\backups**\sql\..." results in the whole snippet being pasted onto the editor.
Oddly, a few lines previous to the line with the $ in the network location there is a "$CURSOR$" which works fine.
I realise this application is unsupported but wonder if this is important for the import process for SQL Prompt4 release?
END EDIT:
2ndEDIT!
The snippet tool seems to have had issues with the $CURSOR$ too - it put it out in plain text rather than locating the cursor there. Hadnt noticed this at time of first edit.
ENDEDIT!
Jonathan / comments
Tanya,
Thanks for the application but what are the special characters that arent allowed in the snippet names?
The reason that I ask is this:
I have one that was called b_r
I have run the import an...