Perry Whittle (8/30/2012)

---

They do indeed differ, although this does somewhat limit the options

Interesting and never tried it, but SQL Server 2012...

The real problem here though is that the OP never confirmed if the table names actually exist in the database. None of these three tricks will work if they...

Right, this second wave of methods is similar to what I had in mind when I asked the OP "If the queries are all truly valid (i.e., actually compilable, with...

Note also, that whatever account you execute the Restore under will become the Owner (and thus, DBO) of the Secondary. This cannot be changed later on, it can only...

OK, here's a template of the command that I use:

RESTORE DATABASE [<YourDbName>]

FROM DISK = N'D:\Database_Backups\<YourDbName>_copy.bak'

WITH FILE = 1,

MOVE N'<LogicalDataFile_1>' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\<YourMDF_1>.mdf',...

Yes, if you do it correctly.

Hmm, I might have a procedure around here somewhere for doing that ...

And do the secondary databases need to be writeable as well, or can they be Read-Only copies?

(the reason for all of these questions is that there are over a dozen...

Hmm, actually that's a pretty complicated example, plus...

RBarryYoung (8/30/2012)

---

As someone who has written many "automation" procedures like this, this is a good first effort emreguldogan. Here are some improvements that you could make:

1. Removal of the...

As someone who has written many "automation" procedures like this, this is a good first effort emreguldogan. Here are some improvements that you could make:

1. Removal of the Cursor...

Lowell (8/30/2012)

---

i get very few false positives when i go after my procedure and function definitions using that technique:

SELECT definition,T1.*,T2.* from sys.sql_modules

CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T1

CROSS APPLY dbo.DelimitedSplit8K(definition,' ')...

Geez, I go to bed, get up, and there's twenty new posts!

Anyhoo...

dwain.c (8/29/2012)

---

RBarryYoung (8/29/2012)

---

Unless the queries all strictly follow the same very simple format, this is going to fall somewhere...

Hmm, I almost never use the GUI ...

I think that you should probably enter the primary MDF. It contains the locations of all of the other MDFs, so that...

What error do you get?

Try it like this:

begin

begin try

begin transaction

update fo_run_date

set fo_act_run_date = '123';-- <== this is int going into datetime field

commit transaction;

end try

BEGIN CATCH

DECLARE @ErrorMessage NVARCHAR(4000);

DECLARE @ErrorSeverity INT;

DECLARE @ErrorState INT;

Declare @ErrorLine int;

Declare @ErrorNumber...