The other issue with having all the backups in one file is that you lose all the backups if that one file becomes corrupt.

Why wouldn't a restore of the database solve the problem? As long as the corruption did not...

First, you shouldn't use SET ROWCOUNT to control the number of rows affected by your DELETE statement. This functionality has been depreciated and may be removed in future versions...

Turns out the space may not matter (tested here at home), but the parens violated the ALTER TABLE syntax.

Regarding the space, it may really come down to being consistent when...

Duplicate post, please post any replies here.

Please don't double post.

Hoping you are working on this, but thought I should post what I have done.

DECLARE @SourceDatabaseName NVARCHAR(128) = 'MyDatabase';

DECLARE @nSQL NVARCHAR(MAX);

BEGIN

SET @nSQL = '

IF NOT EXISTS (SELECT * FROM '+...

Need the DDL (CREATE TABLE) statement for your #RptParms table and some sample data for the table. Without that, not much we can do.

Also, the code you posted still has a space where you don't want one.

First of all, you didn't provide the complete error messages, no line numbers. Second, this is the sql I have printed:

IF NOT EXISTS (SELECT * FROM MyDatabase .INFORMATION_SCHEMA.COLUMNS ...

You are probably looking for something like this, at least based on what you provided.

CREATE TABLE dbo.Customer(

FlightNbr varchar(50) NULL,

DeptDateTime datetime NULL,

Origin varchar(50) NULL,

Destination varchar(50) NULL,

FirstName...

What are the valid codes for HistoryAction?

Going to add a third agreement to backup local, move to network.

Can you post the code, and the exact error message you are getting?

I can relate but in a different way. One of the bloodest projects I had was automating an invoicing process at a former employer. I was very...

Can't really answer your question about double processing, can't see what you see. Also, we don't have your tables or sample data so we can't run your code to...