What permission does the user have, if not sysadmin? To manage jobs, membership of certain role(s) in msdb is necessary.

John

And your question is?

It's best to run SSMS on the computer on which the package resides when you're setting up SSIS jobs. If you run it on a client...

Suresh

Please will you post the query? What is the difference in the number of rows? Is anyone else using the database? If you drop the index and...

Put a [font="Courier New"]PRINT @q[/font] in your script and you'll see why that's happening.

John

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