I thought I'd pretty much said...

I'd be very, very cautious with this in place upgrade since you performing both OS and SQL.

Ensure all databases are backed up and kept off the server. Also consider...

Is the tables primary key an identity?

Do you have an inserted date column with associated index?

Can the table be partitioned on a daily basis?

Both having/adding an identity column and an...

I've used a few in the past. CHECKSUM when I only had to monitor modifications to a few columns. Timestamp is another method.

A trigger could work but I'm...

The commands are marked as...

You are right in that you cannot replicate from a logshipped database.

a) You could logship both databases

b) If the dbs could be mirrored and if needed to be readable,...

You could consider using the MERGE combined with this kind of update.

SELECT CASE WHEN DATEPART(qq, GETDATE()) = 1 THEN 'VALUE'

END

...

I was clutching at straws a bit, but the only time I could consider using the trial editions in a production environment would be to show a proof of concept...

I think this is it.

SELECT c.OriginalVendorNumber

, c.InvoiceNumber

, c.InvoiceDate

, c.AbsoluteAmount

...

Can you replicate the data to a different database and modify the view to access cross-database?

The only way is to drop and rebuild the publication.

If you can restrict access to the publisher and subscribers, you can drop, rebuild and add the subscribers as @sync_type='none' or...

If you replicate views or stored procedures, you are replicating the object definition, not data.

It will display only what is in the local DB (assuming you have all the dependant...

Junglee_George (11/19/2013)

---

I have a select statement in my existing SP, which is not working:

select IsNull(St.alternateStudyCode, St.studyCode) AS StudyCode,* from Studies St

I hope it is not working because, alternateStudyCode and...

I agree with this, the wait stat is related...

You could use last years full backup 🙂 provided you have all of the transaction logs since then so it doesn't matter if the latest full backup hasn't completed yet.

You...