Please see attached file for the code. Thanks.

Once again Thanks a lot John. WITH RESULT SETS NONE it worked.

So I used this command inside "OLE DB Command" component of SSIS and now I am testing how it...

Thanks John. Here is my SP,

CREATE PROCEDURE p_dba_executesqlcmd

@sqlcmd nvarchar(1000)

AS

BEGIN

SET NOCOUNT ON;

EXEC(@sqlcmd) ;

END

GO

Now when I execute it from query it works,

DECLARE@return_value int

EXEC@return_value = [dbo].[p_dba_executesqlcmd]

@sqlcmd = N'restore database test from...

Thanks Phil and GsSquad it worked, When I added some switches.

set @cmd = '\\localhost\7-Zip\7z e C:\test\servername_dbzip_testdb-20160712.zip -oc:\test\dumps *.bak -y'

yeah when I type \\localhost in windows explorer and because I have shared 7-zip folder, I can browse this path and its my local machine where I am admin

Here is the error message:-

NULL

7-Zip [64] 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18

NULL

NULL

Error:

Incorrect command line

NULL

Thanks all but as I said application is not throwing any exception after I put GO. Also no syntax errors otherwise cant execute SP at all.Anyway thanks. I will go...

So it means something is wrong with query. How to find these incompatible statements? I ran upgrade advisor from 2005 to 2008 to 2012 to 2014 to check for any...

Sure I dont but not a c# or VB developer so hard to troubleshoot if something goes wrong ther. but thanks all.

Thanks.

I did similar thing using Findstring as patindex and charindex is not working in sql 2014

SUBSTRING(@[User::Filename_to_be_deleted], FINDSTRING(@[User::Filename_to_be_deleted], "-", 1)+1, 8)

Thanks everyone. I am only using T-SQL here and when I try this code inside my SSIS it still gives me error saying Error parsing the code.The single quotation mark...

Thanks but is there any command to find upload\download speed somehow?

Thanks all for making it clear now. Thanks.

Hello,

I have sql server and agent running under account called 'domain\service'.

With this account I can execute xp_cmsdhell from SSMS.

Does that mean this account has all those 7 listed privileges under...

This is working. Thanks a lot.