Executing Backup Script With Task Scheduler

Dec 20, 2007

Hello,

I had configured a backup operation with SQL Server Express 2005 and saved the operation as a .sql file. I then configured a task with Task Scheduler to execute this .sql file at a specified time. The text in the Run box for this task is:

"C:Program FilesMicrosoft SQL Server90ToolsBinnSQLCMD.EXE" -S .SQLEXPRESS -i"C:Program FilesMicrosoft SQL ServerFull_M-Th.sql"

I verified this .sql file would run a backup by launching Management Studio Express, opening the file, and then clicking the Execute button. Minutes later, I had a backup. Yet the scheduled task did not run, nor would it run when I manually chose to run it from the list of scheduled tasks. I looked in the Event Viewer, but could not find anything that tipped me off to what I am not doing correctly. If anyone can tell me what might be wrong with the command I pasted above, it would be appreciated.

Thanks for reading!

View 4 Replies


ADVERTISEMENT

Windows Task Scheduler...

Mar 3, 2007

Hi,
 I'm developing an Ads system, which will have an scheduler functionality. Here's how it works: each hour a process will verify and publish an XML file with Ads that have to be shown at that hour. To display the Ad, the "NextDisplay" table's field has to be equal to currently date/HOUR. Then the process will update the "LastDisplay" field with the currently time and call a MsSQL stored procedure that will recalculate the NextDisplay time of the Ad.
My problem is doing this stored procedure. I've based my tables to allow the same schedule rules of the Windows Task Scheduler, so I have to verify each rule to calculate the next display time, but it's a difficult process, 'cause there are a lot of details to be considered.
I thought interoping with Windows Task Scheduler or seeing some code that do something like that, to have some ideas about how to implement it.
Suggestions?
Thx!

View 1 Replies View Related

SQL Service Broker : Task Scheduler

Aug 9, 2006

Hi,

I'm looking to run a "job" on a SQL database regularly (like scheduled by a "task scheduler") to updated my database.

It appears I can use SQL Service broker to run such a job.

Can I embed a "task scheduler" inside my SQL Server database to trigger this job each X seconds?

View 4 Replies View Related

Clear History Automatically From Task-Scheduler

Jan 24, 2001

I use the Task-Scheduler from SQL-SERVER 6.5 to backup and maintain databases. Have you any idea how I can clear the history automatically. I want to clear the history-logs older then 30 days and for 25 SQL-Server is it very costly to delete the history manually. Thanks.

View 1 Replies View Related

SQL2005 Sp2 Upgrade Failed Due To Task Scheduler

Jul 5, 2007

When I install the sp2 in a cluster,the database engine upgrade failed.I found the error log for the install at C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixHotFix.log.
Here's the part that mattered:



07/05/2007 15:34:18.319 Patching available passive node: NODEA
07/05/2007 15:34:18.319 Patching passive node: NODEA
07/05/2007 15:34:18.335 Waiting for first completed passive node
07/05/2007 15:34:18.491 Task Scheduler: Created remote folder for product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.241 Task Scheduler: Created new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Saved new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Created scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:40:06.817 Task Scheduler: Scheduled task for product instance target has completed
07/05/2007 15:40:06.817 Task Scheduler: Waiting for exit code from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Received exit code 29512 from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Result code for scheduled task for product instance target has been received
07/05/2007 15:40:11.817 Task Scheduler: Removed scheduled task for product instance target \NODEA
07/05/2007 15:40:12.333 Task Scheduler: Removed remote folder for product instance target \NODEA
07/05/2007 15:40:12.333 Remote process completed for product instance target
07/05/2007 15:40:12.333 Exit code for passive node: NODEA = 29512
07/05/2007 15:40:13.333 The following exception occurred: No passive nodes were successfully patched Date: 07/05/2007 15:40:13.333 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 3422
07/05/2007 15:40:13.676 Watson: Param1 = Unknown
07/05/2007 15:40:13.676 Watson: Param2 = 0x2b01
07/05/2007 15:40:13.676 Watson: Param3 = Unknown
07/05/2007 15:40:13.676 Watson: Param4 = 0x0
07/05/2007 15:40:13.676 Watson: Param5 = instance.cpp@3422
07/05/2007 15:40:13.676 Watson: Param6 = Unknown
07/05/2007 15:40:13.676 Watson: Param7 = SQL9
07/05/2007 15:40:13.676 Watson: Param8 = Hotfix@
07/05/2007 15:40:13.676 Watson: Param9 = x86
07/05/2007 15:40:13.676 Watson: Param10 = 3042
07/05/2007 15:40:13.676 Installed product: SQL9
07/05/2007 15:40:13.708 Hotfix package completed
07/05/2007 15:40:13.708 Attempting to continue the 32 bit ngen queue



Any advise?Thanks in advance.




View 3 Replies View Related

Transact SQL :: How To Run Query In BAT File In Task Scheduler At Every 10 Seconds

Mar 4, 2015

This is my sql script :

DECLARE @countRows INT,
@currDate DATE,
@checkForTasks INT,
@created_by_id INT,
@gst_ID int;
SET @currDate = Getdate()

This is resided in videos folder of windows , i have created a task schedular in windows 8.1 to run daily at every 10 seconds , but it is not working ...

This sql query is running perfectly in sql server. Query have no errors.

View 9 Replies View Related

Integration Services :: Running SSIS Job Using Windows Task Scheduler

Jul 16, 2015

I am new to the world of ETL. I recently started using SSIS and I have come across couple of questions on this.

1.Can we run a SSIS Package using windows task scheduler?

2. If the above answer is yes,I don't have the SSMS installed on my machine. Can a SSIS package run in the absence of SSMS?(I do have Visual studio and SQL server data tools installed)

3. Can a SSIS Package run in the absence of Visual studio and SQL Server Data Tools.Say for example, I create a SSIS package and then remove Visual studio and SQL server data tools from my machine. Will the Task scheduler still be able to run the SSIS package?

4. Does the SSMS free edition comes along with SQL server Agent?

View 5 Replies View Related

SQL2005 Cluster Setup Failed Due To Task Scheduler And Native Client

Nov 28, 2006

Hi all,
I am trying to setup the cluster SQL server, say ServerA and ServerB. While I start the setup in ServerA, it prompts,
'Setup failed to start on the remote machine. Check the Task scheduler event
log on the remote machine.'

But I found that there is no remote logon to both nodes and the service task scheduler is running in both node.

On the other hand, I try to install the SQL via ServerB, it prompts for valid Native client package 'sqlncli.msi' and caused the setup failed finally. However, the Native client was setup successfully as a prerequisite once starting the setup.

Any advise? Thanks in advance!!

View 5 Replies View Related

Executing A Task With In Script Task

Jun 25, 2007



How can I execute a sql task from a script task. Both these tasks are part of the same package. The script task is actually part of the error handler. The execute sql task is part of control flow in the package.



Thanks

View 4 Replies View Related

Executing SQL Task And Variables

Nov 20, 2007



Hi,

I'm trying to run a statement against all of my servers - I've got about 10 statements working, but am having trouble with this one. It's in a for loop with a connection that is changed by a recordset which is a list of my servers. Here is the code - In the step before, I've created the tempdb.dbo.DBROLES table.




Code Block
declare @dbname as varchar(200)
declare @mSql1 as varchar(8000)
DECLARE DBName_Cursor CURSOR FOR
select '[' + name + ']'
from master.dbo.sysdatabases
where name not in ('mssecurity','tempdb')
Order by name
OPEN DBName_Cursor
FETCH NEXT FROM DBName_Cursor INTO @dbName
WHILE @@FETCH_STATUS = 0
BEGIN
Set @mSQL1 = 'Insert into tempdb.dbo.DBROLES ( DBName, UserName, db_owner, db_accessadmin,
db_securityadmin, db_ddladmin, db_datareader, db_datawriter,
db_denydatareader, db_denydatawriter )
SELECT '''+ @dbName +''' as DBName ,UserName, '+char(13)+ '
Max(CASE RoleName WHEN ''db_owner'' THEN ''Yes'' ELSE ''No'' END) AS db_owner,
Max(CASE RoleName WHEN ''db_accessadmin '' THEN ''Yes'' ELSE ''No'' END) AS db_accessadmin ,
Max(CASE RoleName WHEN ''db_securityadmin'' THEN ''Yes'' ELSE ''No'' END) AS db_securityadmin,
Max(CASE RoleName WHEN ''db_ddladmin'' THEN ''Yes'' ELSE ''No'' END) AS db_ddladmin,
Max(CASE RoleName WHEN ''db_datareader'' THEN ''Yes'' ELSE ''No'' END) AS db_datareader,
Max(CASE RoleName WHEN ''db_datawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_datawriter,
Max(CASE RoleName WHEN ''db_denydatareader'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatareader,
Max(CASE RoleName WHEN ''db_denydatawriter'' THEN ''Yes'' ELSE ''No'' END) AS db_denydatawriter
from (
select b.name as USERName, c.name as RoleName
from ' + @dbName+'.dbo.sysmembers a '+char(13)+
' join '+ @dbNAme+'.dbo.sysusers b '+char(13)+
' on a.memberuid = b.uid join '+ @dbName +'.dbo.sysusers c
on a.groupuid = c.uid )s
Group by USERName
order by UserName'
--Print @mSql1
Execute (@mSql1)
FETCH NEXT FROM DBName_Cursor INTO @dbname
END
CLOSE DBName_Cursor
DEALLOCATE DBName_Cursor;





failed with the following error: "Must declare the variable '@dbName'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Task failed: Put dbroles into table

The program '[10320] DBA_Repository_Load (1).dtsx: DTS' has exited with code 0 (0x0).


I'm going to try creating the procedure on each server - that will probably work - I just don't get why it's not recognizing that variable. The line it is referring to is FETCH NEXT FROM DBName_Cursor INTO @dbName. Thanks for any info on this!

View 3 Replies View Related

Current Executing Task

Dec 8, 2006

Hi everyone

I'm trying to write a monitoring application for SSIS packages deployed on my machine. I know I can look at running packages via the DtsRuntime.Application object's GetRunningPackages method. Does anyone know if there is any way one can view tasks in that package that are currently being executed?

Cheers

Sachin

View 4 Replies View Related

Need Help Executing A Proc In Execute SQL Task

Jan 12, 2008

Hello,
I am trying to use an Execute SQL Task to execute a stored procedure with parameters in SSIS but it keeps giving me errors, for example I type in 'exec someproc ?, ?, ?' in SQL Task it wouldnt parse correctly and when I set the bypassPrepare to 'true' the package runs but gives me error at the destination saying couldnt find stored procedure 'someProc'.

Does anybody know how I can solve this problem?

Also how do I pass the results of the queries in the Execute SQL Task into the Data Flow Task? The proc is supposed to retrieve data and transform them into XML format to be placed at a XML file. I am not sure if I should used an OLEDB source or an XML source since the data has been transformed into XML. Any help will be greatly appreciated.

Please note proc runs fine when it does not have any parameters.

View 8 Replies View Related

Delpoyed Task Hangs On Executing

May 12, 2008

I have a task thet writes to an Oracle database.It works correctly from my development machine, but when I run it from the SQL Server it hangs on "Execute". I installed the Oracle Client on the server and tested it by making an ODBC connection and testing the connection. The task sat on "Executing" for 6 hours before I manually stopped it. It should only take about 1 minute or less. There are no errors in the history log. Does anyone have any suggestions on what I can do to determine why the task hangs on "Execute".

Thanks,
Lee

View 3 Replies View Related

Not Executing SSIS SQL Task By Passing Variable

Jun 11, 2008

Hi,

I am creating SSIS package which using Execute SQL Task to which I am supplying one .sql file code is

delete from Test where ID = @ID

I defined @ID variable to SSIS and also path where .sql file placed but i am not able to execute this package i am getting error like can not find C:@Path file......

As i got information that passing such variable to .sql you need ADO.net connection so I changed SQLSERVER Database connection string to ADO.net .... after that when i set hard core value for these variable i.e for @ID and @Path then it runs sccessfully but by setting parameter i am getting above error


Any suggestion that will be gr8 help for me

T.I.A

View 2 Replies View Related

Error Executing Xp_cmdshell From Within A SQL Task In A DTS Package...

Jul 20, 2005

HelloI am trying to execute ‘xp_cmdshell' from within a DTS package thatwas created by another person. When I try to execute that ‘SQL Task'selectively from within the package, I get the following errormessage:Error Title: Package ErrorError Details:Error Source: Microsoft OLE DB Provider for SQL ServerError Description: xpsql.cpp: Error 87 from GetProxyAccount on line604Why is this error message popping up? When I create a new package(myself) and create an exact same SQL task as above and run it, theSQL task runs fine.Appreciate any help / feedback.Thanks in AdvanceJagannathan Santhanam

View 1 Replies View Related

Data Flow Task Within For Each Loop Not Executing

Aug 22, 2007

All:
I am sure I am missing something really silly but I am not able to figure out what. The For Each Loop uses an ADO Enumerator and passes variable values to a data flow. In executing the package the loop runs fine but nothing is happening to the data flow. When I move the data flow out of the loop it runs fine. What is going on?

Thanks!

desibull

View 14 Replies View Related

Executing A Stored Proc On Another Server From A Scheduled Task

Jul 20, 2005

Ok, I thought this one would be easy.I have a stored proc: master.dbo.restore_database_fooThis is on database server B.Database server A backs up database foo on a daily basis as a scheduledtask.What I wanted to do was, at the end of the scheduled task is then call thestored proc on B and restore the database.If I go into Query Analyzer and log into database A, then execb.master.dbo.restore_database_foo works.But if I take the same command and make it part of the scheduled task itfails.Error is:OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)[SQLSTATE 01000] (Error 7312). The step failed.To me this seems like a permissions issue, but nothing I've tried seems tohave helped.Suggestions?----Greg D. MoorePresident Green Mountain SoftwarePersonal: http://stratton.greenms.com

View 3 Replies View Related

Problem Executing A Oracle Procedure Using Execute Sql Task

Oct 18, 2006

Hi All,

I am trying to execute a Oracle Procedure through Execute Sql Task but it keeps throwing back an error ORA:00900. Is it possible to execute the procedure from this object? Do I need to use the script task to execute this. If yes then how?

Any help would be appreciated.

Thanks in advance.

Amol





View 2 Replies View Related

Executing Stored Procedure With Parameters Using Execute Sql Task

Jul 12, 2006



Hi ,

I am trying to exectue a stored procedure through execute sql task which takes two input parameters table name and filegroup to create a table and it also returns a value.

i am using the oledb connection

but i am getting the following error



[Execute SQL Task] Error: Executing the query "declare @rtn_value int exec spm_Utopia_FinanceUsage_Create_MonthlyTable ?,? select @rtn_value as rtn_value " failed with the following error: "Syntax error or access violation". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.



i tried with ado.net connection by directly giving the parameter names.

it will create a table but the the table name is something different from what i specified



Please do help as soon as possible



Thanks

Manish



View 2 Replies View Related

Timeout Error When Executing SQL Command From The Script Task

Apr 18, 2008



The SQL query takes about 4 minutes to execute in SQL Management Studio. But when I run it from the Script Task using the OleDBCommand, I got the timeout error in 40 seconds. The timeout setting on the SSIS DB connection is 0. I do not see how to set the timeout for an SSIS task. Any thoughts on this problem? TIA.

View 8 Replies View Related

How To Programmatically Detect The Failed Task After Executing The Package

Apr 27, 2007

SSIS Experts,

I am executing a child package programmatically and want few lines of code to detect cause of the failure on the fly. One way will be to run the child package through dtexec command uility. But on the fly i will be assigning few values in Parent package variable to the child variables and finally run the child package. Since we cannot apply expressions or use precendence constraints in place, It seems that we are left with only choice to programmatically detect errors in tasks. In DTS, it was achieved this way:






Code Snippet

For Each ostep In oPkg

If ostep.ExecutionResult = DTSStepExecResult_Failure Then

ProcessSubDTSPackage = DTSTaskExecResult_Failure

End If

Next





Thanks

Subhash Subramanyam

View 4 Replies View Related

Executing A Batch Script From Execute Process Task

Aug 22, 2006

Hello,

I have an "execute process" task which executes a perl script. When I run the task, it shows a prompt with the message "the publisher can not be verified". It gives the option to continue the task or to cancel.

The problem for me is that I want to schedule this package to run automatically, and I don't want the automated process to show this dialog. I need to override the security setting and have SSIS execute my batch scripts without prompting. Assuming I don't want to rewrite the Perl code into a script task, is there a way to do acomplish this?

Thanks!

Arkadiy

View 2 Replies View Related

Executing MAXL Scripts In Execute Process Task

Jul 20, 2007

Hello,



first of all a few words about our achitecture:

we have a windows 2003 server with sql sever 2005 and connect on this server with 3 clients (Visual Studio) on the Windows 2003 Server there is also an Hyperion Essbase Server installed.

In the Visual Studio I try to execute a batch script which is located on the server. But how i develop that? I have tried to rebuilt the servers File structure and save the Package on the Server. < didn't worked



My Question how can I make a package in which I execute a bat file which is located on the Server without developing it on the Server?



Thank you in advance!

View 1 Replies View Related

Executing An SSIS Package Containing A Data Mining Query Task From A SQL Job

Mar 28, 2007

Hi, I'm new to this forum, so please bare with me.

I've created a mining model, i've tweaked it etc and i'm now happy with the results its producing. I'm now looking to automate the processing and exporting of the results of the model i've done this simply by creating an SSIS package with two tasks, one task being to process the model the other task is a Data Mining Query task.

This package works fine in visual studio and when i deploy it to the server.

The problem i'm having is when i then try to execute the package from a job, after a bit of investigating i have tracked it down to the Encryption of "sensitive" properties. By default the encryption is based on UserKey which is why the package works for me when i execute it from VS or even the server, but when the job trys to execute the package running under the sql agent account it fails.

Looking at the security options i have for packages, i can either DontSaveSensitive, EncryptSensitiveWithUserKey or EncryptSensitiveWithPassword plus a few others.

DontSaveSenstive is clearly not an option as this just creates an unusable package.

EncrptSensitiveWithUserKey doesn't seem to be an option as the job runs under the SQL Agent account (also i'm thinking that the UserKey that the encryption is based on also incorporates other factors related to my profile that i can't impersonate? i might be wrong though)

EncryptSensitveWithPassword seems to be an option except that i can't get this to work either, there doesn't seem to be anyware in the job step to give it the password information.

Its frustrating me now because i've fallen at the very last hurdle, if anyone else has experienced this problem and knows how to resolve it that would great.

Thanks

Bob.























View 3 Replies View Related

Reg: Executing And Passing Arguements To Exe Using SSIS Execute Process Task

Apr 22, 2008

Hi,

Can any one give me a solution how to call exe. Also, i need to pass 1 input to that exe.
I tried using Execute process task but it is not working.

My task is:

I have DFT , it generate a output file then after the output file generated i need to upload it SharePoint server.
So i developed one .exe using .net, C#. ( it is running fine when cmd line)

But i want to embbed in SSIS package.

Like :

DFT ( DataFlowTask) --------------------> OutPutFile.txt

EPT ( ExecuteProcessTask) ----------> Upload it to SharePointPortal.


Kindly give the solution ASAP.

Thanks
Senthil

View 4 Replies View Related

Map Resultset From Executing A Stored Proc Into Input Columns Of A Data Flow Task

Jul 30, 2007



I need to loop the recordset returned from a ExecuteSQL task and transform each row using a Data Conversion task (or a Script Task).

I know how to loop the recordset returned by an ExecuteSQL task:

http://www.sqlis.com/59.aspx

I loop the returned recordset (which is mapped to a User variable of type System.Object) and assign the Variable Mappings in the ForEach Loop to different user variables which map to the Exec proc resultset (with names and data types).

I assume to now use these as the Available Input columns for the Data Conversion task, I drag a Data Flow task inside the For Each Loop container and double-click it, then add a Data Conversion task.

But the Input columns (which I entered in the Variable Mappings in the ForEach Loop containers) dont show up in the Available Input columns of the Data Conversion task.

How do I link the Variable Mappings in the ForEach Loop containers from the recordset returned by the Execute SQL Task to the Available Input columns of the Data Conversion task?

.......................

If this is not possible, and the advice is to use the OLEDB data flow as the input for the Data Conversion task (which is something I tried too), then the results from an OLEDB Command (using EXEC sp_myproc) are not mapped to the Available Input columns of the Data Conversion task either (as its not an explicit SQL Statement and the runtime results from a stored proc exection)

I would like to use the ExecuteSQL task to do this as the Package is clean and comprehensible. Which is the easiest best way to map the returned results from a Stored proc execution to the Available Input columns of any Data Flow transformation task for the transform operations I need to execute on each row of data?

[ Could not find any useful advice on this anywhere ]

thanks in advance!

View 4 Replies View Related

Integration Services :: Oracle Procedure Is Not Returning Results When Executing From Script Task On SSIS

Jul 13, 2015

I'm executing Oracle procedure, which has three OUTPUT parameters and returns results in table type variable. i should not use ODBC, MSDAORA providers to call the procedure. So I'm planning to using Oracle OLEDB provider. I'm able to execute the procedure successfully, but when i do check (while dr.Read()) its not returning any records. But I know as per stored procedure results, it should return 66 records.

Dim conn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Dim QSQL As String

[code]...

View 10 Replies View Related

Execute SQL Task: Executing The Query Exec (?) Failed With The Following Error: Syntax Error Or Access Violation. Possible F

Jan 23, 2008

Hi,
I'm having an SSIS package which gives the following error when executed :

Error: 0xC002F210 at Create Linked Server, Execute SQL Task: Executing the query "exec (?)" failed with the following error: "Syntax error or access violation". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Task failed: Create Linked Server

The package has a single Execute SQL task with the properties listed below :

General Properties
Result Set : None

ConnectionType : OLEDB
Connection : Connected to a Local Database (DB1)
SQLSourceType : Direct Input
SQL Statement : exec(?)
IsQueryStorePro : False
BypassPrepare : False

Parameter Mapping Properties

variableName Direction DataType ParameterName

User::AddLinkSql Input Varchar 0


'AddLinkSql' is a global variable of package scope of type string with the value
Exec sp_AddLinkedServer 'Srv1','','SQLOLEDB.1',@DataSrc='localhost',@catalog ='DB1'

When I try to execute the Query task, it fails with the above error. Also, the above the sql statement cannot be parsed and gives error "The query failed to parse. Syntax or access violation"

I would like to add that the above package was migrated from DTS, where it runs without any error, eventhough
it gives the same parse error message.

I would appreciate if anybody can help me out of this issue by suggeting where the problem is.

Thanks in Advance.

View 12 Replies View Related

Initiate Net Backup Task

Oct 5, 2012

I am trying to initiate a Netbackup task from a SQL Job using the following CmdExec code:

"C:Program FilesVERITASNetBackupnindbbackex.exe" -f "C:Program FilesVeritasNetBackupDbExtMsSql<Filename.bch>" -p <profilename> -u <username> -pw <password> -s <server> -np

If I run it from a Command Prompt window it works fine, however if I copy the exact same code into a SQL Job and use the job type 'Operating System (CmdExec)' it fails to run. All I get in the Job History is: "Executed as user: DomainUsername. The step did not generate any output. Process Exit Code 2. The step failed."

I have managed to get this to work on another almost identical server using the same accounts and everything but for some reason it won't run on the one I'm currently using.

View 6 Replies View Related

Backup Database Task

Jun 14, 2006

Hi,

I am trying in the Back Up Database Task to set the Value of SelectedDatabases via Expression.
Is there any way?

Thanks,

Willfried

SQL Server 2005 SP 1 + Hotfix

View 1 Replies View Related

Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Qu

Jan 24, 2008



Hi,

I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query window

Please see the image through this url http://kyxao.net/127/ExecutionProblem.png


Any ideas for this issue?

Thanks a lot

View 1 Replies View Related

Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Query Window

Jan 23, 2008

Hi,I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query windowPlease see the image attached http://kyxao.net/127/ExecutionProblem.png Any ideas for this issue?Thanks a lot Jalijack 

View 2 Replies View Related

Different Results When Executing From .NET Component Compare To Executing From SQL Management Studio

Oct 10, 2006

Hi all,I am facing an unusual issue here. I have a stored procedure, that return different set of result when I execute it from .NET component compare to when I execute it from SQL Management Studio. But as soon as I recompile the stored procedure, both will return the same results.This started to really annoying me, any thoughts or solution? Thanks very much guys

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved