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

Activity overview

Latest activity by EsioN

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
Error in startup after upgrade to SP3.9
  1. Community
  2. SQL Prompt Previous Versions
Hello. After I updgrade my SP to version 3.9, the "SQL Prompt Query Analyzer Integration" shortcut was created in window program group "Startup". But my windows is in Portuguese, the correct group ...
2 followers 2 comments 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
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
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
Improvement for insert statement.
  1. Community
  2. SQL Prompt Previous Versions
When typing insert dbo.xxx, it'g greath when SP3.5 show me the column list and the values (/* type */ default_value). Can be more usefull if, with the /* type */ SP brings me also the column name. ...
1 follower 1 comment 0 votes
Problems with alter trigger
  1. Community
  2. SQL Prompt Previous Versions
Some of my trigger has blank line before the create trigger statement. For these trigger, SP3.5 doesn't show me the code. They are listed in alter trigger <trigger list), but the code doesn't appea...
2 followers 3 comments 0 votes
Shortcut to Disable
  1. Community
  2. SQL Prompt Previous Versions
A shortcut to disable SP3.5 can be good. Thanks Ésio
1 follower 1 comment 0 votes
Tables don't appear after dbo.
  1. Community
  2. SQL Prompt Previous Versions
Hi. Typing select * from dbo. the tables don't appear. I need to press ctrl+space to see the tables. Or type the two first letter of the table name, ex: select * from dbo.or -> orders But typing se...
2 followers 4 comments 0 votes
Total activity
86
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
21