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...

So what are the results? What did you see when you compared the SET options for the two clients?

John

CELKO (9/4/2014)

Attribute splitting. You take a whole entity, and break it into multiple tables. Personnel gets split n sex_code to become {Male_Personnel, Female_Personnel }. The parts are constantly being re-assembled...

Something like this might work. It's probably not the most efficient. It's not tested because of the lack of DDL and sample data. You need a numbers...

What is the exact command that is being passed to SQL Server? What happens if you run the exact same command from SSMS?

John