[firebird-support] Grant to RDB$ADMIN - capture exception

2012-04-16 Thread Piers Smith
Hello We are trying to migrate some existing users to the new RDB$ADMIN using some dynamic SQL. We have the following SQL for --Gets a list of users from our system select ib_username from user_group_users where user_group_no = 1 into :v_username do begin --Give the user

Re: [firebird-support] Re: Restore problem

2012-04-16 Thread Dmitry Kuzmenko
Hello, Aage! Friday, April 13, 2012, 11:55:38 PM, you wrote: AJ gbak -se service_mgr AJ -fix_fss_metadata ISO8859_1 AJ -fix_fss_data ISO8859_1 AJ -rep -v -z AJ -user SYSDBA -password masterkey AJ E:\...\...\sl1b3_20120412.fbk15 SL1 AJ == AJ Previous restores have

Re: [firebird-support] performance question

2012-04-16 Thread Mark Rotteveel
On Mon, 16 Apr 2012 16:10:21 +0200, Olaf Kluge olaf.kl...@satron.de wrote: Now I have two ideas. I create a table with all fields (separate for each information) and an import stored procedure fill this table with information from the long string. (line_number = substring(:str_in from 1 for

Re: [firebird-support] Monitoring suggestions

2012-04-16 Thread Alexey Kovyazin
Nick, FBScanner http://ib-aid.com/products/firebird_interbase/monitoring/FBScanner Regards, Alexey Kovyazin IBSurgeon Hi, I'm looking for suggestion as to the best way to monitor my installations for slow queries, etc the only options I have been able to identify is to write my own isql

[firebird-support] Re: Restore problem

2012-04-16 Thread Aage Johansen
Dmitry Kuzmenko wrote: if you run same command line for the same DB, i.e. backup/restore, backup/restore, etc, than you killed metadata in it. I think we are facing a major misunderstanding. Note, there are 2 sites involved. 1. Site A is running Fb/1.5. A backup is made nightly from a

Re: [firebird-support] Re: Restore problem

2012-04-16 Thread Michael Ludwig
Dmitry Kuzmenko schrieb am 16.04.2012 um 10:59 (+0400): Friday, April 13, 2012, 11:55:38 PM, you wrote: AJ gbak -se service_mgr AJ -fix_fss_metadata ISO8859_1 AJ -fix_fss_data ISO8859_1 AJ -rep -v -z AJ -user SYSDBA -password masterkey AJ E:\...\...\sl1b3_20120412.fbk15 SL1 AJ