Are the client tools on your PC of a more recent version than your server? Sounds like you may have upgraded your package when you edited it, and now...

Yes, or if you're feeling brave, you could change the DatabaseBackup stored procedure to include the logic in there.

John

Tom

I think you need to change the precedence constraint between C and D so that it evaluates to True on Success OR if @Variable = True (where @Variable is the...

Well, I did say something like that! Just change the ASC to DESC - that should fix it.

John

Second one looks OK. Something like this for the first:

WITH RowNos AS ( -- order within groups in descending date order

SELECT ROW_NUMBER() OVER (PARTITION BY grp ORDER BY dt...

I can't think of any way you could change the owner and carry on with log shipping afterwards. The database will always have to have the same owner as...

Looks like a homework question. Hint: left join the first table to the second, and use COALESCE, ISNULL or CASE to return Small or Large in the second column.

John

Not sure whether cross database ownership chaining[/url] would help here? Make sure you understand the risks before you do it.

John

In the ForEach Loop properties, have you mapped the ConnString column of your @Sourcelist result set to your @Connstring variable. Is the @Connstring variable used to set the value...

Yes, and if you don't know the answer to a question, be honest about it! If you can throw something in about how you'd find the answer, or what...

Chowdary

Have you tried denying the VIEW DEFINITION permission?

John

I don't know what happens to the node after you evict it - whether it still has the SQL Server binaries on. I would recommend rebuilding the whole computer,...

Like Perry says, you can't uncluster your instance. What you can do is evict nodes from the cluster until you have a single-node cluster. Would that meet your...

You're right - they won't. So upgrade your packages, but keep copies of the old ones. Run the upgraded ones on your new servers, and the old ones...

Why do you not want to upgrade your packages? All you should need to do is open them in the version of SSDT that comes with SQL Server 2014...