Welcome to
Sign in
|
Help
in
T-SQL (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
T-SQL
»
Re: pornire exe din sql
pornire exe din sql
Last post 03-12-2012, 10:58 PM by
MrSmersh
. 22 replies.
Page 1 of 2 (23 items)
1
2
Next >
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
02-08-2012, 1:20 PM
9087
neo
Joined on 11-06-2007
Bucharest
sysadmin
pornire exe din sql
Reply
Quote
Salut,
Exista posibilitatea de a porni un exe sau un .bat din SQL Server 2005 SP1 (fara a pune alte sp-uri) ?
Multumesc.
G.
Report abuse
02-08-2012, 1:46 PM
9088
in reply to
9087
Diana
Joined on 03-21-2006
sysadmin
Re: pornire exe din sql
Reply
Quote
http://msdn.microsoft.com/en-us/library/ms175046.aspx
http://blog.sqlauthority.com/2007/06/27/sql-server-running-batch-file-using-t-sql-xp_cmdshell-bat-file/
Report abuse
02-08-2012, 1:58 PM
9089
in reply to
9088
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
Buna Diana,
Tu reusesti sa pornesti din SQL2005 un exe sau un bat ?
Pentru ca inainte sa scriu aici, m-am uitat in BOL , pe forumuri si imi apare clasica problema....."ingheta" fereastra de sql la nesfarsit si nu se intampla nimic. Mentionez ca am activat sp_cmdshell-ul, am incercat si cu sp_xp_cmdshell_proxy_account si inca nu am reusit.
Multumesc.
G.
Report abuse
02-08-2012, 2:32 PM
9090
in reply to
9089
Diana
Joined on 03-21-2006
sysadmin
Re: pornire exe din sql
Reply
Quote
Nu am probleme pe un SQL 2005 dev SP2 / Win 2008 Server Enterprise SP2 ca si "sysadmin".
Descrie-mi in detaliu problema ta daca vrei sa incerc sa o reproduc.
Report abuse
02-08-2012, 3:26 PM
9091
in reply to
9090
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
Am un sql server
2005 SP1
ca si configuratie cu
xp_cmdshell activat.
am pe
c:\
in
q.bat
comanda
start notepad.exe
Intr-o ferestra SQL Query rulez comanda:
EXEC master..xp_CMDShell 'c:\q.bat'
..fara rezultat...
Multumesc.
G.
Report abuse
02-09-2012, 1:35 AM
9092
in reply to
9091
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: pornire exe din sql
Reply
Quote
pune q.bat intr-un folder
pe folder pune security pe everyone
incearca din nou
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse
02-09-2012, 8:33 AM
9093
in reply to
9092
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
Am incercat si asa (EXEC master..xp_CMDShell 'c:\q\q.bat') cu security pe everyone
....si nu merge ....
G.
Report abuse
02-09-2012, 9:01 AM
9094
in reply to
9093
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
ruleaza la nesfarsit....
G.
Report abuse
02-09-2012, 9:05 AM
9095
in reply to
9094
Diana
Joined on 03-21-2006
sysadmin
Re: pornire exe din sql
Reply
Quote
Vezi daca sunt in loguri (SQL, Windows) mesaje de interes.
Report abuse
02-09-2012, 10:22 AM
9096
in reply to
9095
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
Logurile sunt curate.
Voua va merge scriptul meu pe 2005 ...???
G.
Report abuse
02-09-2012, 8:50 PM
9097
in reply to
9094
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: pornire exe din sql
Reply
Quote
cum adica,
ruleaza la nesfarsit....
?
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse
02-10-2012, 8:06 AM
9098
in reply to
9097
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
adica vre-o ora doua...
G.
Report abuse
02-10-2012, 8:07 AM
9099
in reply to
9098
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
tie iti merge sa pornesti din 2005 un exe? daca da inseamna ca nu fac eu ceva...
G.
Report abuse
02-10-2012, 10:03 PM
9102
in reply to
9098
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: pornire exe din sql
Reply
Quote
ciudat... oricum, porneste , nu?
Fa un bat cu o scriere de fisier.
Daca merge si nu ruleaza 1 ora, inseamna ca e o problema cu exe-le.
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse
02-11-2012, 9:32 AM
9103
in reply to
9102
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: pornire exe din sql
Reply
Quote
Nu merge de nici o culoare andrei.
Tie iti merge sa pornesti un exe chior?
Bat-ul normal ca functioneaza daca il pornesc de mana si executa fix ceea ce contine : porneste notepad scrie siteste etc...
Intrebarea e cum fac asta din sql sa declansez un bat; sa pornesc un exe etc.
G.
Report abuse
Page 1 of 2 (23 items)
1
2
Next >