Kicking Off A Scheduled Report Immediately In An Ad Hoc Manner...

Mar 20, 2008

We have a number of scheduled reports in our system. But frequently, I
need to kick off one or more of them immediately at random times - to
run off schedule, so to speak. The only way I know to do this is to
actually modify the schedule to set it to run "Once", set the time to
run to be a minute or so into the future, then wait for the report to
run. Afterwards, I go back into the scheduler and re-establish the
original schedule.



Do you know of a way to do this without having to modify and disturb
the original schedule?

Thanks,

Behzad

View 3 Replies


ADVERTISEMENT

Scheduled Report By Email With Attached Report Fails

May 18, 2006

Can anyone offer any help with this?

Error maesage:
Status:
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files

Windows 200 Server: SP4
RS 2000: SP2
SQL Server 2000, on the same server as RS.

We
get this error whenever we try to run a report with the report
attached. However, the email sends fine if the report is not attached.

Reports can also be exported into different formats without problem when viewing the report through report manager.

View 6 Replies View Related

Kicking People Out Of A Database 4 No Activity

Feb 12, 2007

Is there a way to kick users out of your databases if there's no activity for a certain duration of time. For example, I have a database thats being shared by 5 people. One went to lunch and locked their office just when I needed to do maintanence. I had to wait for them to get back & logout be fore I could do anything?

View 1 Replies View Related

Kicking Off Replication Agents With Script

Oct 28, 2005

Hi all,

I have 5 laptops, 1 laptop with SQL Server 2000 and the other 4 with SQL Server MSDE Rel A. I had a "Merge Replication" scheme that I had to set up. The laptop with 2000 will be the main Publisher/distributor and publishes/merges to two of the MSDE laptops(these laptops have pull subscriptions that pull from the 2000 laptop). These 2 MSDE laptops in turn Re-publish their data to the last 2 laptops and my scheme ends there. I have succesfully been able to Script this entire "Merge Replication" scheme, and I ran it. It creates all Components needed for my scheme to work.

1 issue though. It doesnt kick start the agents :eek: , so the replication scheme is just dormant.

Does anyone have any examples of scripts that I could use to kick off all the agents (snapshot,merge agents etc) and maybe to stop them too. I seriously need this, because we will need to have the entire process scripted.

Thanks

'Wale

p.s.
Also does anyone have sample scripts to alter settings for the SQL SERVER AGENT, for example altering its "Log On" parameter to allow a particular user with Admin privileges and also to switch its start mode to "Automatic"

View 1 Replies View Related

Kicking SSIS Package Off Using C# Program

Feb 28, 2008

Hello,

I was wondering if it was possible to execute a package using a C# program. Can I use dtexec? How does this work?

Thanks.

View 12 Replies View Related

Scheduled Report For Database Names And Sizes

Jul 20, 2005

Does anyone has a script which gives all databases names and thereallocated, used sizes in SQLserver2k. I want to schedule this to create adaily report.Thanks,Nasir

View 1 Replies View Related

Do Nto Send Scheduled Report When No Data Is Present

Jan 2, 2007

Dear Friends:

Could somebody please help me to stop sending scheduled report when no data is present in the report? Actually I have a daily report which is sent to the client and in a week, two or three days, data will not be there and thus it delivers blank report to the client.

So how can I stop sending blank mails to the client?

Thanks in Advance

Emmanuel Mathew

View 1 Replies View Related

Disabling Scheduled Report Delivery Conditionally?

Sep 16, 2007

Hi,

I am currently planning on using Reporting Services for delivery of reports, some of which in turn are reliant on an import from FTP via SSIS.

In the event that the FTP fails I would like the delivery of just the dependant reports to be cancelled for just that day.

Any advice on the best way of achieving this?

Cheers,

Martin

View 3 Replies View Related

PerformUpgrade Failed - In What Manner?

Aug 14, 2007

I'm in the midst both of developing and using a custom Transformation. Of course, every time I change the assembly version and reopen Visual Studio, I get the error:


DTS.Pipeline: The component metadata for "component "Map SERVICE_CERT String Locale" (195692)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

Out of curiosity, I'm wondering, how did it fail? Did it throw an exception? Was it even called? Is it my PerformUpgrade override that is being referred to, or perhaps the base class version?

I've seen several of the threads on this topic in this forum, but they haven't completely solved the problem (I will take the step of creating a policy assembly later today, and maybe that's the problem).

But, is there a reference somewhere to exactly what's going on at package load time as far as loading custom components? I'd love to know which methods are called, in which order, and how SSIS decides which version of the component to load.

I'd also love to see some best practices for component development. For instance, maybe I shouldn't allow the assembly version to change during development? Do I need to remove and re-add the component from the toolbox, and does that affect components already in the package?

Sorry to ask questions I'd no doubt answer for myself within a few months, but this project is due at the end of this month!

View 7 Replies View Related

Date Is Not Getting Saved In Propper Manner

Mar 23, 2006

hi friends
In my form i am storing system's date in the database.
4 that i m using a variable of date like:
dim today as new date
today=now.date
 
but its storing the default date that is '1/1/1900'
how to overcome this problem?

View 2 Replies View Related

Exporting Data In A Monthly Manner By DTS

May 27, 2002

I am looking for a script whichs exports data (by DTS?) into a flat file and store the files (according their date stamp in the transactions) with a name like 05_2002.txt, 06_2002.txt etc. The data in the table Transactions will be deleted after some time to prevent fast growing of this particular table.

Any idea?

Thanks

Mike

View 1 Replies View Related

Log File Growing In Amazing Manner

Sep 28, 2004

I started my database in last week to user with transfer data from Sybase to sql 2000 server. Intitally log file size was few MB near to 20 MB for each co’s, within 8 days it has reached upto 300 MB still datafile size in few MB , approximately 40MB for each co’s, why log file growing in such manger, how I can manage it?

Thanking You

R.Mall

View 2 Replies View Related

Exporting Scheduled Report In Excel Format Via SSRS Subscription

Oct 1, 2014

I am currently exporting scheduled report in excel format via SSRS subscription and the report is getting deposited in 97-2003 (.xls)format. I am using SQL Server 2008 R2 version

Now i need to export the report in .XLSX format. What i need todo to upgrade the exporting excel version (i.e .XLS to .XLSX format ) as .XLXS version is only available from Excel 2007 and later version.

View 2 Replies View Related

Merge Replication Deployments - How Do You Do It In A Timely Manner?

May 22, 2008

Our current production deployments using merge replication are averaging 4-5 hours - all of which is downtime for our client sites. Hotfix releases require no downtime, I am talking about maintenance releases where articles are changed/added/removed requiring a full snapshot to be taken.Management is not happy about this deployment window lasting so long.I have two questions:1) Our first suggestion is to do a proof of concept of leaving the sites up while the snapshot is being generated and only briefly bringing them down as the snapshot is applied as leaving them down while we smoke test the new application + DB code. Is this easily accomplished of making SQL Server disconnect the taking of the snapshot with the application so we can time this appropriately?2) Our snapshots take ~45minutes and we have 3 snapshots that are typically required. We currently run these serially.A) Is there a way to take/apply these snapshots in parallel?B) We have a SAN on production and have the capability to do SAN replication. I am not too familiar with SAN replication, but can that somehow be used to make these snapshots run in minutes rather then closer to an hour?Any links/references that are informative for dealing with merge replication deployment best practices would be much appreciated as well.Thanks!-John

View 10 Replies View Related

Reporting Services :: Daily / Weekly / Monthly And Yearly Parameter For Scheduled SSRS Report

Jan 7, 2011

Currently, I have a report that takes two parameters:  StartDate and EndDate.  

I would like to schedule the report to run on a Daily, Weekly, Monthly or Yearly basis, but this doesn't work too well with StartDate and EndDate because the parameter is static.  What is the most elegant way to implement this change?

View 5 Replies View Related

Transact SQL :: Merge Two Tables Data On Behalf Of ID In Comma Separated Manner?

Jul 2, 2015

Picture tells all what i need. Anyway i want to combine upper two tables data like below result sets. Means they should be grouped by bsns_id and its description should be comma separated taken from 2nd table. In sql server 2012 ....

View 5 Replies View Related

SQL Server 2012 :: How To Merge Two Tables Data On Behalf Of ID In Comma Separated Manner

Jul 2, 2015

i want to combine upper two tables data like below result sets. Means they should be grouped by bsns_id and its description should be comma separated taken from 2nd table. In sql server 2012.

This is the image path :

[URL]

View 3 Replies View Related

Please Help Immediately...

Feb 21, 2007

Hello everyone...
plzz help me,im getting this error whenever i want to connect my pc with another remote pc which i've designated as Server and my database is saved there so i want to connect my pc with tht remote pc and save data entered by my pc to that remote pc's database...
but i get this error....PLEASE HELP IMMEDIATELY...





Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

----------------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

----------------------------------------
Error Number: -2
Severity: 11
State: 0


----------------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

View 3 Replies View Related

Hi, I Need Ur Urgent Help Immediately(!!!!)

Aug 24, 2006

i have a sql data table which icludes names and surnames
as like as that:
george read
hasan hujtr
deem greg
ade ad
edy es
---------------
i need a "select" query to receive only people whom surnames composed merely two letters(ade ad, edy es).
thanks,
best regards.

View 5 Replies View Related

SQL Connection Not Terminated Immediately

Aug 16, 2006

Hi,
    I have a web application that connects to a SQL server 2000. My problem is when my application accesses the SQL server to retrive data it creates a new connection to the SQL server. So during the running of the application there would be multiple connection of my application to the SQL server. Is there a way that i can close the connection after each query.
 
Thank you.
 

View 3 Replies View Related

How To ID When I Have Insert The New Record Immediately

Jan 29, 2006

hi all,i have a question that how to get id afer insert  a new record.i just read from the following article, but still can't get the meaning:http://forums.asp.net/1008337/ShowPost.aspx
and my code             Dim sql_3 As String            sql_3 = "insert into paper_type (name, enable,creation_date,lastupdate,user_id) values "            sql_3 += "('" & name & "','" & enable & "', getdate() ,getdate ," & user_id & ")"            Call OpenRs(sql_3)            ' I want to get the id immediately, but how?? (i am using sql server)   can somebody help me to solve the problem??thanks a lot

View 9 Replies View Related

Client Configurations----immediately

Aug 2, 2000

Hi ,
I am configuring odbc connection at my users place, i tried to change his client configuration , but it is not going in. What was the problem why it is not going in.pls suggest me.
i am having sql7.
--chowdary

View 4 Replies View Related

How To Retrieve Rows Which Immediately After A ID

May 26, 2008

Hello..

Can any one you help me in retrieving the rows which immediately after a ID 9.
i.e, My condition is to retrieve the Record which immediately follows the event 9.
The retrieved record event should be in (24,25,26)

Table structure is
---------------------------------------------
MatchID SegmentID Event Player1 Player1ClubID
---------------------------------------------
1 0 9 1 88
1 0 24 1 89
1 0 10 1 88
1 0 9 1 89
1 0 25 1 88
1 0 10 1 88
1 0 10 1 89
1 0 10 1 89
----------------------------------------------

My out put should have
---------------------------------------------
MatchID SegmentID Event Player1 Player1ClubID
---------------------------------------------
1 0 24 1 89
1 0 25 1 88
---------------------------------------------

How to get this,
Can any one help me.

Thanks
Ganesh

Solutions are easy. Understanding the problem, now, that's the hard part

View 5 Replies View Related

Install SP1 Immediately After RTM Might Fail ... ?

Jun 28, 2006

Hi all,

maybe this is not a new issue? anyway:

Installing SP1 straight after the RTM (no delay between the finish of RTM install and start of SP1 install) might fail. This happened to me on an install of Analysis services install, but I guess it could happen on any install. I think in this case the reason is that the .NET Optimizer service is still busy generiting the native images of the assemblies and the SP1 install finds them locked.After a while, if you don't keep pushing the "Try Again" button you get an error message prompting to send the error report to MS (I got that twice), however in the background the installer continues. At the end the hotfix installation complete window states "Failure" for some components but the summary log contains "Not applied" (??).

If you let the optimizer finish its job then there is no issue...

Wonder how it works with silent install?

View 1 Replies View Related

Add A New Column In Temp Table In Sp Cannot Be Used Immediately

Jun 18, 2007

I created a temp table in my stored procedure and then added a new identity column to it.
However, I am not able to use this new column immediately, it says column not found.
SELECT * INTO #temp FROM table_name
ALTER TABLE #temp ADD  __Identity int IDENTITY(1,1)
SELECT * FROM #temp WHERE __Identity >= 10
Here __Identity column is not found. If I just did SELECT * FROM #temp without the where clause, the final result does have the __Identity column correctly added to the table. Why can't I query it?
Thanks!
 

View 4 Replies View Related

SQL Agent Job Fails Immediately After Invoked

Jul 23, 2005

Hey everyone --I've been having this problem for a couple weeks and was hoping maybesomeone can help out a little bit.Synopsis:This SQL agent job contains code to perform a full database backup withverification and is writing to a local disk array. I typically also usesome code for reporting - declaring variables and inserting them intoa linked server database that I use to monitor all my database backups.I have tested and used the code repeatedly and am confident it works.I have ran the code through Query Analyzer and it completes withsuccess.I have removed reporting code & used only the backup statement & itfails.I have 4 other Agent jobs doing other various tasks that function asexpected.I have tried deleting & recreating the job & it still fails.When I enable logging the application log has only one entry for SQLAgent:Event Type:WarningEvent Source:SQLSERVERAGENTEvent Category:Job EngineEvent ID:208Date:1/4/2005Time:9:36:00 AMUser:N/AComputer:ComputerNameDescription:SQL Server Scheduled Job 'DBName Full DB Backup'(0xA4B14FB5A5DE964B8340423E4AC4B67B) - Status: Failed - Invoked on:2005-01-04 09:36:00 - Message: The job failed. The Job was invoked byUser domainUserName. The last step to run was step 1 (Step 1).Any help or ideas would be greatly appreciated. I'm racking my brainhere and for some reason just not able to think of what the problem is.ChaddJoin Bytes!

View 9 Replies View Related

SQLServer 2000 SP4 Enterprise Manager Crashes Immediately...

Jun 6, 2006

Hello,I need some help with SQL Server 2000 SP4. I've been using thedeveloper product for a few years now on my PC with very few problems.Today when I try to start up Enterprise Manager, it crashesimmediately. I get the usual "Please tell Microsoft about this problem"dialog and if I click the 'click here' link, I'm presented with adialog that says:-------------------------------------------------Error signatureAppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exeModVer: 5.1.2600.2180 Offset:0001f07eReporting detailsThis error report includes: blah, blah, blah...-------------------------------------------------I am running Windows XP with SP2. Also installed is Visual Studio 2003,Visual Studio 2005, and SQLServer 2005 (We're in the process ofmigration).All of these products have been running OK together for at least amonth until today. I'm not sure what changed, but obviously somethinghas. I tried uninstalling and reinstalling SQLServer 2000 & it's SP4,but no luck. Enterprise Manager still crashes immediately when I try tolaunch it.Could somebody please help me out?Thanks.

View 1 Replies View Related

How To Extract Auto-generated Int Identity PK Field Value Immediately After It's Made ?

Sep 12, 2007

Ok, let's say that I do a following inline INSERT statement..... 
INSERT INTO Car ( carMake, carModel ) VALUES ( 'Honda', 'S2000' )
When I do this, a carId int value will automatically be generated because it is the Car table's PK and is an int identity.  How do I obtain this value so I can immediately use it in let's say, the following example.
INSERT INTO Person ( carId ) VALUES ( @carId ) ..... where @carId is the value I need
Maybe you would say I should do something like.....
SELECT carId FROM Car WHERE carMake = 'Honda' AND carModel = 'S2000'
However, let's assume that the carMake and the carModel fields are NOT unique.  I'm sure there's an easy way to extract the new identity value (maybe even in the same query) as the INSERT, but I just don't know how.
Thanks.

View 10 Replies View Related

Merge Replication Downloading Rows Immediately After Uploading SQL 2005

Jan 9, 2007

Hi

I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update.

If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates.

Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this.

Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server
Subscriber: SQL Express 2005 SP1 on Win XP SP2

Cheers
Rab

View 5 Replies View Related

Error Immediately On Creating New Integration Services Project In VS2005

Aug 15, 2007

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:



<?xml version="1.0"?><DTS:Executable xmlnsTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSroperty
DTS:Name="PackageFormatVersion">2</DTSroperty><DTSroperty
DTS:Name="VersionComments"></DTSroperty><DTSroperty
DTS:Name="CreatorName">BNHO1mbell</DTSroperty><DTSroperty
DTS:Name="CreatorComputerName">BT4WKS1361</DTSroperty><DTSroperty
DTS:Name="CreationDate" DTSataType="7">8/14/2007 12:22:35 PM</
DTSroperty><DTSroperty DTS:Name="PackageType">5</
DTSroperty><DTSroperty DTS:Name="ProtectionLevel">1</
DTSroperty><DTSroperty DTS:Name="MaxConcurrentExecutables">-1</
DTSroperty><DTSroperty DTS:Name="PackagePriorityClass">0</
DTSroperty><DTSroperty DTS:Name="VersionMajor">1</
DTSroperty><DTSroperty DTS:Name="VersionMinor">0</
DTSroperty><DTSroperty DTS:Name="VersionBuild">0</
DTSroperty><DTSroperty
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTSroperty><DTSroperty DTS:Name="EnableConfig">0</
DTSroperty><DTSroperty DTS:Name="CheckpointFileName"></
DTSroperty><DTSroperty DTS:Name="SaveCheckpoints">0</
DTSroperty><DTSroperty DTS:Name="CheckpointUsage">0</
DTSroperty><DTSroperty DTS:Name="SuppressConfigurationWarnings">0</
DTSroperty><DTSroperty DTS:Name="ForceExecValue">0</
DTSroperty><DTSroperty DTS:Name="ExecValue" DTSataType="3">0</
DTSroperty><DTSroperty DTS:Name="ForceExecutionResult">-1</
DTSroperty><DTSroperty DTS:Name="Disabled">0</
DTSroperty><DTSroperty DTS:Name="FailPackageOnFailure">0</
DTSroperty><DTSroperty DTS:Name="FailParentOnFailure">0</
DTSroperty><DTSroperty DTS:Name="MaxErrorCount">1</
DTSroperty><DTSroperty DTS:Name="ISOLevel">1048576</
DTSroperty><DTSroperty DTS:Name="LocaleID">4105</
DTSroperty><DTSroperty DTS:Name="TransactionOption">1</
DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty>
<DTS:LoggingOptions><DTSroperty DTS:Name="LoggingMode">0</
DTSroperty><DTSroperty DTS:Name="FilterKind">1</
DTSroperty><DTSroperty DTS:Name="EventFilter" DTSataType="8"></
DTSroperty></DTS:LoggingOptions><DTSroperty
DTS:Name="ObjectName">Package</DTSroperty><DTSroperty
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTSroperty><DTSroperty DTS:Name="Description"></
DTSroperty><DTSroperty DTS:Name="CreationName">MSDTS.Package.1</
DTSroperty><DTSroperty DTS:Name="DisableEventHandlers">0</
DTSroperty></DTS:Executable>





I have VS2005 SP1, running WindowsXP SP2. Integration Services is
running on my machine, but I would think that this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use. If I take this xml file with the error and copy it to another new SSIS project on another machine, it works fine. Reinstalling VS2005 had no effect. I am now reinstalling SQL Server 2005 SP2 to see what effect that may have.





Any ideas?
Thanks,
Marcus

View 5 Replies View Related

Update On Machine Runs Immediately, Update On Linked Server Takes 8 Minutes

Jan 2, 2008

What's up with this?

This takes like 0 secs to complete:

update xxx_TableName_xxx
set d_50 = 'DE',modify_timestamp = getdate(),modified_by = 1159

where enc_id in

('C24E6640-D2CC-45C6-8C74-74F6466FA262',

'762E6B26-AE4A-4FDB-A6FB-77B4782566C3',

'D7FBD152-F7AE-449C-A875-C85B5F6BB462')

but From linked server this takes 8 minutes????!!!??!:

update [xxx_servername_xxxx].xxx_DatabaseName_xxx.dbo.xxx_TableName_xxx
set d_50 = 'DE',modify_timestamp = getdate(),modified_by = 1159

where enc_id in

('C24E6640-D2CC-45C6-8C74-74F6466FA262',

'762E6B26-AE4A-4FDB-A6FB-77B4782566C3',

'D7FBD152-F7AE-449C-A875-C85B5F6BB462')


What settings or whatever would cause this to take so much longer from the linked server?

Edit:
Note) Other queries from the linked server do not have this behavior. From the stored procedure where we have examined how long each query/update takes... this particular query is the culprit for the time eating. I thought it was to do specefically with this table. However as stated when a query window is opened directly onto that server the update takes no time at all.

2nd Edit:
Could it be to do with this linked server setting?
Collation Compatible
right now it is set to false? I also asked this question in a message below, but figured I should put it up here.

View 5 Replies View Related

Execute Sql Server Agent Job Task - Job Immediately Returns Success... However Agent Job Is Still Running???

Nov 30, 2006

when I run a package from a command window using dtexec, the job immediately says success.
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 3:37:41 PM
Finished: 3:37:43 PM
Elapsed: 2.719 seconds



However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.



Thanks,

Larry

View 1 Replies View Related

Leave The Connection Open Or Always Open And Close Immediately?

Jun 7, 2006

Hi there,
 
I got an approach like that:
1) Read something from DB - check the value, if true stop if false go on2) Read the second Value (another SQL Statement) - check the value etc.
Now I could open the connection at 1) and if I have to go to 2) I leave the connection open and use the same connection at 2). Is it ok to do that?
The other scenario would be opening a connection at 1), immediately close it after I read the value and open a new connection at 2).
Thanks for the input!

View 4 Replies View Related







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