It was the data file that grew.

Darren

Did you try using an output parameter in your stored procedure?

From BOL:

CREATE PROCEDURE get_sales_for_title

@title varchar(80), -- This is the input parameter.

@ytd_sales int OUTPUT -- This is the output...

Thanks, so I can safely use INIT on the backup because I always will restore from the latest version in my scenario.

Darren

Darren

Nope, they are the same thing. You'll be fine with decimal.

Darren

Have you messed around with using DTS to manually import these tables. You may have to transform the data using VB Script for the data types it is not...

We use numeric(14,2). We rely on our application code to handle all of the rounding. This data type is preferred because "money" is specific to SQL Server and would...

It sounds like you are using a real table not a temp table. How was this temp table created? You should be able to perform a normal delete...

What does "and then changes tab" mean? Is the Sybase db setup as a linked server?

Darren

We figured it out. Somehow the share had been removed on the folder where the backup was restored. Nobody knows how this happened. Has anybody seen something like...

Have you tried running sp_who2 to see what is running and to see if there are any blocks?

If the use of temp tables is slow have you checked if the...

Could you provide a generic example of what you are trying to accomplish? I'm not following what you mean by:

<b>

Is it possible to catch the field that was inserted...

Try putting 2 single quotes around the 2.

... where t_psts LIKE ''2'' ')

Darren

I might have to stick with that approach. I tried testing my approach with Northwind. It wouldn't allow me to copy the .mdf because it says it's in...

I think the attach option will work for us.

Here is how I see it working

1) Backup our Production database

2) detach the previous day's Staging database (this is the restore of...

We do care about it in production, but when we restore it on another server, we don't want it. So how do I do the restore without the log?

Darren