Welcome to Sign in | Help
» Search

Search

You searched for the word(s):
Showing page 26 of 39 (389 total posts) < 1 second(s)
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    am inteles care e problema dar nu si cum se rezolva.... &nbsp;am impartit triggerul in 2....unul pt INSERT altul pt UPDATE acum insertul merge struna dar la update inca nu stiu cum sa-l opresc sa nu intre in bucla infinita INSERT-ul arata asa: alter TRIGGER [trg_Equival_INSERT] ON [dbo].[EQUIVAL]FOR INSERTASif ((select ...
    Posted to T-SQL (Forum) by Alex on June 25, 2007
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    ba nu....nu are treaba....vad ca acum functioneaza cum trebuie in ambele variante...era de la un alt trigger :) dar mai am o problema....primesc eroarea ''Server: Msg 925, Level 19, State 1, Procedure trg_Equival_INSERT_UPDATE, Line 15Maximum number of databases used for each query has been exceeded. The maximum allowed is 8. Connection ...
    Posted to T-SQL (Forum) by Alex on June 25, 2007
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    se pare ca trebuia asa la trigger_nestlevel: if ((select trigger_nestlevel(object_id(N'[dbo].[trg_Equival_INSERT_UPDATE]')))=1) &nbsp; oricum sunt sigur ca poate fi imbunatatit sau ca nu iau in calcul tot...simt ca-i lipseste ceva...:) alex.
    Posted to T-SQL (Forum) by Alex on June 25, 2007
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    ceva este gresit....dar nu-mi dau seama ce......ce ar mai trebui facut?...ceva sugestii?....daca fac un insert pe tabela respectiva imi da o eroare ''Server: Msg 925, Level 19, State 1, Procedure trg_Equival_INSERT_UPDATE, Line 14Maximum number of databases used for each query has been exceeded. The maximum allowed is 8. Connection ...
    Posted to T-SQL (Forum) by Alex on June 25, 2007
  • trigger de INSERT,UPDATE - SQL Server 2000

    salut, am 3 baze de date pe acelasi server.....fiecare baza de date contine tabela aceasta: CREATE TABLE [dbo].[EQUIVAL] (&nbsp;[CURIDREF] [int] NOT NULL ,&nbsp;[RATEDATE] [datetime] NOT NULL ,&nbsp;[CURID] [int] NOT NULL ,&nbsp;[PURCHASERATE] [float] NULL ,&nbsp;[FIXINGRATE] [float] NULL ,&nbsp;[SALESRATE] [float] NULL ) ON [PRIMARY]GO ALTER ...
    Posted to T-SQL (Forum) by Alex on June 25, 2007
  • Re: cum creez un folder in T-SQL (SQLServer 2000)

    merge :) SET @tmpServer='master..xp_cmdshell' &nbsp;SET @tmpSQL='NET USE X: \\' + @SysServerName + '\' + @ParentBackupPath&nbsp;EXEC @tmpServer @tmpSQL &nbsp;SET @tmpSQL='COPY ' +&nbsp; @LocalBackUPPath + '\' + @PackFileName + ' X:\'&nbsp;EXEC @tmpServer @tmpSQL&nbsp;SET @tmpSQL='DEL ' +&nbsp; @LocalBackUPPath + '\' + @PackFileName&nbsp;EXEC ...
    Posted to T-SQL (Forum) by Alex on June 21, 2007
  • Re: cum creez un folder in T-SQL (SQLServer 2000)

    ggciubuc:Acum chiar ca trebuie design de package DTS ! imi poti explica mai mult legat de cum trebuie sa arate acest DTS, daca e o varianta mai simpla....ma gandesc ca dupa ce se executa jobul care apeleaza procedura care face backupul si pe urma arhiva....sa se execute DTS-ul care sa mute respectivul file de pe diskul meu local pe un altul din ...
    Posted to T-SQL (Forum) by Alex on June 21, 2007
  • Re: cum creez un folder in T-SQL (SQLServer 2000)

    totul functioneaza super ok.....face si maparea respectivului folder (net use) dar cand incearca sa execute SET @tmpSQL='COPY x:\' + ' ' + '''' + @PathToMove + @PackFileName -- + '''' -- + @ParentBackupPath + '\' + @PackFileName&nbsp;EXEC @tmpServer @tmpSQL primesc eroarea: x:\* The system cannot find the file ...
    Posted to T-SQL (Forum) by Alex on June 21, 2007
  • Re: cum creez un folder in T-SQL (SQLServer 2000)

    eu am incercat sa fac ceva inspirat dintr-un alt exemplu....ceva de genul -- pentru serverele din lan se va folosi mapare la copiere &nbsp;SET @tmpServer='master..xp_cmdshell' &nbsp;SET @tmpSQL='NET USE x: \\' + @SysServerName + '\' + @ParentBackupDrive --+ SUBSTRING(@ParentBackupDrive,1,1) + '$'&nbsp;EXEC @tmpServer @tmpSQL &nbsp;SET ...
    Posted to T-SQL (Forum) by Alex on June 21, 2007
  • Re: backup (SQL Server 2000) pe un disk extern...se poate face?

    da...merge perfect :)....multumesc mult dar as vrea sa fac si din procedura.....sa completez procedura asta :) http://sqlserver.ro/forums/thread/2023.aspx alex.
    Posted to Intrebari generale (Forum) by Alex on June 21, 2007
« First ... < Previous 24 25 26 27 28 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems