Why do you need the DB off line ?

I was suggesting searching jobs and stored procedures for anything related to backup/restore history tables.

John Mitchell-245523 (9/13/2016)

---

I notice this is an old thread, but in case anyone reading it is in a similar position, the steps are much simpler than those recommended above:

(1) Take...

Something deleting backup history for that backup ?

For instance, if you drop a database through the GUI, there's a checkbox default to delete backup history. If someone scripted out the...

Thanks, we're currently running SQL 2005 & 2008 on our servers.

Current licensing costs for SQL have not justified upgrading, since we have a fairly low volume, low traffic web application.

You...

Thanks. I think I will use this variant which worked:

EXECUTE ('update P set P.Email1 = Email1 + ''XYZ''

from MyDatabase.dbo.Profiles P

JOIN MyDatabase.dbo.Complaints EC on EC.ID =...

Pulling the whole table back must be the problem. Thanks.

I think I knew that at one point 😉

I was trying this:

update LinkedServer.MyDatabase.dbo.Profiles

set Email1 = 'XYZ'

from LinkedServer.MyDatabase.dbo.Profiles P

JOIN LinkedServer.MyDatabase.dbo.Complaints C on...

Yes, I mentioned that running the exact code in a SQL...

Thanks for the replies. I know the SP is hitting the correct database, because it completes 1 of the inserts correctly, but just "stops" at the next one.

All I can...

I tried it, no improvement

Do you think that would make a difference in my case ?

All our similar SP code uses VARCHAR.

In case it helps, here the whole SP, with a comment where @SQL_CMD WORKS and @SQL_CMD DOES NOT WORK.

Must be some dumb mistake somewhere.

ALTER procedure dbo.usp_JobMatch_ListTransfer

@Job_ID int...

What's the best way to trap for possible error on the dynamic INSERT statement ?

An earlier dynamic INSERT to a different table in the same database does work, so it's...

All the "@SQL_CMD" are INSERT statements.

The process is for a simple utility for users. They enter some parameters such as Job#, State, and search string. The Stored Procedure does...

Is there an index on date ?

The stored procedure takes input parameters from a user,

truncates a work table,

runs 3-4 queries to re-populate the work table.

Then I want to select 3 columns of data from that...