Click here to Skip to main content
15,897,187 members

Comments by Sudheer Nimmagadda (Top 12 by date)

Sudheer Nimmagadda 2-Dec-13 7:37am View    
if i shutdown,i don't have permissions to o restart Service of SQL Server
Sudheer Nimmagadda 22-Oct-13 8:25am View    
Sir ,

i have to refresh PivotTables in excel
your code is working excellent for tables but not PivotTable

please help me for PivotTable refreshing
Sudheer Nimmagadda 22-Oct-13 6:59am View    
Thank you very much Sergey Vaselenko, it is useful
Sudheer Nimmagadda 20-Mar-13 0:47am View    
Hi Dave Kreskowiak,

thanks for your reply, but xp_cmdshell is return 0 or 1 based on result its ok,
But my problem is every day at the same time we have to run multiple procedures,
these procedures are using xp_cmdshell and if it is bulk usage on that time it is crashes and not working, please give me how can i know whether the xp_cmdshell is working or not
Sudheer Nimmagadda 12-Oct-12 14:10pm View    
i have to run dos command's from Sql Server Procedure, for that i used xp_cmdshell it was worked fine upto last night but now it is not working , it is showing always Null value for all commands Ex: xp_cmdshell 'dir' . Before it was shown all files and directories now it is showing null , could you please help me with right direction