No announcements
Found 2433304 threads
-
1 VotesRun with PowerShell
run->shell:sendto Create a shortcut to powershell with noexit: %SystemRoot%\system32Answered | 4 Replies | 11938 Views | Created by Nils Rune - Thursday, February 25, 2010 1:23 PM | Last reply by jlivingston - Monday, January 31, 2011 8:26 PM
-
0 Votes
Problem Calling Powershell Function to Execute Next Block of Script
how to call my next function to execute the next block of the script. I am green when it comes to written lines of commands. ...Answered | 1 Replies | 2778 Views | Created by Phillysth - Wednesday, May 16, 2012 7:07 PM | Last reply by Peddy1st - Wednesday, May 16, 2012 7:19 PM -
0 Votes
Automating Run Profiles
select your managment agent and select configure run profile, from this dialog you can export a script file ( Vb script, or c# .cs file ) then you can use this file in the ...Answered | 2 Replies | 3162 Views | Created by SarojPallai - Friday, November 14, 2008 2:00 PM | Last reply by Craig Martin - Friday, November 14, 2008 5:45 PM -
0 Votes
windows managment pack help!!!
Easy as pie. Import the MP into your management group. You don't run setup to install MPs - the msi setup that comes with the MP's is merely a transport vehicle ...Answered | 6 Replies | 3549 Views | Created by exitista - Tuesday, September 21, 2010 4:11 PM | Last reply by Dan Rogers - Thursday, September 30, 2010 1:10 AM -
0 Votes
Enable agent proxying with Powershell
Is it possible to influence the agent proxying functionality with Powershell? I'm trying to create a list based on the 'ProxyingEnabled' attribute but ...Answered | 5 Replies | 3921 Views | Created by Bas van der Kruijssen - Monday, August 9, 2010 12:07 PM | Last reply by Bas van der Kruijssen - Tuesday, August 10, 2010 9:10 AM -
0 Votes
Powershell to execute subtraction
Hi Guys , I have a txt file which contain some numbers in it . I want to create a powershell to execute subtraction. Then addition all ...Answered | 1 Replies | 573 Views | Created by Robert Qian - Friday, July 13, 2018 8:21 AM | Last reply by -Mr Happy- - Saturday, July 14, 2018 8:30 PM -
0 Votes
Create and execute a Function from PowerShell commands
this powershell comman: dir function: or are you referring to the more significant "cmdlets" shown by ...Answered | 4 Replies | 2332 Views | Created by Julian Pool - Tuesday, September 10, 2013 9:18 PM | Last reply by Al Dunbar - Wednesday, September 11, 2013 8:52 PM -
3 Votes
"EXECUTE" Function Problem!!
I do not know why can not be EXECUTE used with in a function and I have to use EXECUTE isAnswered | 14 Replies | 11250 Views | Created by debuging - Thursday, December 27, 2007 5:09 AM | Last reply by Jacob Sebastian - Sunday, January 6, 2008 4:42 PM -
2 Votes
Can we execute a powershell function using file name.
function name is added. Another option which may be simpler would be to use the automatic $args variable. Calling your script with .\Myscript.ps1 server1 ...Answered | 4 Replies | 6022 Views | Created by Jaspreet Singh New - Wednesday, November 24, 2010 12:26 PM | Last reply by Jason Hofferle - Wednesday, November 24, 2010 5:44 PM -
0 Votes
Help with function
Sorry why do you need a function here? Cant you just do an inline join operation to get the email ie like SELECT ...Answered | 3 Replies | 564 Views | Created by MattOFB - Tuesday, January 6, 2015 4:52 PM | Last reply by Visakh16 - Tuesday, January 6, 2015 6:44 PM -
0 Votes
Help with Partition Function
Have also tried with the format yyyy-dd-mm and it still fails. CREATE PARTITION FUNCTION ufn_DocumentPartitionByDate (date) as RANGE RIGHT FOR ...Answered | 13 Replies | 1088 Views | Created by Anthony C-UK - Wednesday, July 6, 2016 11:17 AM | Last reply by Anthony C-UK - Friday, July 8, 2016 1:31 PM -
0 Votes
help with Function
In this case you need to use DateName function (check the syntax in BOL DATENAME BOL Reference) although between Monday andAnswered | 8 Replies | 4272 Views | Created by siera_gld - Monday, October 11, 2010 7:22 PM | Last reply by Naomi N - Tuesday, October 12, 2010 7:56 PM -
1 Votes
SSIS won't execute when run from SQL Agent Job
credential, and give the proxy permission to execute SSIS packages. 5. Configure the job step to run under that proxy.Answered | 5 Replies | 8123 Views | Created by Dustin007 - Saturday, June 6, 2009 5:06 PM | Last reply by Todd McDermid - Monday, June 8, 2009 12:44 AM -
2 Votes
Help with DateDiff function
Do you have a problem with the DATEDIFF function itself, or with datatypes? If [Last Claim Filed Date] can be "" (empty string), then it's not a date column. ...Answered | 4 Replies | 913 Views | Created by AlexMartini - Monday, August 22, 2016 5:22 PM | Last reply by Michiel Rozema - NL - Wednesday, August 24, 2016 8:54 AM -
0 Votes
sql agent run as
you need to create a proxy account with credentials that have sufficient priviledges to execute the ssis seeAnswered | 1 Replies | 612 Views | Created by JeffreyShumaker - Saturday, August 25, 2018 7:11 PM | Last reply by Visakh16 - Saturday, August 25, 2018 9:27 PM -
0 Votes
Executing Powershell function in a ps1 file from sql agent
Hi John, Does the function which you want to run through SQL Agent has internal dependencies like the fucntion calling some other ...Answered | 8 Replies | 8653 Views | Created by John Couch - Monday, October 10, 2011 2:17 AM | Last reply by John Couch - Monday, October 10, 2011 4:53 PM -
0 Votes
help with String function
The SUBSTRING function takes 3 parameters. They are expression, starting position, and length. Add the following line at the bottom of your script and run ...Answered | 4 Replies | 1915 Views | Created by Desigal59 - Friday, December 14, 2012 9:33 PM | Last reply by Varsha Mishra - Saturday, December 15, 2012 10:08 AM -
0 Votes
Execute function from query
, VendorZipCode, ContactPhone, AttnPhone, Faxnumber, emailaddress, termskey from APVEND') RETURN; END I now need to ...Answered | 4 Replies | 1036 Views | Created by rqwew - Tuesday, August 6, 2013 7:07 PM | Last reply by rqwew - Tuesday, August 6, 2013 7:39 PM -
0 Votes
Button to execute c# function
always the same, so it's hardcoded. However, I don't know how to create button that will run a C# ...Answered | 9 Replies | 7874 Views | Created by RegX - Thursday, January 31, 2008 2:18 PM | Last reply by RegX - Monday, February 4, 2008 5:45 PM -
0 Votes
Need help with function
And to you can call this function as like tables, only you need to pass the parameter with the same data type.Answered | 17 Replies | 4418 Views | Created by Lasha89 - Monday, August 2, 2010 12:35 PM | Last reply by Lasha89 - Tuesday, August 3, 2010 7:47 AM
No announcements
