"Aren't you still using the 4 part naming in the dynamic SQL?  I don't think that's gonna work unless you try it like this... (although, I certainly could be wrong)..."

Thanks...

For some reason this is a common question and I know of almost no one who knows how to do this.  It's simple really but you have to make...

"Also available memory is ok."

How do you know that?  More importantly do you know if SQL Server has enough RAM?

Have you deleted or renamed the existing backup file prior to running your SQL statement?

When you restored the header did you restore the headers for all backup sets in the...

Take a look at the following hotfix and verify that it has been applied:

http://support.microsoft.com/kb/899761

It seems to me that the analogies are more difficult to understand than what they are meant to help explain.  It seems the disconnect is simple, someone is mistakingly thinking...

From SQL Server Books Online:

EXPIREDATE = { date | @date_var }

Specifies the date when the backup set expires and can be overwritten. If supplied as a variable (@date_var), this...

I've been working in the IT business since before the days when everyone and their brother were touting this new language that wasn't quite as fast...

Then you are looking for a kludgy solution to a kludgy problem.  I personally perfer something like Anders' idea in this case.  My approach is always to look for the...

There are a couple of general tips I can share with you.

• Before beginning the data transfer from the old database to the new database, drop all indexes in the new...

"or is this just an example?"

It's an example.

"Has anyone attempted to do this (copy backups from one server to another and then restore via schedule job)? Thanks."

I do just that...

That query should work fine, the only guess I have is the way you are calling it.  Try the following:

exec PROD1.ToLIM.dbo.ToLIM_ExtractIndex @vDB, @vDBTable, 'CIN.CINERGY_LOAD',   'CIN.ESAL_LESS_ORPHAN', 'HOURLY_COLUMNS', '1999-01-01', '2005-03-03'

SQL Server is...

I really shouldn't since I'm repeating myself but the answer to your question lies in other questions you might have not answered yet.  You need to identify the queries most...

If you are simply looking to determine whether the verification failed, you don't need to get anything back from dynamic SQL, you get something by default as the @@ERROR variable will...

Ben is correct, add a linked server and simply use an insert, however, Ben's syntax isn't quite right.  The following is though:

insert [DMO1\DMO].Employees.dbo.Employee

select * from Employee where empid='729'

Assuming the following:

Server name:...