How can we help you today? How can we help you today?
EsioN
Activity overview Badges (0) Posts (38) Comments (27)

Comments

Sort by recent activity
Hi Matthew. Yes, copying the shortcut to my 'Inicializar' folder solved the question. Esio / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Error in startup after upgrade to SP3.9
Hi Matthew. Yes, copying the shortcut to my 'Inicializar' folder solved the question. Esio
0 votes
There is a gap. When typing the insert for existent tables, the SP3.8 doesn't bring the identity colum (and I'm happy for this), but if you create a new table and type the insert command, so SP3.8 will mount the insert command based on the create table script, it brings the identity column. Regards, Esio / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. identity column does not show on auto-completed INSERT
There is a gap. When typing the insert for existent tables, the SP3.8 doesn't bring the identity colum (and I'm happy for this), but if you create a new table and type the insert command, so SP3.8 ...
0 votes
Hi Bart. I tried to understand this, but can't explain this also. And look, if I use the following statement, but with alter table, with the blank lines before the statement, when I refresh the cache. SP35 now can show the trigger code, but doesn't show the blank lines ********************** CREATE trigger AMZ_Delete on dbo.ARMAZEM for DELETE as select * into #inseridos from inserted select * into #deletados from deleted execute dbo.pr_Grava_Log 'ARMAZEM' @ERROR <> 0 GOTO Erro return ERRO: begin ROLLBACK TRANSACTION @servername) RETURN end ******************************* / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Problems with alter trigger
Hi Bart. I tried to understand this, but can't explain this also. And look, if I use the following statement, but with alter table, with the blank lines before the statement, when I refresh the cac...
0 votes
select * from dbo. <popup doesn't appear> select * from dbo.A <popup doen't apper> select * from dbo.AC <popup appears with my tables/views starting with AC. With the popup showed , ff I delete de AC, the popup show all objects> select * from dbo.. <popup appears normaly, but note I typed two "."> select * from dbo. <pressing ctrl+space, popup appears> Thanks Ésio / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Tables don't appear after dbo.
select * from dbo. <popup doesn't appear> select * from dbo.A <popup doen't apper> select * from dbo.AC <popup appears with my tables/views starting with AC. With the popup showed , ff I delete de ...
0 votes
Some behaviors I'm experiencing: I got the following resulte while testing SP3.5 in a server configured as "Connections to ignore". After pasting the script in QA, my CPU use goes to 100% by QA. It's ok, SP3.5 is parsing the code, but note: It is a connection to ignore... Does it make sense to parse this connection? The most part of the code, is commented code. Again, does it make sense to parse this? But ok, probably there is a good reason do SP team thinking this behavior. I think we talked about this in SP3.0 beta discussion. Going ahead. My question is: if I navigate in the code using the arrows keys, or point the cursor using the mouse, in some parts of the script, no problems. No delays. But if I put the cursor from columns 1 to end of the first word + blank space , my cpu use goes to 100% again for some moments!!! Too stange!! Ex->exec sp_rename.... cursor from column 1 to 6 now, (removig exec command form all senteneces) so: Ex->sp_rename ....cursor from colum 1 to 11 The code (as you can see, there is a lot of blank spaces, no tabs): exec sp_rename 'PK__ACESSO_USUARIO_D__71139959','PK__ACESSO_USUARIO_DEPOSITO_CLIENTE', object -- PK__ACESSO_USUARIO_D__71139959 PK__ACESSO_USUARIO_DEPOSITO_CLIENTE ACESSO_USUARIO_DEPOSITO_CLIENTE exec sp_rename 'PK__FLUXO_FERRO_NIOB__0AD36B5C','PK__FLUXO_FERRO_NIOBIO_REL', object -- PK__FLUXO_FERRO_NIOB__0AD36B5C PK__FLUXO_FERRO_NIOBIO_REL FLUXO_FERRO_NIOBIO_REL exec sp_rename 'PK__FLUXO_FERRO_NIOB__440BE8B8','PK__FLUXO_FERRO_NIOBIO_REL_AGRUPAMENTO', object -- PK__FLUXO_FERRO_NIOB__440BE8B8 PK__FLUXO_FERRO_NIOBIO_REL_AGRUPAMENTO FLUXO_FERRO_NIOBIO_REL_AGRUPAMENTO exec sp_rename 'PK__FLUXO_FERRO_NIOB__45F4312A','PK__FLUXO_FERRO_NIOBIO_REL_USUARIO', object -- PK__FLUXO_FERRO_NIOB__45F4312A PK__FLUXO_FERRO_NIOBIO_REL_USUARIO FLUXO_FERRO_NIOBIO_REL_USUARIO exec sp_rename 'PK__IMP_DESPESA_DESP__2C345F27','PK__IMP_DESPESA_DESPACHANTE_ITEM_DOCSAP', object -- PK__IMP_DESPESA_DESP__2C345F27 PK__IMP_DESPESA_DESPACHANTE_ITEM_DOCSAP IMP_DESPESA_DESPACHANTE_ITEM_DOCSAP exec sp_rename 'PK__INVOICE_NOTA_FIS__60A82766','PK__INVOICE_NOTA_FISCAL', object -- PK__INVOICE_NOTA_FIS__60A82766 PK__INVOICE_NOTA_FISCAL INVOICE_NOTA_FISCAL exec sp_rename 'PK__NOTA_FISCAL_ENTR__41EE961C','PK__NOTA_FISCAL_ENTRADA', object -- PK__NOTA_FISCAL_ENTR__41EE961C PK__NOTA_FISCAL_ENTRADA NOTA_FISCAL_ENTRADA exec sp_rename 'PK__ORDEM_PRODUCAO_C__22AAF4ED','PK__ORDEM_PRODUCAO_CONTROLE_STATUS', object -- PK__ORDEM_PRODUCAO_C__22AAF4ED PK__ORDEM_PRODUCAO_CONTROLE_STATUS ORDEM_PRODUCAO_CONTROLE_STATUS exec sp_rename 'PK_PAIS_AGRUPAMENTO','PK__PAIS_AGRUPAMENTO', object -- PK_PAIS_AGRUPAMENTO PK__PAIS_AGRUPAMENTO PAIS_AGRUPAMENTO exec sp_rename 'PK__PESQUISA_DESENVO__78B4BB21','PK__PESQUISA_DESENVOLVIMENTO_SUB_CONTA', object -- PK__PESQUISA_DESENVO__78B4BB21 PK__PESQUISA_DESENVOLVIMENTO_SUB_CONTA PESQUISA_DESENVOLVIMENTO_SUB_CONTA exec sp_rename 'PK__PRODUTO_TBP__5907059E','PK__PRODUTO_TBP', object -- PK__PRODUTO_TBP__5907059E PK__PRODUTO_TBP PRODUTO_TBP exec sp_rename 'PK__SUB_CLIENTE_ENDE__276FAA0A','PK__SUB_CLIENTE_ENDERECO', object -- PK__SUB_CLIENTE_ENDE__276FAA0A PK__SUB_CLIENTE_ENDERECO SUB_CLIENTE_ENDERECO exec sp_rename 'PK__SUB_CONTRATO_ESP__5B24583A','PK__SUB_CONTRATO_ESPEC_GRANUL', object -- PK__SUB_CONTRATO_ESP__5B24583A PK__SUB_CONTRATO_ESPEC_GRANUL SUB_CONTRATO_ESPEC_GRANUL exec sp_rename 'PK__SUB_CONVERTE_MOE__562A98F3','PK__SUB_CONVERTE_MOEDA_DOLAR', object -- PK__SUB_CONVERTE_MOE__562A98F3 PK__SUB_CONVERTE_MOEDA_DOLAR SUB_CONVERTE_MOEDA_DOLAR exec sp_rename 'PK__SUB_VENDA_ENTREG__3B76A2B7','PK__SUB_VENDA_ENTREGA_CONTRATO', object -- PK__SUB_VENDA_ENTREG__3B76A2B7 PK__SUB_VENDA_ENTREGA_CONTRATO SUB_VENDA_ENTREGA_CONTRATO / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Editor performance very poor
Some behaviors I'm experiencing: I got the following resulte while testing SP3.5 in a server configured as "Connections to ignore". After pasting the script in QA, my CPU use goes to 100% by QA. It...
0 votes
Ok Bart. It's now clear for me what is happening. Well, for me, it isn't the perfect environment, but of course, this little problem will not decrease all benefit SP brought. We can survive with this ;-) Thanks a lot for your clearly response. Best regards Ésio / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Procs/funcitions code in cache
Ok Bart. It's now clear for me what is happening. Well, for me, it isn't the perfect environment, but of course, this little problem will not decrease all benefit SP brought. We can survive with th...
0 votes
Bart. I don't have a specific script. I just type my statementes in one database, then I clear my command window (using ctrl+shift+del), then I type use <db> alt+x, then I again clear my command window and start typing my new command. Sometimes, SQL Prompt brings me the oldier database schema. Ésio Nunes / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. USE command sometime don't work
Bart. I don't have a specific script. I just type my statementes in one database, then I clear my command window (using ctrl+shift+del), then I type use <db> alt+x, then I again clear my command wi...
0 votes
Hi Tilman. Another question. I was using QA, using a specific login user (windows login). Then, for a specific reason, I needed to open a second window, in the same server/database, but using another sql login. SPv3 than started getting the schema again. The same schema I think. I'm presuming you are not checking the permissions wich user have in database (I tested this, SPv3 bring me a table in intelissense that my user don't have permission). So, why is it necessary do get the schema again? Another question, is, maybe can be a good idea, when opening a new widow, a dialog box asking if the user want's to use intelissense in this windows. I think in SQL Prompt 2 it's work. In the sample above, I needed to disable SPv3 and open a new QA application with the second user. Thanks Ésio Nunes / comments
  1. Community
  2. SQL Prompt 3
  3. Refresh Cache cancelation.
Hi Tilman. Another question. I was using QA, using a specific login user (windows login). Then, for a specific reason, I needed to open a second window, in the same server/database, but using anoth...
0 votes
Hi Tilman. I'm sorry, I didn't undestand "schema panel". Is this QA Object Browser? If it is; yes I can my schema information there. Regards, Ésio / comments
  1. Community
  2. SQL Prompt 3
  3. Error generatin alter procs/functins script
Hi Tilman. I'm sorry, I didn't undestand "schema panel". Is this QA Object Browser? If it is; yes I can my schema information there. Regards, Ésio
0 votes
Tilman wrote: Hi Ésio, A tested SPv3 with some procs and functions, but, in a specifc database, when I try to alter some functions (ex. dbo.fuQ_Banco), when I start typing the clause, SPv3 completes the function name, but concatenet the function name again, and of couse, can generate the script: alter function dbo.fuQ_BancofuQ_Banco] cannot be scripted. The object may be encrypted. It's happing sometime wih procedures too. I've added an issue to our list. Part of the problem is that Prompt can't read the SQL definition of your function. This happens with system objects in SQL Server 2005, due to encryption. It can also happen when you don't have sufficient permissions. Esio wrote: Tilman, I'm using SQL 2000 and not SQL 2005 (just to precise your response). My user objects aren't encrypted. And my problem are occurring with user objects, not system objects. And, I have all previleges in databases. So I think this problem is really a bug. Are my procs/functions source code stored in memory? What happens if: I open my QA -> SPv3 reads my database schema. Anoter user change one proc souce I use alter proc -> SPv3 get the source from memory, or it go back in database to get the fresh source? The first time Prompt sees a database it reads the schema and stores it in a file. All subsequent times it reads the schema from that file to speed things up. You can refresh this file manually by using the Cache Management dialog (via the SQL Prompt menu). For example, if you add a new table to your database, you would want to update this file. In the final version we will provide some mechanism to automatically refresh the schema cache, aswell as a keyboard shortcut to refresh the current database. Esio wrote: Perfect!! I was worried about too much code in memroy Regards, Tilman / comments
  1. Community
  2. SQL Prompt 3
  3. Error generatin alter procs/functins script
Tilman wrote: Hi Ésio, A tested SPv3 with some procs and functions, but, in a specifc database, when I try to alter some functions (ex. dbo.fuQ_Banco), when I start typing the clause, SPv3 com...
0 votes
Total activity
86
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
21