Charles

You're right - you don't set the location of the config file in the config file. See my first post above for how you do that.

John

Charles

Not sure I understand. If your variable takes its value from the config file, you should have a line something like this in the file:

<Configuration ConfiguredType="Property" Path="\Package.Variables[User::MyVariable].Properties[Value]" ValueType="String">

...

Yes, if you're running all your backups as scheduled jobs, that's true....

Charles

The config file is specified by right-clicking on the design surface in BIDS and choosing Package Configurations. You can specify a different config file at run-time when running a...

It depends what works best for you. I must admit it's not something I've ever used myself. If you only have the default (PRIMARY) filegroup then there's no...

It depends on the business requirements. If you do log backups every two hours, you're saying you can afford to lose two hours' worth of data in the event...

Not sure. One way you can investigate is by running a Profiler trace when you click on Views in SSMS to see what SQL Server does in the background....

When you say he can't see any views, where is he looking? Are you sure that views actually exist in the database? Can he see tables, functions, stored...

This might work, although it didn't return any rows on my server:

WITH Partitioned AS (-- Partition into separate items

SELECT

ServerName

,Instance

,Name

,Value

,ROW_NUMBER() OVER (PARTITION BY ServerName, Instance, Name ORDER BY Date DESC) RowNo

FROM

tempserverConfig

)

,MostRecent...

OK, well done. Just one comment. If you use the same column (episode number) in your ORDER BY and PARTITION BY clause, you're saying that you're not bothered...

You need to use the ROW_NUMBER function with a PARTITION BY clause.

John

What port is SQL Server on PC1 listening on? If it's not the default, and if you don't have SQL Browser running on PC1, then you need to specify...

I don't imagine so, but I wouldn't swear to it. Somebody else may have an answer.

John

Have a read about cross database ownership chaining and post back if there's anything you still don't understand.

John

And what does that stored procedure do? Does it attempt to send an e-mail? Do you receive the e-mail if you execute the stored procedure outside of the...