Execute SQL Task !!! Urgent Help Needed

Nov 6, 2007



Hi pals,

I need small help.

I have a execute SQL task in which i have a delete statement with global params.

delete from <tname> where (strval=?) and (year=?)

both are varchar type variables.

my strval column gets a value something like "DecData1.0". But when i ran my DTS package it is ignoring this SQL statement. Might because of the special char '.' in "DecData1.0".

How to handle such situation.

I also tried by putting a single quote.
delete from <tname> where (strval='?') and (year=?)
But it is giving an error.


Any suggestions will be a great help.

Thanks in advance,
Mahi

View 12 Replies


ADVERTISEMENT

Urgent Help Needed Regarding Schedule Task

Dec 22, 1998

Hi every one,

I have a stored procedure which activates a task when ever that sp is called.
and this procedure gets out of the loop.

the task get started running.

Is there any way in Sql server that the same stored procedures should wait until the Task finishes and return a code either 1 or 0 for success or faliure of the task.

Help is greatly appericated
Jeswnath

View 1 Replies View Related

Analysis Services Execute DDL Task Help Needed

Apr 15, 2008

I have been trying to get an SSIS package to allow me to set as a variable the actual script for running an Analysis Services DDL, want to perform a restore of a cube. Our environment is different for the location for DEV/QA/ and Production, so when I schedule the task to run I want to have the script needed, really just the path to where the backup lives.

Can someone give a solid solution for this? I have not tried to store parameters in a SQL table, but it would seem this is something that can be done through a variable. I have created a package variable and set the value inside and it runs, but if I try to change the value when I run the package it does not set the value I want.

Under Set Values of the package when I go to run I set the following:


Package.Variables[User::RestoreScript].Properties[Value]
I get a warning saying: "Warning: Configuration from a parent variable 'RestoreScript' did not occur because there was no parent variable collection.


I also have another variable to set, but same issue.

View 3 Replies View Related

Send Mail Task Problem Using A Combination Of ForEach Loop, Recordset Destination, Execute SQL Task And Script Task

Jun 21, 2007

OK. I give up and need help. Hopefully it's something minor ...



I have a dataflow which returns email addresses to a recordset.

I pass this recordset into a ForEachLoop configuring the enumerator as (Foreach ADO Enumerator). I also map the email address as a variable with index 0.



I then have a Execute SQL task which receives this email address as a varchar variable (parameter 0) which I then use in my SQL command to limit the rows returned. I have commented out the where clause and returned all rows regardless of email address to try to troubleshoot this problem. In either event, I then use a resultset to store the query result of type object and result name 0.



I then pass this resultset into a script variable to start parsing the sql rows returned as type object. ( I assume this is the correct way to do this from other prior posts ...).



The script appears to throw an exception at the following line. I assume it's because I'm either not passing in the values properly or the query doesn't return anything. However, I am certain the query works as it executes just fine at the command prompt.



Try

ds = CType(Dts.Variables("VP_EMAIL_RESULTS_RS").Value, DataSet)



My intent is to email the query results to each email address with the following type of data by passing the parsed data from the script to a send mail task. Email works fine and sends out messages but the content is empty. I pass the parsed data as string values to the messagesource and define the messagesourcetype as a variable in the mail task.



part number leadtime

x 5

y 9

....



Does anyone have any idea what I might be doing wrong?

thanks

John

View 5 Replies View Related

Help! The Transaction Log Is Full Error In SSIS Execute SQL Task When I Execute A DELETE SQL Query

Dec 6, 2006

Dear all:

I had got the below error when I execute a DELETE SQL query in SSIS Execute SQL Task :

Error: 0xC002F210 at DelAFKO, Execute SQL Task: Executing the query "DELETE FROM [CQMS_SAP].[dbo].[AFKO]" failed with the following error: "The transaction log for database 'CQMS_SAP' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


But my disk has large as more than 6 GB space, and I query the log_reuse_wait_desc column in sys.databases which return value as "NOTHING".

So this confused me, any one has any experience on this?

Many thanks,

Tomorrow

View 5 Replies View Related

Looking For A Way To Refer To A Package Variable Within Any Transact-SQL Code Included In Execute SQL Or Execute T-SQL Task

Apr 19, 2007

I'm looking for a way to refer to a package variable within any
Transact-SQL code included in either an Execute SQL or Execute T-SQL
task. If this can be done, I need to know the technique to use -
whether it's something similar to a parameter placeholder question
mark or something else.


FYI - I've been able to successfully execute Transact-SQL statements
within the Execute SQL task, so I don't think the Execute T-SQL task
is even necessary for this purpose.

View 5 Replies View Related

Integration Services :: Stored Procedure In Execute Task Fails But Task Does Not Fail

Jul 1, 2015

I'm using SSIS in Visual Studio 2012. My Execute SQL Task calls a Stored Procedure where I have a TRY-CATCH. Last week there was a problem and the CATCH was executed and logged an error to my error table, but for some reason the Execute SQL Task didn't fail. Is there a setting to make the Execute SQL Task fail when an SP encounters a failure?

View 3 Replies View Related

Compare Performance (Execute SQL Task Insert And Data Flow Task)

Mar 12, 2008



I am using SQL 2005 SSIS. I am joining several large tables and then the move result into another table in the same database.

I would like know which method is faster:


Use Execute SQL Task to insert the result set to the target table

Use the Data Flow Task to insert the result set to the target table. (Use OLE DB source to execute SQL command and then use the SQL destination)
Could you tell me why then other is slower?

Thanks.

View 7 Replies View Related

Execute SQL Task – Output Parameter On Stored Procedure Causes Task To Fail.

Dec 2, 2005

I have a SQL Task that calls a stored procedure and returns an output parameter.  The task fails with error "Value does not fall within the expected range."   The Stored Procedure is defined as follows: Create Procedure [dbo].[TestOutputParms]             @InParm INT ,             @OutParm INT OUTPUT as Set @OutParm  = @InParm + 5   The task uses an OLEDB connection and has a source type of Direct Input.  The SQL Statement is Exec TestOutputParms 7, ? output    The parameter mapping is: Variable Name Direction Data Type Parameter Name User::OutParm Output LONG @OutParm  

View 7 Replies View Related

Writing Full Result Set From Execute SQL Task Into A File Using Script Task

Mar 28, 2007

In the Control flow tab, I have an Execute SQL Task that outputs full Result set into a variable of an object type. Now how can I write the contents of the Full Result Set into a text file using Script Task. I also want to format the following way while I output into a file:

Column Name 1 : Column Value

Column Name 2: Column Value and so on

I tried writing the contents of the Object Variable into a file, but the file had an output of single word: System.__ComObject.




Code for Writing the Full Result Set into a Text File

Dim RSsqloutput as String = Dts.Variables("objVariable").Value.ToString

Dim strVal as String = "File completed on " & Now() & vbCrLf & "------------------------------------------------------" & vbCrLf

oLogFile.WriteAllText("C:MyFile.txt", strValue)

oLogFile.WriteAllText("C:MyFile.txt", rsSQLOutput)



I went through this link that explains how to write XML Result Set into a File, But this doesn't help as it writes in XML format.

Would you please give me a hint of code how I can go upon.





View 7 Replies View Related

How To Fetch The Recrods From MS Access And Using It In Script Task Using Control Flow Tools(Execute SQL Task)

Jun 14, 2006

Hi

I have an application like fetching records from the DataBase(MS Access 2000) and results i have to use in Script Task. At present i have used the record fetching query,connection string in Script itself. I would like to use in Independently. Is there any Tools like (Control Flow Tools like Execute SQL Task) are there to fetch the result set from Acccess and can use the fetching results in Script Task....

Thanks & Regards

Deepu M.I

View 5 Replies View Related

Conditional Execute By Execute SQL Task Return Value?

Jun 25, 2007

I have a SSIS package contains an "Execute SQL Task". The SQL will raise error or succeed. However, it sounds the package won't pick up the raised error?

Or is it possible to conditional run other control flow items according the the status of SQL task execution?

View 1 Replies View Related

Execute DTS 2000 Package Task. Mischievous Task??

Sep 21, 2006



Hi everyone,

For first time I'm testing this task and surprisingly, when I try "Edit Package" option:


1)The DTS host failed to load or save the package properly
2)The selected package cannot be opened
3)Error HRESULT E_FAIL has been returned from a call to a COM component

But after these messages you can see all the tasks but they haven't name!!

It seem as if RCW mechanism has failed between managed and unmanaged coded-partially.

I don't dare to follow doing more stuff, I don't know if that package is well-loaded or not from there. ?¿

Any guidance or idea about this?

View 5 Replies View Related

Why DataFlow Task Takes More To Complete Than Doing The Same In Execute SQL Task

Jun 12, 2007

An Execute SQL task takes 1 min to run a statement "insert into Mytable select * from view_using_joins"

Output: 10,225 rows affected.



But a Dataflow task configured to fetch data from the same view_using_joins into MyTable takes hours to do the same.



Could you please explain why is it so ?



Thanks

Subhash Subramanyam







View 14 Replies View Related

Urgent Help Needed

Jun 8, 2006

Hey... I really need help here.

I have a website called Project. It has 2 database files. one is ASPNETDB.mdf and another one is project.mdf.

The last time I edited my website was this afternoon. nothing wrong.
Then tonight, when I try to work on the project again, I found out that
I couldn't access the project.mdf database file. The error message
occurs when I try to expand the project.mdf:

Cannot open user default database. Login failed. Login failed for user 'DefaultAndy'

I believe Default is the name of my computer and Andy is the name for
my windows account. I use Windows authentication for that database file.

This is the funny thing. If I rename my project folder under the My
DocumentsVisual Studio 2005WebsiteProject to something else, I will
be able to open the project.mdf file.

Does anybody have any idea what is going on??

I really appreciate and thank you soooo much for your time !

View 2 Replies View Related

DTS HELP NEEDED - Urgent!!

Jul 25, 2000

I have installed SQL Server 7.0 SP2 on a couple of servers and have been
trying to get the DTS package to run. Unfortunately when I try to create
a new DTS package, I get the foll DTS Designer error:

"Could not create Component Categories Manager"

I've tried using the DTS Import/Export wizard only to keep getting a
Dr Watson error....What am I doing wrong??

Thank you in advance...

Mona

View 6 Replies View Related

Urgent Help Needed

Nov 1, 2007

Actually we have already backed up the Very large database(1.1 TB). We are trying to migrate the backup file to other server . But the copy is running really slow because of slow network banwidth. What are best options to transfer terabyte file from one server to other.
Thanks in advance

View 6 Replies View Related

Urgent Help Needed

Nov 5, 2007

I am restoring 1.2 TB on different server. Can you recommend me the best way to apply that.

View 13 Replies View Related

Urgent Help Needed !

Feb 11, 2008

Guys, I really need help with this one.
I am populating the data warehouse and have to deal with some bad sourse databases.
In one table they have 28 columns, used as flags. Each column represents a particular facility. Each record can have 0 to many facilities selected, so this table could have NULL or 'Y' in one or many of those columns. That's a terrible DB design. They should have build a 1-to-many table relationship, but instead, they put everything in one table. And the other funny thing is that those 28 columns are literally named Column1, Column2 ... Column28, and then the actual facility names are HARDCODED in their application codes !!!
So, the table might look like this:
Col1 Col2 Col3 Col4 Col5 .... Col28
--------------------------------------------------
NULL Y NULL NULL Y NULL
Y NULL NULL NULL NULL NULL
NULL Y NULL NULL NULL Y
...........
NULL Y NULL NULL Y Y

My task is to get for each record the first 4 not NULL facility NAMES. I have a script that does that, but this script is very primitive and is huge ! I kind of do 4 runs through this file. First run I get the record ID for each record, and populate the first of the 4 facility names. I am just using CASE statement and check each field if it's NOT NULL then enter the actual hardcoded name. I put all this into a #temp table. The second run I join the main table with this #temp table, again getting the record ID and the first populated Facility Column 1, and then create a Second Facility field, by using the CASE statement again, going through each field, checking for NOT NULL AND NOT being the same as the First Facility name... And so on... Like I said, this is working, but I was just wondering is there is a simpler way of doing this.

Any help or suggestion will be greatly appreciated.

Thanks,
Victor.

View 5 Replies View Related

Urgent Help Needed W/an Error

Sep 14, 2004

We run a site through asp.net (programmed in visual studio.net) and the site's beginning to get a lot of problems (as the site grows)

Here is the latest error message. I was wondering if someone could help me troubleshoot this.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: Transaction (Process ID 145) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Saltwaterfishing.Components.DB.RankResults.SearchAllSites(String query, Int32 currentPage, Int32 pageSize) in
***************ComponentsDBRankResults.cs:43
***************.Controls.RankResultsGrid.BindDataGrid() in ***************\ControlsRankResultsGrid.ascx.cs:82
***************.Controls.RankResultsGrid.ShowResults() in ***************ControlsRankResultsGrid.ascx.cs:68
***************.Main.ShowPage() in
***************\saltwaterfishingmain.aspx.cs:75
***************.Main.Page_Load(Object sender, EventArgs e) in ***************\main.aspx.cs:43
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731


Thank you

View 1 Replies View Related

Sql 2000 - URGENT HELP NEEDED

Apr 5, 2001

What is the process for using sp_attach_db to restore a sql server 2000 database as a sql server 7 database? Article references? Thanks

View 1 Replies View Related

Urgent Query Help Needed

Apr 10, 2008

I am facing a query problem.i have 2 tables called emp-table and report-table.report table for listing report of employees.
following are criterias..

1 I want list all reports from report-table
2 But no report should have empstatus 5
3 reports need not necessary to have emp-table reference.ie emp-id reference in emp_table.
briefly saying i want all reports from report table,in which no one have empstatus 5

emp-table
empid
empname
empstatus


report-table
repid
empid
details


thanks in advance.

View 4 Replies View Related

Urgent Help Needed....pleasee Help Me

Nov 5, 2007

i need urgent help sorting out my SQl please....
i have 6 tables
Student
class
lectures
student_results
attendance

my case study says " the system should be able to record attendance of student to any class. the system shoul also be able to automatically send out a warning to any student that misses any two lectures for the first time."

can anyone help me solve this problem on SQL (oracle) please...

charles

View 6 Replies View Related

(Urgent)Help Needed With This Sproc

Dec 19, 2007



Hi,
I am trying to Implement Multi parameter... If i give NULL it works fine but if i give '7,4'
I get this error message


Msg 102, Level 15, State 1, Line 18

Incorrect syntax near '17'.

This is my sproc



Code Block
ALTER Procedure [dbo].[usp_GetOrdersByOrderDate]
@ClientId nvarchar(max)= NULL,
@StartDate datetime,
@EndDate datetime
AS
Declare @SQLTEXT as nvarchar(max)
if @ClientId is null
Begin
Select
o.[OrderId],
o.[OrderDate],
o.[CreatedByUserId],
c.LoginId,
o.[Quantity],
o.[RequiredDeliveryDate],
cp.PlanId,
cp.ClientPlanId,
cp.ClientId
FROM
[Order] o
Inner Join ClientPlan cp on o.PlanId = cp.PlanId and o.CreatedByUserId = cp.UserId
Inner Join ClientUser c on o.CreatedByUserId = c.UserId
WHERE
--cp.ClientId = @ClientId
--AND
o.OrderDate BETWEEN @StartDate AND @EndDate
ORDER BY
o.OrderId DESC
END
ELSE
BEGIN
SELECT @SQLTEXT = 'Select
o.[OrderId],
o.[OrderDate],
o.[CreatedByUserId],
c.LoginId,
o.[Quantity],
o.[RequiredDeliveryDate],
cp.PlanId,
cp.ClientPlanId,
cp.ClientId
FROM
[Order] o
Inner Join ClientPlan cp on o.PlanId = cp.PlanId and o.CreatedByUserId = cp.UserId
Inner Join ClientUser c on o.CreatedByUserId = c.UserId
WHERE
cp.ClientId in (' + @ClientId + ')
AND
o.OrderDate BETWEEN ' + Convert(varchar, @StartDate) + ' AND ' + convert(varchar, @EndDate) + '
ORDER BY
o.OrderId DESC'
execute (@SQLTEXT)
END





any help will be appreciated.
Regards
Karen

View 4 Replies View Related

(Urgent) Help Needed With This Query.

Oct 2, 2007



Hi,
I am using this stored procedure to populate a report... if the particular report value is NULL i am getting this error

Cannot read the next data row for the data sest PlanEligiReqattri. Invalid lenght parameter passed to the right function...

This is my stored procedure



Code Block
ALTER Procedure [dbo].[rpt_PlanEligiReqAttriApplied]
@PlanId int
AS
BEGIN
Declare @List varchar(255)
Set @List =' '
Select @List = @List + ', ' + PERA.Name

From PlanEligibilityReqAttriApplied PERAA
Inner Join PlanEligibilityReqAttributes PERA on PERAA.PlanEligibilityReqId = PERA.PlanEligibilityReqId
Where PlanId = @PlanId
select Right(@List, Len(@List) - 2)
--set @List = Right(@List, Len(@List) - 1)
End








any help will be appreciated.
Regards
Karen

View 3 Replies View Related

Urgent Sub Report Help Needed

Jun 23, 2006

I have an urgent need to solve this issue.

I have a report that has two sets of six sub reports. Here is what I have:

Main Report

Subreport1A
Subreport2A
Subreport3A
Subreport4A
Subreport5A
Subreport6A


Subreport1B
Subreport2B
Subreport3B
Subreport4B
Subreport5B
Subreport6B


I want to have a page break between the first set and the second set. The last subreport of the first set, Subreport6A, has a pagebreak at end =  true, so it should break. The problem is that when I export to Excel I am getting one sheet for the 12 subreports.


 

View 8 Replies View Related

(urgent)help Needed With This Error Message

Oct 25, 2007

Hi i am trying to transfer the contents of a dbf file to sql server 2005 and this is my error message
'C:Documents and SettingsKarenMy DocumentsVisual Studio 2005WebSitesASC1pdfclientAS.DBF' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
This is my code
 If (FlAS.PostedFile.FileName.ToLower.EndsWith(".dbf")) Then
FlAS.PostedFile.SaveAs(location)
Try
'Connection string to a dbase file
Dim dbfConnectionString As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source ={0};Extended Properties= dBase IV", location)

'create connection to the DBF file
Using connection As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(dbfConnectionString)
Dim command As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("Select * from AS.DBF", connection)
connection.Open()

'Create a dbDatareader to the dbf file
Using dr As Data.Common.DbDataReader = command.ExecuteReader()
Dim sqlConnectionString As String = System.Configuration.ConfigurationManager.AppSettings(APPSETTINGS_CONNECTION)
Dim myConnection As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings(APPSETTINGS_CONNECTION))
Dim query As String = "Truncate table ASDBF"
myConnection.Open()
Dim cmd As New SqlCommand(query, myConnection)
cmd.CommandType = CommandType.Text
cmd.ExecuteScalar()
myConnection.Close()

'bulk copy of sql server
Using BulkCopy As SqlBulkCopy = New SqlBulkCopy(sqlConnectionString)
BulkCopy.DestinationTableName = "ASDBF"
BulkCopy.WriteToServer(dr)
End Using
End Using
connection.Close()
End Using

Catch ex As Exception
Throw ex
End Try

End If
 Any help will be appreciated.
 
Regards
Karen

View 12 Replies View Related

(urgent) Help Needed For This Insert Statement

Nov 6, 2007

Hi,
   I am trying to insert the Source name and clientId to a table called clientSource...
 
The User will send in some Dbf File.... So in a particular file called PlanDbf.. I have the following fields
PlanNumber, Name,                   SRC1Name,           SRC2Name,                       SRC3Name....      SRC20Name
170234         Constructions         Employee Deferral   Employer Discretionary      Employer Matching....
 
And in another table called SourceDBF i have the following fields with data
PlanNumber             PARTID   SOURCE_NUM    etc...
170234              123456789         1
170234              123456789         3
170234              451231334         1
So how do i match the Source_NUM with SRCnames when i insert it into the table..
INSERT INTO Statement..ClientSource(@ClientId,                SourceName)SELECT                   s.SOURCE_NUM FROM SourceDBF ..
 but i am stuck..
any help will be appreciated.
Regards
Karen

View 7 Replies View Related

DBCC ERROR - URGENT HELP NEEDED

Jun 29, 2001

Msg 2503, Level 16, State 1
Table Corrupt: Page Linkage is not consistent; check the following pages: (Current page#=298065; page pointing to this page =286585; previous page# indicated in this page=283321).

Can somebody urgently help? Any help will be appreciated.

View 1 Replies View Related

Problem With Owners. Urgent Help Needed

Apr 28, 2006

Hi everybody!
I create my database by restore from server’s backup. Every object there is owned by dbo77 user. I want to execute stored procedure in following way: exec sp1 and not – exec dbo77.sp1, when I connect with the same user. I create new Login – dbo77 in Securities folder of my server (LOCAL). And when I connect by this user to that database, I still can’t use syntax: exec sp1.
An error says that my login dbo77 does not have an associated user name. When I try to mark that database in dbo77 ->property->Database_Access it writes an error that dbo77 already exists.
How can I make this db work with syntax exec sp1, if I login with same login name as the owner of sp1?

View 11 Replies View Related

Urgent Help Needed - Creating A Trigger?

Feb 16, 2007

I want a stored procedure to run everytime the batch Status field is set to 'Released'


<Code>
CREATE TRIGGER [CSITSS].[tdecker].[FB401BV_TRIGGER] ON [CSITSS].[dbo].[Fbbatch] FOR UPDATE [Status]

AS


DECLARE @RC int
DECLARE @Batch int

SET @Batch = (??? BATCH NUMBER THAT WAS SET TO RELEASE ???)

EXEC @RC = [CSITSS].[tdecker].[GLP_FB401BV_BATCH] @Batch

</Code>

View 9 Replies View Related

Urgent Help Needed -- Database Mirroring

Jun 20, 2008

Seek expert’s advice on database mirroring
in high safety mode when safety is full if for some reason communication between principal and mirror is broken for say 2 days then principal will keep working but in disconnected mode. When communication link will establish again then principal can see the mirror server
1. Will establish the mirroring automatically?
2. Then will it synchronise the mirror databases automatically?
3. If it will synchronise databases automatically then principal will process transaction
or wait till principal-mirror will be in synchronised state which again depends on
number of transaction need to redo on mirror?

Thanks in advance

View 4 Replies View Related

Help With Stored Procedures Needed -- URGENT

Jul 20, 2005

Hi all!I am in need of writing a few stored procedures.The first one is to create a stored procedure to recover a databasefrom backup and the second one is to create a stored procedure toexecute a transaction log backup (even though I know this can be donethrough a maintainence plan). Any help would be greatly appreciated.I know the commands to recover and backup -- but I dont know how toformulate them into a stored procedureThanks in advance!

View 1 Replies View Related







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