DTS Not Running SPs
Aug 1, 2000
I have a DTS package that executes 4 stored procedures. The first procedure runs fine, then on success, DTS blows through the next 3 SPs. It shows completion and success, but they are not running. I have tried breaking them out into separate SQL tasks, same result. I have run profiler and the SP is being sent, but obviously is not running. I tried to insert the SQL statements instead of the EXECUTE SP_NAME with the same results. Help me OBI-WON-KENOBEEs your my only hope.
Peter Cwik
View 1 Replies
ADVERTISEMENT
May 28, 2015
In my environment, there is maintenance plan configured on one of the server and while running DBCC checkdb on a database of size around 200GB, log file usage of tempdb is increasing and causing the maintenance job to fail.
What can I do to make the maintenance job run successfully, size of the tempdb database is only 50GB and recovery model is set to simple. It cannot be increased as the mount point on which it is residing is 50GB.
View 3 Replies
View Related
Sep 1, 2006
If I start a long running query running on a background thread is there a way to abort the query so that it does not continue running on SQL server?
The query would be running on SQL Server 2005 from a Windows form application using the Background worker component. So the query would have been started from the background workers DoWork event using ado.net. If the user clicks an abort button in the UI I would want the query to die so that it does not continue to use sql server resources.
Is there a way to do this?
Thanks
View 1 Replies
View Related
Mar 14, 2008
One of my stored procs, taking one parameter, is running about 2+ minutes. But if I run the same script in the stored proc with the same parameter hardcoded, the query only runs in a couple of seconds. The execution plans are different as well. Any reason why this could happen? TIA.
View 6 Replies
View Related
May 16, 2007
Hello Reporting Services 2005 users or Reporting Services Team,
I have done everything to get pass this error but no luck.
My setup is :- WIndows 2003 Standared Edition SP1
Sql Server :-
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Reporting Services starting SKU: Standard.
From the Reporting Services Configuration Manager:
I can see all other things configured except Encryption Keys(blue sign)
Initialization(Grey sign) and Execution Acct(Yellow sign)
My windows Service Identity is using :
NT AuthorityNetworkService
Builtin Acct :NetworkService
Web Service Identity :-
ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran
http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know.
I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup :
Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:-
w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
View 8 Replies
View Related
Jun 30, 2005
I have a post similar to this is the Getting Started thread but haven't had any responses so I'm going to ask an updated version of my question. What I need to do is run a job after a user clicks a button in my ASP page. I know I can use oDBConnection.pStoredProc to run a stored procedure, but is there a similar command I can use to run the job? Any help will be appreciated. ThanksTim ConlanIntern
View 4 Replies
View Related
May 21, 2001
I want to be able to run a DTS package when a user clicks a button on a web page. The way I thought this could be done is by having a stored procedure linked to a web button which will run the DTS. This now does not appear possible (either that or I dont know how to set up an sp).
Does anyone know how to do this or another way of running DTS from a web page.
Many Thanks
View 1 Replies
View Related
Nov 10, 2000
I am running a set of steps from within a SQL Server Job. The very last step is to execute a Visual FoxPro EXE. I am using something like:
'D:My DirectorySubDirmyapplication.exe'
as the last step of the job (replace single-quotes with double-quotes in the line above). The job, upon reaching this step, does not continue any further. It does not report a failure, but the EXE does not execute. I have to manually stop the job. I am writing to a status.txt from within the VFP EXE to see how far it has progressed, but the EXE does not even reach line 1.
I replaced the exe with a system command (like dir > status.txt) and that works. Is there some sort of problem with VFP apps and SQL Server?
Thank you.
Aristotle
View 5 Replies
View Related
Nov 8, 2000
I am running a set of steps from within a SQL Server Job. The very last step is to execute a VFP EXE. I am using something like:
'D:My DirectorySubDirmyapplication.exe'
as the last step of the job (replace single-quotes with double-quotes in the line above). The job, upon reaching this step, does not continue any further. It does not report a failure, but the EXE does not execute. I have to manually stop the job. I am writing to a status.txt from within the VFP EXE to see how far it has progressed, but the EXE does not even reach line 1.
I replaced the exe with a system command (like dir > status.txt) and that works. Is there some sort of problem with VFP apps and SQL Server?
Thank you.
Aristotle
View 4 Replies
View Related
Jan 30, 2002
I have the following code which successfully runs a DTS package in SQLServer v7. However when it is run against a DTS package in SQLServer2000 nothing happens. It appears to run & there are no error message but it has done nothing. The DTS package works fine when executed on its own.
Set dts_pkg = Server.CreateObject("DTS.Package")
dts_pkg.LoadFromSQLServer strServer, strUser, strPass, , , , , strDTSName
dts_pkg.Execute
Set dts_pkg = Nothing
Help much appreciated.
Thanks
Adrian
View 1 Replies
View Related
Nov 15, 2007
Dear Experts,
I have 3 tables:
"Dim_Date"
Date_ID
MonthNumber (Month nr... ex. jan=1)
Year (ex. Year=2007)
Year&Month (Contains both year and name of month... ex. "2007 - July")
Lets say it looks like this:
Date_ID YearAndMonth Year Month
1 "2007 - Jan" 2007 1
2 "2007 - Feb" 2007 2
3 "2007 - Feb" 2007 2
4 "2007 - Mar" 2007 3
5 "2007 - Apr" 2007 4
6 "2007 - Jan" 2007 1
7 "2007 - Jan" 2007 1
"Customer"
Customer_ID
CustomerNumber (Contains a customernr... ex. "08243")
CustomerName (Contains the Customers name... ex. "Barneys Carwash")
Could be like this:
Customer_ID CustomerNumber CustomerName
33 08243 Barneys Carwash
65 14952 Henrys Hats
"Customer_Entry"
Entry_Date_ID
Customer_ID
OriginalAmount (Contains the amount)
What I am looking for is to get the running sum (OriginalAmount) for each month...
lets say the "Customer_Entry" tables contains the following:
Entry_Date_ID Customer_ID OriginalAmount
1 33 150
2 33 100
2 33 50
3 33 200
4 33 300
4 33 200
6 65 120
6 65 140
7 65 170
Then my goal is to get the following output, for a customer with a certain CustomerNumber (not ID):
CustomerName Year&Month RunningSum
Barneys Carwash 2007 - Jan 150
Barneys Carwash 2007 - Feb 300 (150 + 100 + 50)
Barneys Carwash 2007 - Mar 500 (150 + 100 + 50 + 200)
Barneys Carwash 2007 - Apr 1000 (150 + 100 + 50 + 200 + 300 + 200)
When I did my own attemps I was using a subquery. But I keep getting dobble posts because there are more than 1 amount for 1 Entry_Date_ID.
I hope one of you can come up with a solution?
Regards Mzane
View 2 Replies
View Related
May 22, 2007
I'm trying to run a VB.NET exe from a dts.
This works when I run the DTS manually but just hangs when I schedule the DTS.
Has anyone seen this before ?
View 3 Replies
View Related
Mar 2, 2004
Hi.
How to check if the dts currently running or not
please help
View 1 Replies
View Related
May 6, 2008
How can i fix a job to run with particular account
Thanks,
ServerTeam
View 6 Replies
View Related
Jan 8, 2007
Hi
In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%
For the Row % under total i write like this:
=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)
For the *** % under cumulative total the expression is:
=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")
But i am getting this error:
The Value expression for the textbox '*** %' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.
How to get the cm % for the Cumulative total
Please help me
Thanks in advance
View 1 Replies
View Related
Jul 20, 2005
Is anyone doing this successfully? Were there any problems getting up andrunning? Any software patches needing to be downloaded to make this happen?We have been using Access. I know, it's cheesy, but for the simplistic datamodel we've used up until now it worked. However, we've outgrown the simpledata model and now need more full-fledged queries and stored procs).I have an old copy of SQL Server 7.0 laying around but wanted to get somefeedback from folks who have been using it with XP Pro before installing andgetting into a bunch of potential headaches. Any feedback concerning thisboth welcomed and appeciated in advance.Cheers!
View 1 Replies
View Related
Jan 8, 2007
Hi
In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%
For the Row % under total i write like this:
=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)
For the *** % under cumulative total the "AgeByGender")
But i am getting this error:
The Value
View 4 Replies
View Related
Jan 2, 2007
Hi
In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%
For the Row % under total i write like this:
=Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)
For the *** % under cumulative total the expression is:
=RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")
But i am getting this error:
The Value expression for the textbox '*** %' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.
How to get the cm % for the Cumulative total
Please help me
Thanks in advance
View 29 Replies
View Related
Feb 7, 2006
In configuration manager, the parameter "running under 64-bit os" is grayed out on my sql services.
How can you change this? Where does it get set? At install?
View 9 Replies
View Related
Feb 24, 2007
Hi everybody,
I developed mobile programs for WM5.0 with C#.NET using SQL Mobile. (Visual Studio 2005, SQL Server 2005 Mobile, Mobile SDK)
But I couldn't run SQL CE on WinCE 4.2 ? (Visual Studio 2003, SQL Server 2000 CE). For example on emulator, an Insert command is running successfully. But on device (Intermec CK 31) we are getting error.
Here is my code :
using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlServerCe;
namespace UmurBS.Forms.BasimSayimForms
{
public class bsEkleForm : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dg;
private System.Windows.Forms.Button button1;
private System.Data.SqlServerCe.SqlCeConnection sqlceconn;
private string connstr = "DATA SOURCE = UmurDB.sdf";
public bsEkleForm()
{
InitializeComponent();
}
protected override void Dispose( bool disposing )
{
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.button1 = new System.Windows.Forms.Button();
this.dg = new System.Windows.Forms.DataGrid();
//
// button1
//
this.button1.Location = new System.Drawing.Point(160, 264);
this.button1.Text = "button1";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// dg
//
this.dg.Location = new System.Drawing.Point(8, 8);
this.dg.Size = new System.Drawing.Size(224, 200);
this.dg.Text = "dg";
//
// bsEkleForm
//
this.ClientSize = new System.Drawing.Size(237, 291);
this.Controls.Add(this.dg);
this.Controls.Add(this.button1);
this.Text = "bsEkleForm";
}
#endregion
private void button1_Click(object sender, System.EventArgs e)
{
sqlceconn = new System.Data.SqlServerCe.SqlCeConnection(connstr);
this.ekle();
}
private void ekle()
{
try
{
SqlCeCommand cmd = new SqlCeCommand("insert into test (testValue) values ('hi world')", sqlceconn);
sqlceconn.Open();
int rowsaffected = cmd.ExecuteNonQuery();
}
catch(Exception exc)
{
MessageBox.Show(exc.Message);
}
finally
{
if (sqlceconn != null)
if (sqlceconn.State == ConnectionState.Open)
sqlceconn.Close();
}
}
}
}
Any idea ?
Regards
Serkan
View 6 Replies
View Related
Jul 13, 2006
How does one run an sql script against a database then using sql management express.
I have the script and i connect to the correct database using the sql management express and execute the script. It even says that it completed successfully. But when i check the database there is nothing new added.
Is it somthing to do with the community preview version of sql management express??
thanks for any help
View 1 Replies
View Related
Sep 25, 2006
In SQL 2000, go to Management, than Jobs, you will see a list of all jobs and their running status. I would like to programmatically display the same on my web page. I can call sysjobs table to get the jobs and use sysjobschedules to determine whether it's been scheduled or not. Then use sysjobhistory to obtain their running history. But how and where do I get the Next Run Date information? Is this calculated or stored somewhere?Can anyone give me some help on how to work with sysjobs, sysjobschedules, and sysjobhistory tables? All I am trying to do is to build a web-based app that does the same thing as the Enterprise Manager is doing - create and schedule a job, and monitor the job status.Thanks a lot!Penn
View 1 Replies
View Related
Dec 2, 2006
We are using SQL2000. User insert table in one database DB1 and trigger insert the record into another database DB2. In this scenario, is it possible have a trigger in DB1 to execute a stored procedure in DB2 with a different user?
View 1 Replies
View Related
Sep 12, 2007
I'm getting an error when I try to import a flat file package from SQL, when I created it on Visual Studios it runned fine.
I'm getting this error on SQL when I try to run the job:
Executed as user: MAINOFFICEASPNET. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:30:01 PM Error: 2007-09-11 23:30:06.56 Code: 0xC001401E Source: Import_GasBoyData Connection manager "RawTrans" Description: The file name "\Mt111gasboyPC TopKATFiles
awtrans.dat" specified in the connection was not valid. End Error Error: 2007-09-11 23:30:06.56 Code: 0xC001401D Source: Import_GasBoyData Description: Connection "RawTrans" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:30:01 PM Finished: 11:30:07 PM Elapsed: 6.063 seconds. The package execution failed. The step failed.
Thanks,
Erick
View 2 Replies
View Related
Mar 5, 2004
how can i run a .sql script from my asp.net project?
thanks,
jb
View 3 Replies
View Related
Sep 9, 2005
I have many, many T-SQL scripts that create stored procedures and gives proper permissions. (uploading to production)I've been looking around for a way to run them all at once with a single script to pull them into the sql analyzer.Not copying and pasting them all, there are too many, but reading and executing.Anyone know a link with a sample to do this?Thanks,Zath
View 3 Replies
View Related
Sep 11, 2005
i am creating a few dynamic tables and views , is there a way to execute a .sql file from asp.net (vb.net) ?
View 2 Replies
View Related
Sep 12, 2005
Can anyone point me to some sample code ord give me an example. I'm trying to run a DTS package from my asp.net/vb.net application. I don't need to pass it any variable, just need it to run. I can't seem to find anything on the net for this. Thanks in advance, Ryan
View 7 Replies
View Related
Oct 18, 2005
Hi, I'm building a portal for supervisors can view their agents errors. We have a team that have been using Access to import data and QC it. I want to get these records into SQL but at the same time, the agents need to import their own work. I've create a DTS package that will import the data into the SQL table from a folder the agents have access to. I tried to create the strored proc to be run from the ASP page however it's not working and I'm having a hard time figuring out why. Here is the procCREATE PROCEDURE DTS
AS
exec master..xp_cmdshell 'dtsrun /KEMTSQL02 /ADJUSTMENTS /E'GODoes anyone know what I'm doing wrong? Any help would be great. Thanks!
View 1 Replies
View Related
Jul 11, 2001
Current system 2 x 500mhz pIII 512MB ram, System mirrored and data raid 5 30GB made from 3 disks. All server is running in CA TNG. an Asset management DB and Software Delivery database. But the poor server runns most of the time at 100% 65% being used by SqlServer process. Does/Can anyone recommend any tweaks upgrades that may let the server take a breath in and out ie will more memory speed thing up faster processors or more disk.
Thanks
Nigel
View 4 Replies
View Related
Aug 8, 2000
I have a dts job set up to transfer 550,000 records from a dbf file into a sql server. If I just let it run, there is a 9-10 minute delay, then it starts. If I try to schedule a job, it fails completely. I looked up ways to get it to execute quicker, mainly going to the advanced tab of the transform arrow and making the inserts 1000 at a time, the table locked, turning constraints off. Any advice on how to speed it up or why the job is failing?
View 7 Replies
View Related
May 24, 2000
Hi,
I'm using SQL SERVER 7.0. I'm wondering if it is possible to start a job with TSQL from within Query Analyzer?
Thanks,
Darrin Wilkinson
View 1 Replies
View Related
Apr 3, 2000
Hi,
I have just upgraded my sql 65 to sql 7. The problem I am running into is running out of locks all the time with 50000 locks. The sql box has 4 pentium pro 200 processors and 1 Gig of ram. Here is the error message:
DESCRIPTION:Error: 1204, Severity: 19, State: 1
SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure SQL Server with more LOCKS.
COMMENT:Fatal Error Occured in Resource
Help!!!
Jim
View 3 Replies
View Related
