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
Total activity
86
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
21