The average rows in the BatchTrans table is usually 400k to 500k (hundred thousand) and ForeignBins is (7500 rows).

The "TransID" field is actually defined as INT in the table. So you suggest changing this to INT in the sproc instead of using decimal? The developer set...

Gilamonster,

Here's the table def and indexes :P:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[BatchTrans](

[TransID] [int] NOT NULL,

[LineNum] [int] NOT NULL,

[CardTypeID] [smallint] NULL CONSTRAINT [DF_BatchTrans_Temp_CardTypeID] DEFAULT (0),

[CardNum] [varchar](50) NOT...

It's throwing an error inserting into the "WebMenuItems" table.

The error stating incorrect syntax near ')' on those lines for the insert on the "WebMenuItems" table.

Yes, it's part of a bigger batch process. An SSIS package that creates a temp table to insert a key TransID from a header table into a temp table...

It first stated '0 rows affected', THEN it worked.

What would cause that?

I found out that the code being used is actually used to manage when a customer is being worked on in a VB app.

When I ran select on sys.modules it returned this only. What does this actually mean in relation to the sproc in question?

create procedure dbo.sp_MSrepl_startup as ...

It's being called frequently and I'm not sure what it's purpose. I kinda inherited the object when I took over. I know that doesn't really help but I'm...

davidsalazar01 (2/15/2008)

Marios Philippopoulos (2/15/2008)

Is it possible for you to run the package in debug mode using Visual Studio locally on that server?

Yes, it runs fine when I run...

Marios Philippopoulos (2/15/2008)

Is it possible for you to run the package in debug mode using Visual Studio locally on that server? Yes, it runs fine when I run each...

Yes, I can create/delete a file while logged in as domain admin.

Any other suggestions??? 🙂

I'm RDP'd to the server and consoled in. I'm running this package on the actual server and I have access to the local drives. I'm also logged in...

John,

Now that you've explained what read-only actually does. My next question is when I change the database from read-only to an updatable database, how should that be executed TSQL...

I just wanted to know if it was even possible because in order to test it I would have to setup a "roll-your-own" version of Log Shipping just to see...